LISTSERV - MACSCRPT Archives - LISTSERV.DARTMOUTH.EDU

MACSCRPT Archives

April 2009

MACSCRPT@LISTSERV.DARTMOUTH.EDU

	LISTSERV Archives
	MACSCRPT Home
	MACSCRPT April 2009

	Log In
	Register

	Subscribe or Unsubscribe

	Search Archives

Options:	Use Monospaced Font Show Text Part by Default Show All Mail Headers
Message:	[<< First] [< Prev] [Next >] [Last >>]
Topic:	[<< First] [< Prev] [Next >] [Last >>]
Author:	[<< First] [< Prev] [Next >] [Last >>]

Subject:	Excel X/2004/2008, pause/resume macro
From:	Walter Ian Kaye <[log in to unmask]>
Reply To:	Macintosh Scripting Systems <[log in to unmask]>
Date:	Thu, 9 Apr 2009 00:22:44 -0700
Content-Type:	text/plain
Parts/Attachments:	text/plain (16 lines)

So recently I'm doing some Excel again, and calling an applet via XLM 
macro EXEC() which is non-blocking. I discover I can make it block by 
following it with PAUSE() and having the applet send Excel an 
Evaluate command to resume the macro.

Trouble is, RESUME() doesn't work in Excel X; it's supposed to do the 
same thing as hitting the corresponding toolbar button, but it 
doesn't (neither from AS nor from the macro sheet itself; Excel acts 
like nothing's paused). I'd say it's a bug in v.X.

Can anyone with version 2004 and/or 2008 say whether the v.X bug is 
fixed in either of those versions of Excel?

thanks,
-boo

ATOM RSS1 RSS2

LISTSERV.DARTMOUTH.EDU