I have an excel file in which I have a macro that creates a series of PDF files via the ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _ command.
I end up with files such as main file, temp1, temp2, temp3, temp4, temp5, temp6, temp7, temp8 and temp9. What I would like to do now is combine these files into a single file with the same name as the main file. I am attempting to do this with PDFCreator version 1. I can do it just fine manually, but I would like to be able to do it via the same macro that creates the files. So far, I have added PDFCreator as a reference in the tools, reference in VBA. I then go into object browser and can see the diffent objects that are available, but none of them have a description of what they do so I am at a loss at to which commands will help with the task I am attempting. (If anyone knows of a resource that explains the objects I would appreciate it if you point me in that direction. A goggle search has come up empty for me so far.)
What I am in need of help with is this:
Either help creating a macro that loads the existing files into PDFCreator, combines them all into one file, then outputs them as a PDF file with the same name as the main file
or
help creating a macro that gets rid of the command I am using and instead sends the files to the PDFCreator print queue and then combines them and outputs them with the selected name.
Thank you in advance!
I end up with files such as main file, temp1, temp2, temp3, temp4, temp5, temp6, temp7, temp8 and temp9. What I would like to do now is combine these files into a single file with the same name as the main file. I am attempting to do this with PDFCreator version 1. I can do it just fine manually, but I would like to be able to do it via the same macro that creates the files. So far, I have added PDFCreator as a reference in the tools, reference in VBA. I then go into object browser and can see the diffent objects that are available, but none of them have a description of what they do so I am at a loss at to which commands will help with the task I am attempting. (If anyone knows of a resource that explains the objects I would appreciate it if you point me in that direction. A goggle search has come up empty for me so far.)
What I am in need of help with is this:
Either help creating a macro that loads the existing files into PDFCreator, combines them all into one file, then outputs them as a PDF file with the same name as the main file
or
help creating a macro that gets rid of the command I am using and instead sends the files to the PDFCreator print queue and then combines them and outputs them with the selected name.
Thank you in advance!