Brenkenathan
Board Regular
- Joined
- Sep 19, 2002
- Messages
- 146
I see similar posts but nothing that directly answers my question so I am going to ask.
I receive several pdf documents a day that I have to copy and paste into csv file and then import into another application.
How would I go about writing a Macro that automates this exact process and automatically puts the correct fields in the right places.
The template of the pdf document is the exact same everyday except for the text in specific portions.
All portions are labeled and data that is requiring more than one answer is separated appropriately
Example:
Subject: Subject Text
Numbers: Number1, Number2, Number3
Sample:
Sample1
Sample2
Sample3
For each Number or Sample I have to have it create a new line in the csv file with with the Subject Text as the first field.
Can anyone help me or point me in the right direction?
I receive several pdf documents a day that I have to copy and paste into csv file and then import into another application.
How would I go about writing a Macro that automates this exact process and automatically puts the correct fields in the right places.
The template of the pdf document is the exact same everyday except for the text in specific portions.
All portions are labeled and data that is requiring more than one answer is separated appropriately
Example:
Subject: Subject Text
Numbers: Number1, Number2, Number3
Sample:
Sample1
Sample2
Sample3
For each Number or Sample I have to have it create a new line in the csv file with with the Subject Text as the first field.
Can anyone help me or point me in the right direction?
