Using macro to find file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Workbooks.Open("Path").Activate

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Refresh Macro to run each day? 2
Macro to generate powerpoint slides 43
Macro that will insert a simple text string in top cell of text file 1
Error After Copying Excel 2003 Macros and Toolbars from Windows Vistato Windows 7 1
Determine name of macro contained in each excel file in a folder 9
Macro for all Excel Workbooks to print to PDF 2
How to force macros refer to ActiveWorkbook 2
How do I save a single worksheet to a different file using VBA 03 2

Back
Top