Re: Saving an Excel worksheet as a .pdf file
Re: Saving an Excel worksheet as a .pdf file
- Subject: Re: Saving an Excel worksheet as a .pdf file
- From: Axel Luttgens <email@hidden>
- Date: Tue, 16 Dec 2014 23:47:13 +0100
Le 16 déc. 2014 à 22:52, Bill Guion a écrit :
> I'm trying to create and save an Excel worksheet as a .pdf file. The script below is my current attempt. I have removed all of the Excel manipulation portion of the script to help focus on the file save portion. The manipulation portion works just fine. The script starts by prompting me for a csv file. The display dialogs all show the values I expect for the various values. The script runs without error, but no file is saved. I would really appreciate someone pointing out my errors.
Hello Bill,
Some quick thoughts...
>
> [...]
> -- define folder to save .pdf into
> set pdfSavePath to "/Macintosh HD:Documents:pdfs:" as string
I would remove the initial slash here, as well as the unneeded "as string" part:
set pdfSavePath to "Macintosh HD:Documents:pdfs:"
> [...]
> try
> save active sheet in fullName as PDF file format
According to Excel 2011 dictionary, I would be tempted to try this one instead:
save as active sheet filename fullName file format PDF file format
> end try
> end tell
HTH,
Axel
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden