I am seeking assistance on best technique to extract/download PDF documents that are embedded to an excel worksheet. So that the extracted PDF's can be uploaded to another application.
Each embedded PDF will be positioned and named uniquely at time they are embedded to excel and will be associated with a specific row of cells/data with the worksheet to which they are embedded.
Extracting the worksheet data to a collection is no issue.
I could add some VBA to the workbook that could be called by Blue Prism to handle the successful extract and download of each embedded PDF to local drive etc.
If this is the best technique, please advise how the VBA procedure should be called from BP.
Otherwise is there a better technique that BP can execute to achieve the same outcome ?
Thanks
------------------------------
DT
------------------------------
