Loop with Time

Hi,
New to this programming hence I am looking for some help.
I need to write a macro/vba in Excel which will open diferent workbooks according a specific time, i.e. Book 1 (open) then open Book 2 after 2 minutes, Book three after 4 minutes of the first (2 minutes of teh second).

Your help will be much appreciated.

Thanks,

Maby u can use this as inspiration

http://pmexcelent.dk/FileMaster.xls

Hi Excelent,

I have been looking at your code.

Since you have worked with the Application On Time command I wonder if you
have run into the following difficulty:

If you try to close the workbook that has the timer running from another
workbook, programatically, the Before_Close event will run the Stoptimer but
it won't kill it. It will refire again.

This has caused me ample problems.

Try it
"excelent" wrote:

> Maby u can use this as inspiration
>
> http://pmexcelent.dk/FileMaster.xls
>

You should kill the timer. Chip Pearson explains it all on
http://www.cpearson.com/excel/ontime.htm

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Antonio" <[email protected]> wrote in message
news:[email protected]...
> Hi Excelent,
>
> I have been looking at your code.
>
> Since you have worked with the Application On Time command I wonder if you
> have run into the following difficulty:
>
> If you try to close the workbook that has the timer running from another
> workbook, programatically, the Before_Close event will run the Stoptimer
but
> it won't kill it. It will refire again.
>
> This has caused me ample problems.
>
> Try it
> "excelent" wrote:
>
> > Maby u can use this as inspiration
> >
> > http://pmexcelent.dk/FileMaster.xls
> >

Hi Bob,

I have done intensive work on this issue.

I know how it is suposed to be done but it just does not work. It is a bug,
an annoying one.

Again, try closing a workbook with a live On Time procedure from a different
workbook, if you rely on the Before_Close event it does not work. It never
works.

You have to call the kill timer sub independently and it does not always
work.

"Bob Phillips" wrote:

> You should kill the timer. Chip Pearson explains it all on
> http://www.cpearson.com/excel/ontime.htm
>
> --
> HTH
>
> Bob Phillips
>
> (replace somewhere in email address with gmail if mailing direct)
>
> "Antonio" <[email protected]> wrote in message
> news:[email protected]...
> > Hi Excelent,
> >
> > I have been looking at your code.
> >
> > Since you have worked with the Application On Time command I wonder if you
> > have run into the following difficulty:
> >
> > If you try to close the workbook that has the timer running from another
> > workbook, programatically, the Before_Close event will run the Stoptimer
> but
> > it won't kill it. It will refire again.
> >
> > This has caused me ample problems.
> >
> > Try it
> > "excelent" wrote:
> >
> > > Maby u can use this as inspiration
> > >
> > > http://pmexcelent.dk/FileMaster.xls
> > >
>
>
>

As long as you call it with exactly the same scheduled time as when you set
it, it works fine.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Antonio" <[email protected]> wrote in message
news:[email protected]...
> Hi Bob,
>
> I have done intensive work on this issue.
>
> I know how it is suposed to be done but it just does not work. It is a
bug,
> an annoying one.
>
> Again, try closing a workbook with a live On Time procedure from a
different
> workbook, if you rely on the Before_Close event it does not work. It never
> works.
>
> You have to call the kill timer sub independently and it does not always
> work.
>
> "Bob Phillips" wrote:
>
> > You should kill the timer. Chip Pearson explains it all on
> > http://www.cpearson.com/excel/ontime.htm
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (replace somewhere in email address with gmail if mailing direct)
> >
> > "Antonio" <[email protected]> wrote in message
> > news:[email protected]...
> > > Hi Excelent,
> > >
> > > I have been looking at your code.
> > >
> > > Since you have worked with the Application On Time command I wonder if
you
> > > have run into the following difficulty:
> > >
> > > If you try to close the workbook that has the timer running from
another
> > > workbook, programatically, the Before_Close event will run the
Stoptimer
> > but
> > > it won't kill it. It will refire again.
> > >
> > > This has caused me ample problems.
> > >
> > > Try it
> > > "excelent" wrote:
> > >
> > > > Maby u can use this as inspiration
> > > >
> > > > http://pmexcelent.dk/FileMaster.xls
> > > >
> >
> >
> >

nope cant say i have, i made this sheet for another, he newer told me of any
problems. Anyway i use this code to stop timer

Private Sub Workbook_BeforeClose(Cancel As Boolean)
StopTimer
End Sub



"Antonio" skrev:

> Hi Excelent,
>
> I have been looking at your code.
>
> Since you have worked with the Application On Time command I wonder if you
> have run into the following difficulty:
>
> If you try to close the workbook that has the timer running from another
> workbook, programatically, the Before_Close event will run the Stoptimer but
> it won't kill it. It will refire again.
>
> This has caused me ample problems.
>
> Try it
> "excelent" wrote:
>
> > Maby u can use this as inspiration
> >
> > http://pmexcelent.dk/FileMaster.xls
> >