Troubleshooting programming on a Mac from a Windows

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

drhalter - 12 Dec 2006 04:54 GMT

I've written an extensive set of visual basic forms and macros (at least for
me) on a Windows machine running Excel 2003. I am now in the situation of
needing to use the file and its programs on a Mac running Excel 2004.

The problem is, I really can't troubleshoot the file because the Mac it will
be running on is unavailable (in another country). I think I've fixed a few
potential problems (for example, I've removed all embedded objects), but I
don't know what else I might need to change.

Can anyone think of a way to troubleshoot the file for Mac without the Mac?
Or, anyone out there with a Mac and Excel 2004 willing to help me
troubleshoot it?

Thanks,
Dave

Reply to this Message

NickHK - 12 Dec 2006 05:30 GMT

Dave,
Can't help you directly , but one thing to is that Macs use a ":" (?) for
the path separator, so don't hard code a "\".
(Application.PathSeparator will return the correct value, although I now see
Help says it returns "\", so not sure).
Interacting with the file system seems one area of where differences exist
(GetOpenFileName, etc).

There also the Mac?Excel NG that may prove useful :
microsoft.public.mac.office.excel

NickHK

> I've written an extensive set of visual basic forms and macros (at least for
> me) on a Windows machine running Excel 2003. I am now in the situation of
[quoted text clipped - 11 lines]
> Thanks,
> Dave

Reply to this Message