Office 2000 Macros do not work in Office for Mac 2004

[Basilisk]

Version: 2004 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel A previous employee set up a Macro so that when a cell in an Excel sheet was filled in, the contents of another cell would be copied and pasted into a Word document. This meant that when work reached a particular stage, the name and address of the client would be copied and entered into a Word template ready to send to the appropriate place.

However, this only works on the PCs running Office 2000; the Macs running Office for Mac 2004 (which I am told still has VBA on board) are unable to run this Macro.

How can I have both PCs and Macs run the same Macro please?

TIA

 

[Bob Greenblatt]

Version: 2004 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel A
previous employee set up a Macro so that when a cell in an Excel sheet was
filled in, the contents of another cell would be copied and pasted into a Word
document. This meant that when work reached a particular stage, the name and
address of the client would be copied and entered into a Word template ready
to send to the appropriate place.

However, this only works on the PCs running Office 2000; the Macs running
Office for Mac 2004 (which I am told still has VBA on board) are unable to run
this Macro.

How can I have both PCs and Macs run the same Macro please?

TIA

The macro ought to work fine on the Mac. What has probably happened is that
the author of the macro did not take the Mac into account and has used
coding techniques that are not compatible. Your recourse is to contact the
original author of the macro and have it coded properly so that it will also
work on a Mac. Or, you could contract with any of several consultants who
watch this forum to get a quotation of converting the macro so that it will
work properly.