Blast from past: Excel4 Macro failing on G4 machine

[Doug Starkey]

Ok, here's the scoop:

I'm running Excel 98 on a G4 (Quicksilver) with OS 9.2. I also run this
exact same macro on a BUNCH of other Macs (iMacs, PowerBooks, G3
[Sawtooth], G4 [Graphite). It runs on all these machines without a hitch.

But on the G4/Quicksilver, it hits a snag. It will go along fine and
then come up with an error message:

No RETURN() or HALT() function found on macro sheet.

Yet, if I STEP() through the macro, it works fine. The error message
never appears.

I'm pretty sure the installations between machines are identical. The
only difference is that this is a G4/Quicksilver. I'm mystified. I'm not
sure what is causing the problem.

I sure hope one of you has a clue.

TIA,

--
Doug Starkey
Network Administrator
Pecan Deluxe Candy Company
(e-mail address removed)
(remove "NOSPAMPLEASE" to reply)

 

[Bob Greenblatt]

Ok, here's the scoop:

I'm running Excel 98 on a G4 (Quicksilver) with OS 9.2. I also run this
exact same macro on a BUNCH of other Macs (iMacs, PowerBooks, G3
[Sawtooth], G4 [Graphite). It runs on all these machines without a hitch.

But on the G4/Quicksilver, it hits a snag. It will go along fine and
then come up with an error message:

No RETURN() or HALT() function found on macro sheet.

Yet, if I STEP() through the macro, it works fine. The error message
never appears.

I'm pretty sure the installations between machines are identical. The
only difference is that this is a G4/Quicksilver. I'm mystified. I'm not
sure what is causing the problem.

I sure hope one of you has a clue.

TIA,

Is there an auto_open or auto_close macro? How about any on_Time macros? Can
you tell where it begins to have this problem? Perhaps insert Step()
instructions at various places to narrow down where it fails.

(I've seen this before, but can't recall the exact circumstances.)

 

[Doug Starkey]

Ok, here's the scoop:

I'm running Excel 98 on a G4 (Quicksilver) with OS 9.2. I also run this
exact same macro on a BUNCH of other Macs (iMacs, PowerBooks, G3
[Sawtooth], G4 [Graphite). It runs on all these machines without a hitch.

But on the G4/Quicksilver, it hits a snag. It will go along fine and
then come up with an error message:

No RETURN() or HALT() function found on macro sheet.

Yet, if I STEP() through the macro, it works fine. The error message
never appears.

I'm pretty sure the installations between machines are identical. The
only difference is that this is a G4/Quicksilver. I'm mystified. I'm not
sure what is causing the problem.

I sure hope one of you has a clue.

TIA,

Is there an auto_open or auto_close macro? How about any on_Time macros? Can
you tell where it begins to have this problem? Perhaps insert Step()
instructions at various places to narrow down where it fails.

(I've seen this before, but can't recall the exact circumstances.)

As best I can tell, it seems to occur with the ACTIVATE() command. As
part of the macro, I have about 3 different spreadsheets open (aside
from the macro sheet itself) and I use the ACTIVATE() command to switch
between the spreadsheets.

--
Doug Starkey
Network Administrator
Pecan Deluxe Candy Company
(e-mail address removed)
(remove "NOSPAMPLEASE" to reply)

 

[Bob Greenblatt]

Ok, here's the scoop:

I'm running Excel 98 on a G4 (Quicksilver) with OS 9.2. I also run this
exact same macro on a BUNCH of other Macs (iMacs, PowerBooks, G3
[Sawtooth], G4 [Graphite). It runs on all these machines without a hitch.

But on the G4/Quicksilver, it hits a snag. It will go along fine and
then come up with an error message:

No RETURN() or HALT() function found on macro sheet.

Yet, if I STEP() through the macro, it works fine. The error message
never appears.

I'm pretty sure the installations between machines are identical. The
only difference is that this is a G4/Quicksilver. I'm mystified. I'm not
sure what is causing the problem.

I sure hope one of you has a clue.

TIA,

Is there an auto_open or auto_close macro? How about any on_Time macros? Can
you tell where it begins to have this problem? Perhaps insert Step()
instructions at various places to narrow down where it fails.

(I've seen this before, but can't recall the exact circumstances.)

As best I can tell, it seems to occur with the ACTIVATE() command. As
part of the macro, I have about 3 different spreadsheets open (aside
from the macro sheet itself) and I use the ACTIVATE() command to switch
between the spreadsheets.

If you are familiar with the code and not afraid to make some changes, it is
almost NEVER necessary to activate a worksheet. Sure, recorded code does
this a lot, but hand written or modified code does not need to activate, and
will run much faster. I'm not sure I can duplicate your problem on my
configuration, but I'll be happy to look at the code and see if I can find
anything fishy.