How to specify print file in MS Excel 2004?
How to specify print file in MS Excel 2004?
- Subject: How to specify print file in MS Excel 2004?
- From: Richard Rönnbäck <email@hidden>
- Date: Tue, 25 Jan 2005 20:16:14 +0100
I am trying to print each sheet as a separate PDF file in Excel 2004, but I
can't find how to set the name and location of the print file.
Assuming that the Active printer is Adobe PDF (distiller) the code below
will output the file, but is there any way to tell Excel where to put the
file, and more importantly, how to name it?
tell application "Microsoft Excel"
tell workbook 1
set theSheet to worksheet 1
print out theSheet with print to file --active printer "Adobe_PDF"
end tell
end tell
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden