I have a workbook with multiple sheets that is used to pre-process instrumentation data. Once the data is processed I then run a macro that calls up another workbook and transfers data into it for further post-processing.

Code (macro) snippets that reference the two workbooks:

First file reference
Windows ("L1 102720119 raw.xls").Activate

Second file reference
Windows ("L1 102720119 OS.xls").Activate

My question is - if a path to an external file is not specified in the macro, how does it know where to find the file?