Create PDF file from XML file

ScanGuard

New Member
Joined
Mar 4, 2014
Messages
4
Hi there,

I have mapped a drive to a sharepoint folder containing .xml files

I have a project where I need to do the following:-

1. Get a list of files in a folder and show that list in an Excel file, with file name and date stamp of file

2. Convert each file to a PDF file

3. if the file has any attachments (could be no attachments, 1 attachment or more than 1 attachment) save the attachment(s)

4. merge the PDF file that has been created with the attachments, if any that have been saved, and create a new PDF file with the name using the format of date stamp of file as per 1 above in yyyy mm dd format concatenated with the original file name, also as per 1 above.

5. update the original list, as per 1 above, with the new name of the file.

I am not sure how to do this. Any assistance would be greatly appreciated.

Regards
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Forum statistics

Threads
1,215,268
Messages
6,123,969
Members
449,137
Latest member
yeti1016

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top