D dstiefe Sep 2, 2009 #1 I want to open a file that is located on another harddrive and hence folder how would I do that?
O OssieMac Sep 2, 2009 #2 Will the file path always be the same folder or do you mean that you have to search for a particular file in an unknown folder on a drive? If always in the same path then just record the macro to open the file. The code should be something like this. Workbooks.Open Filename:="K:\MyPath\My File To Open.xls"
Will the file path always be the same folder or do you mean that you have to search for a particular file in an unknown folder on a drive? If always in the same path then just record the macro to open the file. The code should be something like this. Workbooks.Open Filename:="K:\MyPath\My File To Open.xls"
