View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Jake Marx[_3_] Jake Marx[_3_] is offline
external usenet poster
 
Posts: 860
Default Translation of VBA from PC to MAC

Hi KR,

KR wrote:
It seems to me that there is something related to the path seperator
- I believe Mac handles it differently, e.g. I think you can't use
"\" in your path, but I don't have a Mac so I can't be positive.
There should be some variable (which I thought was pathSeparator, but
I can't find that in the Excel help file) that you can use so it will
select the correct path seperator regardless of platform.


You're correct - Application.PathSeparator should be used instead of
hardcoding the "\" character. I'm not sure if that's the only problem with
the OP's code running on a Mac, but it should help.

--
Regards,

Jake Marx
www.longhead.com


[please keep replies in the newsgroup - email address unmonitored]

"alina b." wrote in message
ups.com...
Hello,

I have the following code in my PC version that works without error,
could someone tell me how to modify it so that I can have it open in
a MAC version?

pathname = ActiveWorkbook.Path
Databasaefile = pathname & "\Database.XLS"
Workbooks.Open Filename:=Databasefile

Basically, for the third line it gives me a Run-time error. I
believe it doesn't recognize the pathname.

Thanks,
alina b.