Hi Guys!
I have this almost figured out and it works great, except I run into the following errors anytime I open the workbook and have to go through this process of uncommenting and commenting a section of code.
Below is the code:
So when I first run the macro to import the data into the "ImportPDF" worksheet the data looks like ths:Error 20.JPG
So to solve all the data being exported into a single coloumn: This section of code was written:
So I would uncomment this line of code and then re run the macro. I have to run the macro twice. The second time I run the macro I get this error: error11.JPG
Once I get that error, if I comment that code again, and run the macro. The data transfer is perfect and works like a charm. But if I close the workbook, I have to redo the entire process. Does anyone know why that is? or how I can fix this issue?
Bookmarks