Changing excel, updating word and printing in PDF 800 times, pls help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

GastonFranzini@gmail.com - 03 Apr 2006 13:55 GMT

Hi, I need serious help...
I'm working on a macro that changes a field in an excel file, and then
it opens a word document wich updates, and then saves it. It works ok
by now but...
The problem is that I need to print it to PDF, and then return to the
excel and change a field.
Is that possible? Do you know any limitations?
Thanks

Reply to this Message

Jezebel - 03 Apr 2006 14:05 GMT

1. Set Acrobat (via its properties dialog) not to prompt for the file name
and not to display the completed PDF.

2. Make Acrobat the default printer.

3. Create the documents and print as you go.

> Hi, I need serious help...
> I'm working on a macro that changes a field in an excel file, and then
[quoted text clipped - 4 lines]
> Is that possible? Do you know any limitations?
> Thanks

Reply to this Message

GastonFranzini@gmail.com - 03 Apr 2006 16:04 GMT

Thanks,
What about the file's name? and its location?

Reply to this Message

Jezebel - 03 Apr 2006 22:44 GMT

This varies between versions of Acrobat. Filename will be the same as the
Word document, with pdf extension. Location is either the same folder as the
Word document, or a standard location set on the properties dialog.

> Thanks,
> What about the file's name? and its location?

Reply to this Message

GastonFranzini@gmail.com - 04 Apr 2006 16:09 GMT

Thanks a lot Jezebel

Reply to this Message