Excel macro help please

[Will_Richo]

Hi. I am wanting to use a Spreadsheet solution on my Mac that i presently have on my PC.

I have a master sheet with macros on it, every day i recieve an e-mail with an up to date data file that i save on my h/d. I then run the master sheet and it looks to the c: drive for the update. The formula is this.

Workbooks.Open Filename:="C:\NS\Daily\SCWORK1.XLS"
Workbooks.Open Filename:="C:\NS\Daily\smarter version 1.1.xls", UpdateLinks:=3

The question is. What should i change this formula to for my Mac. Do i just create a file in docs then change the macro formula to point to it, I did try that but i do not think i used the right script.

I use office pro on XP. And Office x on the Mac.

Any suggestions would be appreciated.

Thanks

 

[bobw]

Should be a similiar formula, usinth the files path on the Mac.

Open Terminal and drag the update to the Terminal window and it will show you the path.

 

[Will_Richo]

Thanks Bob. I have uncovered some problems in the path, ie file is read only, and i have no rights to change it? i will be sending the path i want putting on it to the author and get him to do it for me. Hope that sorts it. (He has no MAC exp, so he did not know the path i needed until your reply.

Will let you know how i get on.

 

[bobw]

Do a Get Info (Command-I) on the file and see if you can change Permissions.