|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
November 22nd 06, 10:01 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
Outlk 2k3 Script: Saving Excel File programticaly from OUTLOOK SCRIPT
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 |
|
#2
November 22nd 06, 11:56 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Outlk 2k3 Script: Saving Excel File programticaly from OUTLOOK SCRIPT
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 "news.microsoft.com" a écrit dans le message de news: ... 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
|
|
#3
November 22nd 06, 02:50 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
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
|
|
#4
November 22nd 06, 04:33 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
|
Outlk 2k3 Script: Saving Excel File programticaly from OUTLOOK SCRIPT
Tks a lot Sue, it work Fine
Rds "Sue Mosher [MVP-Outlook]" a écrit dans le message de news: ... 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
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Outlk 2k3 Script: Find and findNext use | news.microsoft.com | Outlook and VBA | 1 | November 21st 06 03:44 PM |
| Outlk 2k3 script: How to get the name of the month | news.microsoft.com | Outlook and VBA | 2 | November 21st 06 03:35 PM |
| Outlk 2k3 Script: Pb Using Find function Help plz!!! | news.microsoft.com | Outlook and VBA | 1 | November 15th 06 04:40 PM |
| Outlook 2k3 Script: Pb While exporting to Excel | news.microsoft.com | Outlook and VBA | 1 | November 14th 06 06:24 PM |
| Outlook 2k3 Script: Pb saving data in custom item | news.microsoft.com | Outlook and VBA | 1 | November 8th 06 03:49 PM |
Linear Mode
