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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

news.microsoft.com - 22 Nov 2006 09:01 GMT

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

Reply to this Message

news.microsoft.com - 22 Nov 2006 10:56 GMT

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

> Hi All,
>
[quoted text clipped - 10 lines]
>
> tks for help

Reply to this Message

Sue Mosher [MVP-Outlook] - 22 Nov 2006 13:50 GMT

> 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"

Signature

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

> Hi All,
>
[quoted text clipped - 10 lines]
>
> tks for help

Reply to this Message

news.microsoft.com - 22 Nov 2006 15:33 GMT

Tks a lot Sue, it work Fine

Rds

> 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"

Signature

> Hi All,
>
[quoted text clipped - 10 lines]
>
> tks for help

Reply to this Message