Printout Excel 2000 vs 2002

  • Thread starter Thread starter Ragnar Midtskogen
  • Start date Start date
R

Ragnar Midtskogen

Hello,

I have written a VB application that automatically creates many PDF files by
printing them to the Acrobat PDFWriter or Win2PDF printers.
On my development machines with Excel 2000 the process is mostly background,
I do get a 'Pinting blabla to soandso printer flashing briefly for each
file.

On the client's machine, with Excel 2002 the printing also runs
automatically but Acrobat 5 opens and displays each file as it is created.

The syntax is as follows:

oCurrentBook.Printout ActivePrinter:="Acrobat PDFWriter"

I have looked up Excel 2002 syntax it looks the same as Excel 2000.

I have also searched on Google Groups and not found anything useful.

Any help would be appreciated.

Ragnar
 
Ragnar said:
Hello,

I have written a VB application that automatically creates many PDF files by
printing them to the Acrobat PDFWriter or Win2PDF printers.
On my development machines with Excel 2000 the process is mostly background,
I do get a 'Pinting blabla to soandso printer flashing briefly for each
file.

On the client's machine, with Excel 2002 the printing also runs
automatically but Acrobat 5 opens and displays each file as it is created.

The syntax is as follows:

oCurrentBook.Printout ActivePrinter:="Acrobat PDFWriter"

I have looked up Excel 2002 syntax it looks the same as Excel 2000.

I have also searched on Google Groups and not found anything useful.

Any help would be appreciated.

Ragnar
Click to expand...

It's an Acrobat setting. Switch auto-view off in Excel via Print->
Setup-> Adobe PDF Settings-> View Result in Acrobat.
 
Thank you, I take it this feature is only available in Excel 2002? I can't
find that setting in my Excel 2000.

Ragnar
 
Back
Top