VBA to Find and Copy text from PDF to create Table in Excel

I’m trying to automate the very repetative and consistant process of finding the Month, Title, and Cost from a PDF file and pasting it into a large table in Excel. The goal is to find the text “Month: ” on each page of the 200ish page PDF, copy the 6 characters following it, and paste it into each cell of a colum in an Excel Table (the table is already created), and then do the same with the 4 characters folowing “Title: “, and then any characters  after “Totals: ” and before “.00” (which could be anywhere from 1 to 8 characters, all numeric). To create a table 3x200ish which I can then sort and find the data much more efficiently. I’m fairily new with Macros, and I’m having trouble finding where to start my search for the code I need. Most code I’ve found involves opening a number of pdfs and searching for true or false results. I only have one very large PDF that’s already open and will always have the same document name.

I would imagine in lamens terms it would look something like the below, but I don’t know the exact VBA language to use.

Activate “PDF_Title.pdf” | Find “Month: ” | Select (6 characters following – this seems like it might be a more complicated part of the code) | Copy Selection | Activate “Excel_Title.xlsx” | Activate (Next Blank cell in Column A – I think I know how to do this bit) | Paste from Clipboard | Loop until End of Document

Any assistance would be a huge help!

By: Natasha Gossman

2,423 thoughts on “VBA to Find and Copy text from PDF to create Table in Excel

  1. Assistir Tv Ao Vivo Pelo Celular

    Ponto IPTV a melhor programacao de canais IPTV do Brasil, filmes, series, futebol, lutas, shows, documentarios em alta definicao de imagem e som em SD, HD, FULL HD, 4K. compativel com todos aparelhos do mercado Brasileiro.

  2. Sibutramine kaufen

    Hello! Do you know if they make any plugins to assist with Search Engine Optimization? I’m trying to get my blog to rank for some targeted keywords but I’m not seeing very good results. If you know of any please share. Thanks!

  3. CN Gadget

    You made some really good points there. I checked on the web to learn more about the issue and found most people will go along with your views on this site.

  4. drug rehab

    Residential Substance Abuse Treatment Rehab For Alcohol Abuse [url=https://alcoholrehabnearmeusa.com]alcohol rehab near me[/url] Alcohol Recovery Near Me Inpatient Rehab Centers Near Me

  5. Acheter Sibutramine

    Wonderful blog! I found it while searching on Yahoo News. Do you have any tips on how to get listed in Yahoo News? I’ve been trying for a while but I never seem to get there! Appreciate it

  6. Argelia Reppond

    Hiya, I’m really glad I’ve found this information. Nowadays bloggers publish only about gossips and net and this is actually frustrating. A good web site with interesting content, this is what I need. Thank you for keeping this site, I’ll be visiting it. Do you do newsletters? Can not find it.

  7. anabole steroide bestellen

    Pretty section of content. I simply stumbled upon your website and in accession capital to say that I get actually loved account your blog posts. Anyway I will be subscribing in your feeds and even I fulfillment you get admission to constantly quickly.

  8. spritze anabole steroide kaufen

    Great – I should certainly pronounce, impressed with your website. I had no trouble navigating through all tabs as well as related information ended up being truly simple to do to access. I recently found what I hoped for before you know it at all. Reasonably unusual. Is likely to appreciate it for those who add forums or something, site theme . a tones way for your customer to communicate. Excellent task..

  9. Reductil kaufen

    Excellent post. I was checking constantly this blog and I’m impressed! Extremely useful information specifically the last part 🙂 I care for such information a lot. I was looking for this particular information for a very long time. Thank you and good luck.

  10. Buy Phentermine online

    Hi there, i read your blog occasionally and i own a similar one and i was just wondering if you get a lot of spam responses? If so how do you protect against it, any plugin or anything you can suggest? I get so much lately it’s driving me insane so any help is very much appreciated.

  11. Melanotan 2 bestellen

    I like the helpful information you provide in your articles. I will bookmark your weblog and check again here regularly. I’m quite sure I will learn a lot of new stuff right here! Best of luck for the next!

Comments are closed.