New Forum | Previous | Next | (P-PDF) Acrobat 6.0
Topic: Create PDF in Excel with a VBA macro
Conf: (P-PDF) Acrobat 6.0, Msg: 116786
From: liberty6142
Date: 8/5/2004 03:54 AM
I developed a macro to make small files from a big file, and now would like to turn them into PDF.
When I use the following line a pop-up window comes up and I have to say "yes".
How can I avoid to have to click "yes"? I just spent the morning looking on the net and didn't find anything.
Application.Run "'PDFMaker.xla'!ConvertToPDFAWorkBook"
I unchecked asked and prompt for file name in Acrobat and Distiller... the window still pops-up. My way to get around it, is to create excel files, and then I all select them at once in explorer and right click on "convert to PDF" (there it doesn't ask me for confirmation).
Would appreciate any help. Thanks.
Joel.
PS Please don't tell me that this is not a development tool.I'm not a developer but a simple excel user.I called Adobe (was ready to pay the $40) but they don't support "macros" :(