Thread: Outlk 2k3 Script: Saving Excel File programticaly from OUTLOOK SCRIPT
View Single Post
  #3  
Old November 22nd 06, 01:50 PM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
  
Posts: 11,651
Default Outlk 2k3 Script: Saving Excel File programticaly from OUTLOOK SCRIPT
ActiveWorkbook.SaveAs Filename:="D:\theName.xls" (this last code in VBA
code isn't available in outlook script)

Yes, it is. You just can't use named arguments in vbscript:

objExcelApp.ActiveWorkbook.SaveAs "D:\theName.xls"

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

"news.microsoft.com" wrote in message ...
Hi All,

Finally I found the way to export my data from
outlook to Excel Programtically, the last thing I miss
is to save this excel file on a network HDD

I tryed
ObjExcelApp.SaveAsfile
ObjExcelSheet.SaveAsfile

ActiveWorkbook.SaveAs Filename:="D:\theName.xls" (this last code in VBA
code isn't available in outlook script)





tks for help
Ads