J
JanAdam
I need to create many PDF files from many Word and Power Point documents. I
have Acrobat 6.0, Office 2003 pro installed under W2K pro (can have Adobe CS
with the newest Acrobat). In Acrobat 6, there is an option of converting many
files into a single PDF. But I need to convert them one to one. I thus think
I have to do it via vba code, but run into problems.
Following hints from this group I can loop through all the files I need to
convert via:
For Each filFile In fdrFolder.Files
strFileName = fso.GetFileName(filFile)
‘code to convert strFileName to PDF
Next filFile
I am not sure what should be the command to do the conversion. When recorded
a macro to see how it is done, I see that it does not use the file name at
all, but this is a single file conversion from an active word document. Also,
the Acrobat is asking for accepting to save the new file as whatever, which I
would like to automate as well. I have over two hundred files to convert. I
would like to do it like filename1.doc -> filename1.pdf and so on. If the PDF
files could go to a different folder than the source folder it would be nice,
but this is can easily be done manually or via a macro that I think I can
write.
Your help will again be much appreciated.
have Acrobat 6.0, Office 2003 pro installed under W2K pro (can have Adobe CS
with the newest Acrobat). In Acrobat 6, there is an option of converting many
files into a single PDF. But I need to convert them one to one. I thus think
I have to do it via vba code, but run into problems.
Following hints from this group I can loop through all the files I need to
convert via:
For Each filFile In fdrFolder.Files
strFileName = fso.GetFileName(filFile)
‘code to convert strFileName to PDF
Next filFile
I am not sure what should be the command to do the conversion. When recorded
a macro to see how it is done, I see that it does not use the file name at
all, but this is a single file conversion from an active word document. Also,
the Acrobat is asking for accepting to save the new file as whatever, which I
would like to automate as well. I have over two hundred files to convert. I
would like to do it like filename1.doc -> filename1.pdf and so on. If the PDF
files could go to a different folder than the source folder it would be nice,
but this is can easily be done manually or via a macro that I think I can
write.
Your help will again be much appreciated.