nardagus
Active Member
- Joined
- Apr 23, 2012
- Messages
- 317
- Office Version
- 2016
- 2013
- Platform
- Windows
Hello All,
Recently I have received some PDF files with XML attached. Of course when I double click on it it will open in a text editor. Cool.
However. What I need to do is:
1) Open PDF
2) Extract XML attachment
3) Import it to a worksheet
4) Close PDF
5) Open another PDF
6) Extract XML attachment
7) Append it to the same worksheet from point 3
8) Close PDF
9) Loop until all PDF files where processed in a chosen folder
I know how to process all files in a folder. I also know how to import a file to a worksheet.
What I don't know is how to extract XML attachment from PDF.
Any ideas?
Regards,
Recently I have received some PDF files with XML attached. Of course when I double click on it it will open in a text editor. Cool.
However. What I need to do is:
1) Open PDF
2) Extract XML attachment
3) Import it to a worksheet
4) Close PDF
5) Open another PDF
6) Extract XML attachment
7) Append it to the same worksheet from point 3
8) Close PDF
9) Loop until all PDF files where processed in a chosen folder
I know how to process all files in a folder. I also know how to import a file to a worksheet.
What I don't know is how to extract XML attachment from PDF.
Any ideas?
Regards,
