Translation of VBA from PC to MAC

  • Thread starter Thread starter alina b.
  • Start date Start date
A

alina b.

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.
 
alina b. -

If you don't get any assistance here, I suggest you post in the following
newsgroup:

microsoft.public.mac.office.excel

And, you could use the advanced search feature of Google Groups to see if
there are past newsgroup messages on this topic.

- Mike
www.mikemiddleton.com
 
Thank you Mike

Mike said:
alina b. -

If you don't get any assistance here, I suggest you post in the following
newsgroup:

microsoft.public.mac.office.excel

And, you could use the advanced search feature of Google Groups to see if
there are past newsgroup messages on this topic.

- Mike
www.mikemiddleton.com
Click to expand...
 
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.
 
Hi KR,
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.
Click to expand...

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]
 
Back
Top