PDF files & Excel using VBA
hi,
my name is Saleh My question is I have over 100 PDF files with the same format ,I want a VBA code that can read a specific data line in these files say at line 100 and output the data into an EXCEL sheet. any help please let me know if you need more data, by the way I have full access to these PDF files,it's just I'm trying to find a way to utomate the work. |
PDF files & Excel using VBA
AFAIK, VBA has no commands that can interpret (i.e. "read") a PDF file. Have you searched the
Internet/Google to see if there are other translators available? On Thu, 31 Jul 2003 12:55:58 -0700, "Saleh" wrote: hi, my name is Saleh My question is I have over 100 PDF files with the same format ,I want a VBA code that can read a specific data line in these files say at line 100 and output the data into an EXCEL sheet. any help please let me know if you need more data, by the way I have full access to these PDF files,it's just I'm trying to find a way to utomate the work. |
PDF files & Excel using VBA
Saleh,
it is possible to do this type of thing using macros and the SendKeys statement to copy the text back to excel. If you could send me a couple of the files I could create the macro for you for a small fee. Lynn S - OutOfNoWare "Saleh" wrote in message ... hi, my name is Saleh My question is I have over 100 PDF files with the same format ,I want a VBA code that can read a specific data line in these files say at line 100 and output the data into an EXCEL sheet. any help please let me know if you need more data, by the way I have full access to these PDF files,it's just I'm trying to find a way to utomate the work. |
All times are GMT +1. The time now is 04:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com