Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how do i call an Outlook Procedures in Excell Macro
i m using onTime method on Excell Module to copy some files from other location
to my desktop on specific time and also i want to call an Outlook procedure within excell macro to email these files but i am unable to call outlook procedures please help Please see the code below. Sub RechargeCopy() Application.OnTime Now + TimeValue("00:05:15"), "FileCopy1" Application.OnTime Now + TimeValue("00:05:30"), "FileCopy2" Dim myOlApp As Object Dim myOlApp1 As Object Set myOlApp = CreateObject("Outlook.Application") project1.Module1.RechargeSending ''error on this line it says object required please help which object should be used to call outlook procedures |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Call Outlook Contacts from Excel Userform | Excel Programming | |||
Call UserForm procedures from another workbook | Excel Programming | |||
Outlook to use procedures written in Excel VBA | Excel Programming | |||
Call Excel Macro from Outlook | Excel Programming | |||
Call SQL Server Stored Procedures with parameters, | Excel Programming |