Re: Saving a MS Excel Document as webpage
Re: Saving a MS Excel Document as webpage
- Subject: Re: Saving a MS Excel Document as webpage
- From: Jay <email@hidden>
- Date: Sun, 20 Jul 2003 00:58:50 -0500
Hi Graham,
Here's a possible solution. Write a macro and save it in a 'Personal
Macro Workbook'. I used this example for my code in the personal macro
workbook:
--------------
Sub saveforweb()
ActiveWorkbook.SaveAs FileName:= _
"Macintosh HD:Users:jay:Desktop:" & ActiveWorkbook.Name &
".htm", FileFormat:=xlHtml
End Sub
--------------
Then in AppleScript, run something like this:
--------------
tell application "Microsoft Excel"
Activate
Evaluate "'Personal Macro Workbook'!saveforweb()"
end tell
--------------
This should run the macro for you and save your frontmost Excel file as
a web page. It's definitely not perfect, but might do what you need.
Hope it helps.
Jay
On Friday, July 18, 2003, at 05:10 PM, Graham Carter wrote:
>
Hello All,
>
>
I am trying to save a MS Excel Document as HTML. When I try recording
>
a script I get:
>
>
Save Workbook In "Macintosh HD:Library:WebServer:Documents:index.html"
>
As +constant &wff#htm;
>
>
This script gives me the error "Workbook does not understand the save
>
message." I can save it as xlNormal however. I am able to save as
>
HTML with an Excel Macro in which case I save the workbook as xlHTML.
>
But when I try the type xlHTML in applescript it treats it as a user
>
defined variable.
>
>
Any insights?
>
>
Thanks,
>
Graham
>
____________________________
>
>
Graham Carter
>
Systems Analyst
>
Long Beach Memorial Heart Institute
>
Phone: (562) 933-3335
>
Pager: 3-17773
>
_______________________________________________
>
applescript-users mailing list | email@hidden
>
Help/Unsubscribe/Archives:
>
http://www.lists.apple.com/mailman/listinfo/applescript-users
>
Do not post admin requests to the list. They will be ignored.
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.