Full Pathname using an Office 2011

[RobP]

Hi all,

I have quite a simple question for you, having just migrated to a mac and Office 2011. Of course the first thing I want to try out is whether the macros from my PC still work ...

I have a Cell on a sheet, that contains the full pathname of the file I want to load. My macro uses this address to find the file. In PC language, it reads "c:\documents and settings\...." blah blah blah. What syntax do I use for the mac full pathname.

I assume something like "Macintosh HD\Users\Rob\", but cant seem to get it to find my file.

any ideas ?

 

[Jim Gordon]

The path separator on the Mac is a colon. Use CurDir in VBA to determine your current file path, or in a cell use =INFO("directory"). You'll need to append the workbooks name to the end of the file path to get the complete file path.

 

[RobP]

Thanks Jim,

I'll take a look - appreciate the info.

Rgds
ROb