[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.excel.programming

Launch Macro at startup

R Doornbosch

12/12/2006 6:48:00 PM

This goes with my question below but. I want to launch a "loop" macro when
the excel sheet is opened to monitor the time and then run another macro
when it's 8:00 am. In VB I'd use the Form_Laod but what do I use in VBA?
Also is there a better way to monitor the time than in a WHILE <> Loop?


6 Answers

Zigball

12/12/2006 6:58:00 PM

0

Not sure if this is what you are looking for:

Public Sub LoopMacro()

LoopMacro.Show vbModal

End Sub


HotRod wrote:
> This goes with my question below but. I want to launch a "loop" macro when
> the excel sheet is opened to monitor the time and then run another macro
> when it's 8:00 am. In VB I'd use the Form_Laod but what do I use in VBA?
> Also is there a better way to monitor the time than in a WHILE <> Loop?

Zigball

12/12/2006 7:01:00 PM

0

Disregard the first message you want to put this in the workbook

Private Sub Workbook_Open()

LoopMacro.Show vbModal

End Sub

Create a module for the Loopmacro.


HotRod wrote:
> This goes with my question below but. I want to launch a "loop" macro when
> the excel sheet is opened to monitor the time and then run another macro
> when it's 8:00 am. In VB I'd use the Form_Laod but what do I use in VBA?
> Also is there a better way to monitor the time than in a WHILE <> Loop?

R Doornbosch

12/12/2006 7:39:00 PM

0

Private Sub Workbook_Open()

Doesn't seem to work. Even after closing and opening the workbook the cde is
not executed. Am I missing something?


"Zigball" <zigball@gmail.com> wrote in message
news:1165950071.866252.154460@l12g2000cwl.googlegroups.com...
> Disregard the first message you want to put this in the workbook
>
> Private Sub Workbook_Open()
>
> LoopMacro.Show vbModal
>
> End Sub
>
> Create a module for the Loopmacro.
>
>
> HotRod wrote:
>> This goes with my question below but. I want to launch a "loop" macro
>> when
>> the excel sheet is opened to monitor the time and then run another macro
>> when it's 8:00 am. In VB I'd use the Form_Laod but what do I use in VBA?
>> Also is there a better way to monitor the time than in a WHILE <> Loop?
>


Dave Peterson

12/12/2006 7:59:00 PM

0

Make sure you put that procedure under ThisWorkbook--not behind a worksheet, not
in a General module.

And make sure you allow macros to run when you open that file (check your
security settings).

HotRod wrote:
>
> Private Sub Workbook_Open()
>
> Doesn't seem to work. Even after closing and opening the workbook the cde is
> not executed. Am I missing something?
>
> "Zigball" <zigball@gmail.com> wrote in message
> news:1165950071.866252.154460@l12g2000cwl.googlegroups.com...
> > Disregard the first message you want to put this in the workbook
> >
> > Private Sub Workbook_Open()
> >
> > LoopMacro.Show vbModal
> >
> > End Sub
> >
> > Create a module for the Loopmacro.
> >
> >
> > HotRod wrote:
> >> This goes with my question below but. I want to launch a "loop" macro
> >> when
> >> the excel sheet is opened to monitor the time and then run another macro
> >> when it's 8:00 am. In VB I'd use the Form_Laod but what do I use in VBA?
> >> Also is there a better way to monitor the time than in a WHILE <> Loop?
> >

--

Dave Peterson

Zigball

12/12/2006 8:05:00 PM

0

Im usually on the question end of this forum so I would probably re
submit my question if i were you. If I am not mistaken you are trying
to get a macro to start at start up if this is correct please disregard
all my solutions because those are simply for starting up user forms at
start up. Good luck and I am sure you will get the correct answer
because this is probably one of the best places to get a right answer
for any questions or problems one might have, sorry!


HotRod wrote:
> Private Sub Workbook_Open()
>
> Doesn't seem to work. Even after closing and opening the workbook the cde is
> not executed. Am I missing something?
>
>
> "Zigball" <zigball@gmail.com> wrote in message
> news:1165950071.866252.154460@l12g2000cwl.googlegroups.com...
> > Disregard the first message you want to put this in the workbook
> >
> > Private Sub Workbook_Open()
> >
> > LoopMacro.Show vbModal
> >
> > End Sub
> >
> > Create a module for the Loopmacro.
> >
> >
> > HotRod wrote:
> >> This goes with my question below but. I want to launch a "loop" macro
> >> when
> >> the excel sheet is opened to monitor the time and then run another macro
> >> when it's 8:00 am. In VB I'd use the Form_Laod but what do I use in VBA?
> >> Also is there a better way to monitor the time than in a WHILE <> Loop?
> >

R Doornbosch

12/12/2006 8:31:00 PM

0

I managed to get it working once I moved the code into the Workbook into the
sheet. Stupid rookie mistake..


"Zigball" <zigball@gmail.com> wrote in message
news:1165953925.142375.112440@f1g2000cwa.googlegroups.com...
> Im usually on the question end of this forum so I would probably re
> submit my question if i were you. If I am not mistaken you are trying
> to get a macro to start at start up if this is correct please disregard
> all my solutions because those are simply for starting up user forms at
> start up. Good luck and I am sure you will get the correct answer
> because this is probably one of the best places to get a right answer
> for any questions or problems one might have, sorry!
>
>
> HotRod wrote:
>> Private Sub Workbook_Open()
>>
>> Doesn't seem to work. Even after closing and opening the workbook the cde
>> is
>> not executed. Am I missing something?
>>
>>
>> "Zigball" <zigball@gmail.com> wrote in message
>> news:1165950071.866252.154460@l12g2000cwl.googlegroups.com...
>> > Disregard the first message you want to put this in the workbook
>> >
>> > Private Sub Workbook_Open()
>> >
>> > LoopMacro.Show vbModal
>> >
>> > End Sub
>> >
>> > Create a module for the Loopmacro.
>> >
>> >
>> > HotRod wrote:
>> >> This goes with my question below but. I want to launch a "loop" macro
>> >> when
>> >> the excel sheet is opened to monitor the time and then run another
>> >> macro
>> >> when it's 8:00 am. In VB I'd use the Form_Laod but what do I use in
>> >> VBA?
>> >> Also is there a better way to monitor the time than in a WHILE <>
>> >> Loop?
>> >
>