https://community.blueprism.com/t5/Product-Forum/How-to-Extract-download-PDF-documents-embedded-within-excel/m-p/62402#M15517 ​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.<BR /> 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.<BR /> Extracting the worksheet data to a collection is no issue.<BR /> 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.<BR /> If this is the best technique, please advise how the VBA procedure should be called from BP.<BR /> Otherwise is there a better technique that BP can execute to achieve the same outcome ?<BR /> Thanks<BR /><BR />------------------------------<BR />DT<BR />------------------------------<BR /> Tue, 28 May 2019 23:55:00 GMT DT 2019-05-28T23:55:00Z https://community.blueprism.com/t5/Product-Forum/How-to-Extract-download-PDF-documents-embedded-within-excel/m-p/62402#M15517 ​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.<BR /> 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.<BR /> Extracting the worksheet data to a collection is no issue.<BR /> 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.<BR /> If this is the best technique, please advise how the VBA procedure should be called from BP.<BR /> Otherwise is there a better technique that BP can execute to achieve the same outcome ?<BR /> Thanks<BR /><BR />------------------------------<BR />DT<BR />------------------------------<BR /> Tue, 28 May 2019 23:55:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-Extract-download-PDF-documents-embedded-within-excel/m-p/62402#M15517 DT 2019-05-28T23:55:00Z