OS 9 and Saving Excel Work Books
OS 9 and Saving Excel Work Books
- Subject: OS 9 and Saving Excel Work Books
- From: Jason Bourque <email@hidden>
- Date: Mon, 29 Jul 2002 10:41:49 -0400
Does anyone know why won't the below work?
set vDestinationPathXLS to (path to desktop as text)
set vExcelPathName to "Excel Doc.xls"
tell application "Microsoft Excel"
Activate
set AlertBeforeOverwriting to false
set DisplayAlerts to false
set vNewWkbk to Create New Workbook
set vDestinationPathXLS to (vDestinationPathXLS & vExcelPathName as
text)
Save vNewWkbk In vDestinationPathXLS As xlNormal
Close Workbook vExcelPathName
set DisplayAlerts to true
set AlertBeforeOverwriting to true
end tell
Thanks,
Jason Bourque
Co-Director Boston AppleScript Users Group
_______________________________________________
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.