|
-
May 31st, 2010, 09:18 AM
#2
Re: ShellandWait problem
Doas
I'm not familiar with scheduled tasks in Excel, but let
me give it a shot...
Questions:
- Does the user "normally" manually launch the WB?
- What language is the ShellandWait routine -- VBA, VB6, or something else?
- What would you use for coding your solution -- VBA, VB6, or something else?
Possible solution:
When the user "manually" opens the WB, present a msgbox
with two buttons - Yes, No.
Something like...
This WorkBook will enter ShellandWait mode in 10 seconds.
Do you want to interrupt?
Yes - prevent ShellandWait mode
No - allow ShellandWait mode to proceed normally
Remaining issues:
- Is that different from what you proposed? -- seems to be
- This seems to mean that user will encounter this msgbox every time -- is that good or bad?
Spoo
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|