Problem with wait/sleep

**johngillespie** · 05-14-2007, 08:42 AM

Hi all,

I've recorded an excel macro which basically just opens up an excel file does a "Refresh All" saves and shuts itself. Problem I'm having is that the "Refesh All" command doesn't have time to finish before the macro tries moving on to the next step.

I'd like to get my macro to sleep for X seconds so the "Refresh All" can finish.

I am using Excel 2007.

Here is my current macro :

Please Login or Register  to view this content.

Regards,

John Gillespie

**johngillespie** · 05-14-2007, 09:08 AM

I have tried using this method (http://msdn2.microsoft.com/en-us/lib...ffice.11).aspx) but it pauses the Refresh all command

**mccreaso** · 05-14-2007, 09:09 AM

Is this what your looking for?

Please Login or Register  to view this content.

The code will wait for 5 seconds.

HTH,
mccreaso

**johngillespie** · 05-14-2007, 09:12 AM

Originally Posted by mccreaso

Is this what your looking for?

Please Login or Register  to view this content.

The code will wait for 5 seconds.

HTH,
mccreaso

I have tried that and it doesn't work since the Refresh command gets paused too

What I need is something that lets the Refresh command to run whilst pausing the rest of the macro.

**mccreaso** · 05-14-2007, 09:26 AM

Split it into 2 macros and use the Application.OnTime function:

Macro1

Please Login or Register  to view this content.

Macro 2

Please Login or Register  to view this content.

Havent tested it, but hope it helps,

mccreaso

**johngillespie** · 05-14-2007, 09:54 AM

worked like a charm, thanks a lot !

**mccreaso** · 05-14-2007, 09:56 AM

Glad it helped

!
mccreaso

Problem with wait/sleep

LinkBack

Thread Tools

Rate This Thread

Display

Problem with wait/sleep

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions