Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 26
Default Pause a Macro

I need help with the following:
I dowload data form a server and put this on the clipboard, the Macro1 paste
this data then cleans it up and arrange it the macro works well,

I need is to Pause the macro with a Question like "would you like to import
US now? if yes let me get the data and put it in the clipboard and when this
is done run the macro2 for the US download.

Did I made mi self clear?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 703
Default Pause a Macro

If MsgBox("Import Now?", vbYesNo) = vbYes Then
GetData
PutInClipboard
Macro2
End If


"MESTRELLA29" wrote:

I need help with the following:
I dowload data form a server and put this on the clipboard, the Macro1 paste
this data then cleans it up and arrange it the macro works well,

I need is to Pause the macro with a Question like "would you like to import
US now? if yes let me get the data and put it in the clipboard and when this
is done run the macro2 for the US download.

Did I made mi self clear?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
pause a macro tsmith Excel Discussion (Misc queries) 9 January 22nd 09 12:47 AM
pause macro Art Parra Excel Programming 1 August 29th 06 12:16 AM
Pause Macro cottage6 Excel Programming 2 April 14th 06 04:23 PM
Pause a Macro? Jimbo Excel Programming 2 October 14th 04 04:21 AM
Pause during a Macro Marie[_3_] Excel Programming 6 January 18th 04 12:18 PM


All times are GMT +1. The time now is 09:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"