Menu
Exporting to Text Files Using the Open Statement to Create a File Using FreeFile to Determine the Next Available File Using Print # to Loop Through a Recordset and Output Using the Close Statement to Close the File. Database Access with Visual Basic. Sep 25, 2018 - JW Hey, JW. Create Pdf File From Vb6 String Replace. As we've found out numerous times when dealing with text files, there is no obvious.
Experts,I am hoping you can help me with an issue. I have about 200 single page invoices that are all in PDF format, each unqiue with an invoice#, person's name, etc. They come out of access as one document, I am able to split them into single pages very easily using adobe pro, but of course it just names them, invoice_1, invoice_2, invoice_3, etc.....
My goal is to rename each file to the actual invoice#, by parsing the PDF file and pulling the invoice#. I have been able to find code that will do a 'find' within a PDF (which I will attach). However, I will have no idea what the invoice number will be so, that won't work. My hope as to find the text 'Invoice#' and then pull the 8 characters to the right of that, thus giving me the invoice# that I need and then use vbscript to rename the file, which I already know how to do. I just can't seem to figure out how to do the text manipulation within vbs with the Adobe object. If it were TextStream Object it would be a piece of cake. I know there are a few ways to convert the PDF to text and then read it, but I was hoping there was a simpler way. Also, if I could do it without actually having adobe open on my screen that would be a bonus. Another point, I have access to Adobe Pro and Adobe reader, either is fine.
![Handling Handling](/uploads/1/2/5/8/125859976/860374027.jpg)
![Create pdf file from vb6 string handling software Create pdf file from vb6 string handling software](/uploads/1/2/5/8/125859976/393632779.png)
Thanks,
Mike
|