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,:)


--
portucale
------------------------------------------------------------------------
portucale's Profile: http://www.excelforum.com/member.php...o&userid=35979
View this thread: http://www.excelforum.com/showthread...hreadid=557646

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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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