I was investigating how I might be able to automate the retrieval of drawings (OLE images) from PassPort / Portal J. I had a long list of documents in an Excel spreadsheet. Each drawing was already linked to the URL of the PassPort panel that contained the image. My immediate goal was to simply open the image using VBA, then to do a PDF print of the image, and save it under a title from the Excel spreadsheet.
automate the retrieval of drawings (OLE images)
I was investigating how I might be able to automate the retrieval of drawings (OLE images) from PassPort / Portal J. I had a long list of documents in an Excel spreadsheet. Each drawing was already linked to the URL of the PassPort panel that contained the image. My immediate goal was to simply open the image using VBA, then to do a PDF print of the image, and save it under a title from the Excel spreadsheet.