1 BEST ANSWER
Helpful Answers
Hi Dhen
I've been retesting the object and i can only recreate the error when i provide incorrect parameters but there are a couple of things you can try. Change the calculation back to Replace([filename], ".mht", "") and the code stage back to wb.SaveAs(filename,51). Once done double check the inputs for the SaveAs code stage match my screenshot below. Save your changes and re-run your process, if you get the same error the next thing to try would be to move the pdf to another folder location for example on your desktop and then run the process again with the new location for the pdf as the input. Should you still have the same issue then try recreating the error directly through excel. You mentioned before that you get the mht output file so with this file open it with excel and then try to save it as an xlsx file to the original folder and see if you get any errors or warnings.
Beyond this I think the only other thing you could do is, since it fails but still produces the mht file, you can then use the standard excel object actions to open this mht file and resave as an xlsx. This will give you what you need it to be, the convert object only seems to fail on the final step of saving the file as an xlsx so as long as you can get the mht file then you only need to add a few steps to your process to get the final output file. See my other screenshot for an example.
------------------------------
Michael ONeil
Technical Lead developer
NTTData
Europe/London
------------------------------
I've been retesting the object and i can only recreate the error when i provide incorrect parameters but there are a couple of things you can try. Change the calculation back to Replace([filename], ".mht", "") and the code stage back to wb.SaveAs(filename,51). Once done double check the inputs for the SaveAs code stage match my screenshot below. Save your changes and re-run your process, if you get the same error the next thing to try would be to move the pdf to another folder location for example on your desktop and then run the process again with the new location for the pdf as the input. Should you still have the same issue then try recreating the error directly through excel. You mentioned before that you get the mht output file so with this file open it with excel and then try to save it as an xlsx file to the original folder and see if you get any errors or warnings.
Beyond this I think the only other thing you could do is, since it fails but still produces the mht file, you can then use the standard excel object actions to open this mht file and resave as an xlsx. This will give you what you need it to be, the convert object only seems to fail on the final step of saving the file as an xlsx so as long as you can get the mht file then you only need to add a few steps to your process to get the final output file. See my other screenshot for an example.
------------------------------
Michael ONeil
Technical Lead developer
NTTData
Europe/London
------------------------------
This is my input:
This is the error when attempting to save the workbook.
------------------------------
Dhenn Mark Espiritu
RPA Consultant
EY
Asia/Manila
------------------------------
This is the error when attempting to save the workbook.
------------------------------
Dhenn Mark Espiritu
RPA Consultant
EY
Asia/Manila
------------------------------
Hello,
Your inputs are correct.
I tried to recreate the same error and I'm able to see the same Index error message. (Note: I'm not able to select any text in the PDF that I tested)
Upon checking reviews on DX couple of folks have reported the same error.
The current version of VBO on DX denotes a beta version.
To test further I took a PDF that was selectable and fully digital so I was able to convert it successfully. Check the snapshots. Also attaching the PDF if you want to try it.
So this might be the limitation that it is able to convert the PDF which is in full digital and selectable format instead of scanned PDF which uses images.
------------------------------
If I was of assistance, please vote for it to be the "Best Answer".
Thanks & Regards,
Tejaskumar Darji
Sr. Consultant-Technical Lead
------------------------------
Your inputs are correct.
I tried to recreate the same error and I'm able to see the same Index error message. (Note: I'm not able to select any text in the PDF that I tested)
Upon checking reviews on DX couple of folks have reported the same error.
The current version of VBO on DX denotes a beta version.
To test further I took a PDF that was selectable and fully digital so I was able to convert it successfully. Check the snapshots. Also attaching the PDF if you want to try it.
So this might be the limitation that it is able to convert the PDF which is in full digital and selectable format instead of scanned PDF which uses images.
------------------------------
If I was of assistance, please vote for it to be the "Best Answer".
Thanks & Regards,
Tejaskumar Darji
Sr. Consultant-Technical Lead
------------------------------
Hello Tejaskumari,
Still doesn't solve the error even I used your own PDF as you attached. My PDFs are not images or scanned PDFs, they are structured and have selectable text and tables as well.
See error below:
The error encountered when going to "Save workbook" code stage. The conversion from pdf to excel was not successful and it just leaving me a ".mht" file.
------------------------------
Dhenn Mark Espiritu
RPA Consultant
EY
Asia/Manila
------------------------------
