PelleSnubbelfot
New Member
- Joined
- Feb 18, 2021
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
Hi,
So this is sort of a multiple questions post, i will do my best to get this out in a structured way. New to VBA but learning. So this is what i want to do;
I currently work with placing alot of transportation bookings. I get them all back in PDF-format, and then there's alot of manual labor pulling the correct info out and into other systems/documents.
These different bookings can be placed with multiple different companies, so they all look different. They all contain some of the same data that im after though.
So; Transport company A, B, and C.
What i am hoping for is a way to populate a row of cells with information like "from" and "to" and "reference" which all can be found in these different pdf's.
Can this be done using 3 different macro buttons, one for each company, or is there a better way? Hoping for a way for a macro to recognize the pdf is too much to hope for?
After that i am going to want to use that data to fill in already generated word templates, but i have 30-50 to choose from. Is this doable, and are there any general recommendations to take notice of?
Thank you in advance!
So this is sort of a multiple questions post, i will do my best to get this out in a structured way. New to VBA but learning. So this is what i want to do;
I currently work with placing alot of transportation bookings. I get them all back in PDF-format, and then there's alot of manual labor pulling the correct info out and into other systems/documents.
These different bookings can be placed with multiple different companies, so they all look different. They all contain some of the same data that im after though.
So; Transport company A, B, and C.
What i am hoping for is a way to populate a row of cells with information like "from" and "to" and "reference" which all can be found in these different pdf's.
Can this be done using 3 different macro buttons, one for each company, or is there a better way? Hoping for a way for a macro to recognize the pdf is too much to hope for?
After that i am going to want to use that data to fill in already generated word templates, but i have 30-50 to choose from. Is this doable, and are there any general recommendations to take notice of?
Thank you in advance!