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. <sgang...@gmail.com> wrote:
> 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 schedule job and
> mention the frequency and time.
>
> you can find the windows schedular in the following shortcut (Windows
> XP) C:\Documents and Settings\All Users\Start Menu\Programs\Accessories
> \System Tools
>
> Now you are ready the job wlll run with out manual intervention. only
> thing you need to do is you should keep the system up
>
>
> On Dec 5, 1:25 am, Maries <talk2mar...@gmail.com> wrote:
>> 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:\Documents and Settings\All Users\Start
>> Menu\Programs\Startup"
>>
>> *The file should have a *Application.onTime* Macro (As Rajan shown in
>> code)
>> for call your *Target Macro* as per scheduled time.
>>
>> Hence, We can avoid a manual intervention with help of windows startup
>> option.
>>
>> I hope this will clarify clear.
>>
>> Regards,
>>
>> MARIES.
>> +971559828492.
>> *
>>
>> *
>>
>>
>>
>>
>>
>>
>>
>> On Sun, Dec 4, 2011 at 7:57 PM, rekha siri <rekha.siri2...@gmail.com>
>> wrote:
>> > 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
>> > <rajanverma1...@gmail.com>wrote:
>>
>> >> 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
>> >> <samde...@gmail.com>wrote:
>>
>> >>> Search the net for Application.OnTime
>>
>> >>> Regards,
>>
>> >>> Sam Mathai Chacko
>>
>> >>> On Sun, Dec 4, 2011 at 3:25 PM, rekha siri
>> >>> <rekha.siri2...@gmail.com>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 this concern.
>>
>> >>>> Thanks,
>> >>>> Rekha
>>
>> >>>> --
>> >>>> FORUM RULES (934+ members already BANNED for violation)
>>
>> >>>> 1) Use concise, accurate thread titles. Poor thread titles, like
>> >>>> Please
>> >>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>> >>>> Advice
>> >>>> will not get quick attention or may not be answered.
>>
>> >>>> 2) Don't post a question in the thread of another member.
>>
>> >>>> 3) Don't post questions regarding breaking or bypassing any security
>> >>>> measure.
>>
>> >>>> 4) Acknowledge the responses you receive, good or bad.
>>
>> >>>> 5) Cross-promotion of, or links to, forums competitive to this forum
>> >>>> in
>> >>>> signatures are prohibited.
>>
>> >>>> NOTE : Don't ever post personal or confidential data in a workbook.
>> >>>> Forum owners and members are not responsible for any loss.
>>
>> >>>> ------------------------------------------------------------------------------------------------------>>>>
>> >>>> To post to this group, send email toexcel-mac...@googlegroups.com
>>
>> >>> --
>> >>> Sam Mathai Chacko
>>
>> >>> --
>> >>> FORUM RULES (934+ members already BANNED for violation)
>>
>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like
>> >>> Please
>> >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>> >>> Advice
>> >>> will not get quick attention or may not be answered.
>>
>> >>> 2) Don't post a question in the thread of another member.
>>
>> >>> 3) Don't post questions regarding breaking or bypassing any security
>> >>> measure.
>>
>> >>> 4) Acknowledge the responses you receive, good or bad.
>>
>> >>> 5) Cross-promotion of, or links to, forums competitive to this forum
>> >>> in
>> >>> signatures are prohibited.
>>
>> >>> NOTE : Don't ever post personal or confidential data in a workbook.
>> >>> Forum owners and members are not responsible for any loss.
>>
>> >>> ------------------------------------------------------------------------------------------------------>>>
>> >>> To post to this group, send email toexcel-mac...@googlegroups.com
>>
>> >> --
>> >> Regards
>> >> Rajan verma
>> >> +91 9158998701
>>
>> >> --
>> >> FORUM RULES (934+ members already BANNED for violation)
>>
>> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> >> will not get quick attention or may not be answered.
>>
>> >> 2) Don't post a question in the thread of another member.
>>
>> >> 3) Don't post questions regarding breaking or bypassing any security
>> >> measure.
>>
>> >> 4) Acknowledge the responses you receive, good or bad.
>>
>> >> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> >> signatures are prohibited.
>>
>> >> NOTE : Don't ever post personal or confidential data in a workbook.
>> >> Forum
>> >> owners and members are not responsible for any loss.
>>
>> >> ------------------------------------------------------------------------------------------------------>>
>> >> To post to this group, send email toexcel-mac...@googlegroups.com
>>
>> > --
>> > FORUM RULES (934+ members already BANNED for violation)
>>
>> > 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> > will not get quick attention or may not be answered.
>>
>> > 2) Don't post a question in the thread of another member.
>>
>> > 3) Don't post questions regarding breaking or bypassing any security
>> > measure.
>>
>> > 4) Acknowledge the responses you receive, good or bad.
>>
>> > 5) Cross-promotion of, or links to, forums competitive to this forum in
>> > signatures are prohibited.
>>
>> > NOTE : Don't ever post personal or confidential data in a workbook.
>> > Forum
>> > owners and members are not responsible for any loss.
>>
>> > ------------------------------------------------------------------------------------------------------>
>> > To post to this group, send email toexcel-mac...@googlegroups.com
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
> not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
> ------------------------------------------------------------------------------------------------------
> To post to this group, send email to excel-macros@googlegroups.com
>
--
Regards
Rajan verma
+91 9158998701
--
FORUM RULES (934+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
