New Forum | Previous | Next | (P-PDF) Developers
Topic: Excel 2002 VBA Control of Acrobat 6 (standard)
Conf: (P-PDF) Developers, Msg: 94484
Date: 8/15/2003 09:52 PM
I'm trying something I think should be very simple in Excel 2002 VBA but I'm stuck. All I want to do is call an Acrobat routine to save the current (1 sheet) Excel document to a PDF file. I don't want Acrobat to prompt me for the output file location and I don't want Acrobat to load and show me the file after it's created and, as my Excel file is protected by a password, I don't want the routine to open my file after the conversion (as the password request screen is displayed).
So far I have managed to create the PDF file but then Acrobat opens up to show me the damn thing and also opens the original doc in Excel and asks for a password!