Outlk 2k3 Script: Saving Excel File programticaly from OUTLOOK SCRIPT

N

news.microsoft.com

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
 
N

news.microsoft.com

After many try I use this

objExcelApp.Save "D:\MyResult.xls"

It open's me an Excel confirmation Window for Saving the file

I want to save the file automaticaly without asking the user

Tks
 
S

Sue Mosher [MVP-Outlook]

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

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
N

news.microsoft.com

Tks a lot Sue, it work Fine


Rds

Sue Mosher said:
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

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top