Will_Richo
Green & Growing
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
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