ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Troubleshooting programming on a Mac from a Windows (https://www.excelbanter.com/excel-programming/379232-troubleshooting-programming-mac-windows.html)

drhalter

Troubleshooting programming on a Mac from a Windows
 
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

NickHK

Troubleshooting programming on a Mac from a Windows
 
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

"drhalter" wrote in message
...
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





All times are GMT +1. The time now is 02:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com