So this logic gets you the download, Shane, and puts it in ProductCatalog.pdf if I'm not mistaken, but you're trying to figure out how to extract the relevant data from the download and put it into one or more Excel worksheets?
Well, I certainly wouldn't try to write a VBA program to do the conversion itself; the inside of a .pdf is just garbage. (Not literally, of course.) So you're talking about getting VBA to fire up a conversion program, then read in the translation.
To do that you need a program that'll do the conversion. Do you have one in mind? I remember you talked about this before, but I don't remember whether you decided anything.
|