| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I find a deleted excel file? Or an autosave file? | Excel Discussion (Misc queries) | |||
| clicking .XLS file opens Excel 2003 but doesn't find the file | Excel Discussion (Misc queries) | |||
| Can't find macro in an Excel file to delete it | Excel Discussion (Misc queries) | |||
| How do I find a file/spreadsheet that Excel says is Already open but I can't find it? | Excel Discussion (Misc queries) | |||
| Want file title listing as in Excel 5.0 File>Find | Excel Discussion (Misc queries) | |||
Linear Mode
