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.