Thank you for your response. All of the conversion formats I have seen thus far are too inconsistent even to write code to clean up. PDF to Excel is the program I found that comes the closest, but it puts the retail pricing and sales pricing in different columns randomly. I attached an example of what I am referring to.
The ideal situation is to include VBA code to download a fresh copy of teh PDF every month, but that is going to be more of a nice-to-have feature vs a necessity for this project.
|