Thread: PDF to Excel
View Single Post
 
Old 01-29-2014, 09:21 AM
BobBridges's Avatar
BobBridges BobBridges is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: May 2013
Location: USA
Posts: 700
BobBridges has a spectacular aura aboutBobBridges has a spectacular aura about
Default

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.
Reply With Quote