Want to create a separate PDF file for each of multiple charts

J

Jer

I create charts from excel data and want to save each chart in a separate PDF
file or to separate files using "print to file". Presently they all print to
a printer.
 
J

Jer

Sorry I had a syntax error in my directory string. F.Y.I. this works:
Sheets("Graph_Temp").Select
myStr = "O:\Groups\2BTRASH\Goven\GroundWater\" & myWellID & ".PRN"
ActiveWindow.SelectedSheets.PrintOut PrintToFile:="True",
PrToFileName:=myStr
 

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

My charts disappear when I save to PDF 1
PowerPoint Printing PPT to PDF without losing quality 1
printing group of charts 1
printing charts to PDF 1
Create separate pivot chart for each filter 3
Insert multiple .dat files into one pdf without losing color of their graphs 0
Chart Location Impact On Links When Copying To New Workbook 1
Pnting Multiple Charts on Same Page 1

Top