[lnkForumImage]
TotalShareware - Download Free Software

Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.excel.programming

Troubleshooting programming on a Mac from a Windows

drhalter

12/12/2006 4:54:00 AM

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
1 Answer

NickHK

12/12/2006 5:31:00 AM

0

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" <drhalter@discussions.microsoft.com> wrote in message
news:42EAC6A4-E48F-49E7-8ADC-3C464C6D3516@microsoft.com...
> 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