Macros from PC to Mac

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bkeel@collinsandlacy.com - 11 Nov 2005 21:45 GMT

I need to get some macros from PC to Mac. When I open the word docs on
the Mac with macros created on the PC they will not work. Well, some
will, but some won't. One problem that we have is that the toolbar for
the macros resides on one of our servers. If I record a macro on the
Mac or Pc to insert picture from file there is a path issue between the
2 platforms. The Mac will read the toolbar from the server and load at
startup. Is there anything that I should look for to make the macros
work cross platform. We are a PC office but I do supports Macs ( I have
to bring my Powerbook everyday) and we have more employees starting to
use Macs. I really need a solution. Any help would be appreciated.

Barry

Reply to this Message

John McGhie [MVP - Word and Word Macintosh] - 18 Nov 2005 10:13 GMT

Hi Barry:

There are many things you need to consider. Chief amongst them is that in
Mac Word, VBA has not advanced beyond VBA 5. Anything written for Word 97
is likely to be OK, anything written for later versions may have issues.

Mac pathnames are different (!). Use the functions provided by VBA to
derive your pathnames. Read the help topic " Strategies for Developing
Cross-Platform Solutions" that appears in the VBA Help in Mac Word 2004.
You must have focus in the VBA Editor when you go into the Help to read this
topic. It contains most of what you will need.

Pay particular attention to the hash-defines "#IF Mac Then..." that appear
in the example. This will get you out of most of your trouble.

Any specific questions, get back to us...

Cheers

On 12/11/05 8:45 AM, in article
1131745525.483609.283150@g47g2000cwa.googlegroups.com,

> I need to get some macros from PC to Mac. When I open the word docs on
> the Mac with macros created on the PC they will not work. Well, some
[quoted text clipped - 8 lines]
>
> Barry

Signature

Please reply to the newsgroup to maintain the thread. Please do not email
me unless I ask you to.

John McGhie <john@mcghie.name>
Microsoft MVP, Word and Word for Macintosh. Consultant Technical Writer
Sydney, Australia +61 4 1209 1410

Reply to this Message

Mac Forum / Applications / Word / November 2005

Macros from PC to Mac