Using macro to find file
 

I am switching an old Macro created in Mac Excel 97 to PC Excel 2003. The old command read as =OPEN("labor daily log",0) this opened a file in my folder named UPDATE. Now when I try to run this in PC excel it won't find the file. I have tried resetting the default file location in the excel options window to the folder location but it won't find the file.(maybe I am not entering the path correctly?) right now the UPDATE folder is on my desk top. what would be the correct path name to set as the default location? I have tried adding the xls etension to both the macro and the actual file but that didn't help.or do I need to change something in the macro command. If your wondering why I am not using VBA it's because I started Macros back in excel4 and haven't had time to learn VBA. All help welcome
--
LGP

Using macro to find file
 

Workbooks.Open("Path").Activate

If you are having trouble to find the right path. Find the file throug
windows and copy the path above

--
Message posted from http://www.ExcelForum.com