hi Experts,
Please advise is there any option to schedule for particular time to macro
for execution on its on own without manual intervention.
if so please advise in this concern.
Thanks,
Rekha
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles.
Search the net for Application.OnTime
Regards,
Sam Mathai Chacko
On Sun, Dec 4, 2011 at 3:25 PM, rekha siri wrote:
> hi Experts,
>
> Please advise is there any option to schedule for particular time to macro
> for execution on its on own without manual intervention.
>
> if so please advise in
Sub Test()
Application.onTime now+timevalue("00:30:00"),"ProcedureName"
end sub
it means after 30 minute from now procedure "ProcedureName" will Execute.
On Sun, Dec 4, 2011 at 5:39 PM, Sam Mathai Chacko wrote:
> Search the net for Application.OnTime
>
> Regards,
>
> Sam Mathai Chacko
>
>
> On Sun
hi Rajan /sam,
thanks for the reply please advise will it execute without opening the
macro or we need to open the macro sheet and then fix the reminder.
Thanks,
Rekha
On Sun, Dec 4, 2011 at 7:00 PM, rajan verma wrote:
> Sub Test()
> Application.onTime now+timevalue("00:30:00"),"ProcedureName"
Hi Rekha,
If you create a "*shortcut*" of your excel file in startup folder, then it
will open automatically on window startup.
Find the startup folder in below path:
*Windows7 ==> "**C:\Users\(User-Name)\AppData\Roaming\Microsoft\Windows\Start
Menu\Programs\Startup*"
*Windows Xp ==> "C:\Document
I have tried this using the following steps
1. Calling the function in workbook.open event
2. Create a batch file which will open the excel file
Sample Batch file:
cd "c:\Program Files\Microsoft Office\Office12\"
EXCEL.EXE "c:\Test.xlsm"
3. Using windows scheduler you can create a new schedul
yes we need to open that file and Run that macro to create schedule
for any other macro..
Write that code on workbook_open events . so that when we open that
workbook.. its automatically triggered and create Schedule .
Rajan
On 12/5/11, Gangaram. wrote:
> I have tried this using the following
