I would like to take a pdf form and save it as a flat file using an Excel macro.

I've tried this: Shell MyPath & " /p /h " & Chr(34) & MyFile & Chr(34), vbNormalFocus

But this just prints the document to my printer. I want to print to a file. If I did this manually, I would open the pdf document in Acrobat, open the printer dialogue box, and and use "Adoobe PDF" as the selected printer.

Any ideas? Thank you.