Macro Wait

[captnk]

I have an export from access (Transferspreadsheet method),which then calculates in XL and is then reimported.
However I need to have the Macro "wait" at that point (1 0r 2 seconds) for xl to finish its calc before reimporting.

Can this be done from the Access "macro"
design form pls.

Captnk

 

[Newman]

The only way I know, is to make a loop in VBA.

For x = 1 to 1000000 'Change this value to fit to your machine's speed
next x
...'And put your code right after the «next x» statement

Just one problem with this code...
Faster is the machine, shorter will be the wait.
So, if you put this on machines with different speeds, it will look as a second for someone and as 5 seconds for someone else.

Newman

 

[captnk]

Thanks Newman.

Thats a really interesting Idea.

I will give that a shot and see how it goes
Captnk

 

[captnk]

A belated response but many thanks Newman.
It took a while to come to grips with that,especially as I needed to increase the delay to 300,000000,to finally get it to work.
I actually run an AMD 1300 so its not exactly slow,its just the xl spreadsheet is very slow.
Anyway a very simple solution to what was a mind boggling problem
Thanks

Captnk

 

[mixedguy]

Set Timed Pop Up Message

Hi,

I don't really know where to start with this. I'm trying to make a pop up message appear on the Database at 10:00 am asking all users to exist the database so I can run my updates. How would I create the Macro/VBCode to do so?

Thanks in Advance!
Todd