handling the print to file prompt

  • Thread starter Thread starter hke
  • Start date Start date
H

hke

Hi,

I`m sure this has been discussed before but I can`t seem to fin
exactly what I`m looking for in previous threads.

I use a macro to print a chart to file. Excel then prompts with a prin
to file - output filename messagebox. At this point my macro stop
because I haven`t dealt with this. How do, in vba, specify the filenam
thereby completing the process of printing tha chart to file
 
If you have xl2000 or later, you can specify the filename in the Printout
command. See help for details.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel to PDF or XPS boilerplate routines 3
Command Line to Open/Close an Excel Files , macro print it in a designated Folder 1
Replace file without being prompted to save 2
File handling 2
Automatically produce Multiple PDF files from a single chart 1
how to get rid of "^M" in the output file 3
Print files in separate folders-please help 1
Prompt to save as Macro 10

Back
Top