I'm using Able2ExtractPro to convert a PDF into EXCEL by invoking this from a macro-enabled workbook and I want to continue to run the macro on the newly opened "Book1.xls" created by Able2ExtractPro. However, the code operates on my macro-enabled workbook and not on the said "Book1.xls"
How do I make sure that the code runs on the correct workbook and not just the one containing the macro?
My code works if I copy and paste it into the target workbook, but I want to avoid this if possible.
I will want to run this procedure on several open workbooks simultaneously to accomplish my goal.
Cheers, DrEcosse
Bookmarks