Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 141
Default Print to PDF with given filename

i use vb to update many plots and after each update it
will print the current plot to PDF file.

the problem is a window will popup everytime and ask for
a filename to save as pdf.

is there a way i can automate this so all the plots will
be named let say sequentially?

thx.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Print to PDF with given filename

Virtual Port Monitor will do this with Ghostscript as the pdf writer.
http://www.alphatronics.com/AVPMon.html


"Steve" wrote in message ...
i use vb to update many plots and after each update it
will print the current plot to PDF file.

the problem is a window will popup everytime and ask for
a filename to save as pdf.

is there a way i can automate this so all the plots will
be named let say sequentially?

thx.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
set filename to <filename-date on open bob engler Excel Worksheet Functions 2 July 13th 06 05:11 AM
Excel - print to .pdf using filename reference from cell scooppbear Excel Discussion (Misc queries) 1 May 17th 06 02:36 AM
How do I print a filename at the end of the file (not every page) sanfranson Excel Worksheet Functions 2 April 24th 06 04:28 PM
Is there an automatic display/print the filename on sheet in Exce. Geoff F Excel Discussion (Misc queries) 2 April 6th 05 12:39 PM
Saving filename same as import filename Matt Excel Programming 4 February 24th 04 03:01 PM


All times are GMT +1. The time now is 11:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"