beedistinct
Board Regular
- Joined
- Jun 24, 2011
- Messages
- 62
HI - I've written a VBA macro that allows users to select a pdf file via a FilePicker dialogue, it then opens up a shell to execute an pdftotext.exe file to convert pdf to txt. Finally the macro works on the text file line by line using regular expressions to extract the required data before placing them in a given format on the spreadsheet Summary tab.
This is a macro that'll be used by multiple users (> 100).
I need to know what is the best form for this to be published/circulated. I want to ensure that the users are not required to install the pdftotext.exe. It should be available to them behind-the-scenes when they click the button to run the macro.
Can this be achieved via an add-in?
This is a macro that'll be used by multiple users (> 100).
I need to know what is the best form for this to be published/circulated. I want to ensure that the users are not required to install the pdftotext.exe. It should be available to them behind-the-scenes when they click the button to run the macro.
Can this be achieved via an add-in?