|
| 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
October 1st 06, 10:16 PM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
Call macro stored in Excel workbook from Outlook's macro
I'd like to run macro function "ExcelTestMacro" stored in "C:\Test.xls"
(which is already open), when the new mail massage comes. I can call macro in Outlook from Excel easily for example by : Call ", "Test","C:\test.xls") But I could not call Excel macro from Outlook that way. I allowed access to Visual basic Project and tried: Set MyExBook = Excel.Application.Workbooks.open("C:\Test.xls") call MyExBook.ExcelTestMacro but there appears Run-Time error 'Object does not support this property or method'. Of course I'm doing something wrong... Somebody please help and tell me what to do 
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Importing Outlook Alias info into an excel 2003 macro | fidgitthedigit | Outlook and VBA | 4 | May 31st 06 04:22 PM |
| Importing Outlook Alias into an Excel 2003 macro | fidgitthedigit | Outlook - General Queries | 2 | May 30th 06 02:11 PM |
| Macro to import Excel data to Tasks | Patrix317 | Outlook and VBA | 2 | May 2nd 06 06:32 PM |
| Excel macro to create e-mail in Outlook Web Access | fitful_thought | Outlook - General Queries | 0 | April 15th 06 10:23 AM |
| How do I call a stored procedure inside my sql with a vba script? | Computer Newbie | Outlook and VBA | 1 | March 14th 06 07:08 AM |
Threaded Mode