Simple way to open an Excel workbook using VBA and macros.
Workbooks.Open ("File Path")
Replace file path with the path to the file on your computer along with the full file name.
Here is what it looks like in the VBA Editor window:
Note: you do not always have to use the file extension of the file but it is a good practice to do so. In my example, using simply "D:\test" would also work.
There are MANY more options for opening a workbook but this post covers the basic usage of it, which will work for 98% of needed uses for this.
Here is a link to a full explanation on using this method if you need a more complex implementation of it: Workbook Open Method.
Make sure to download the accompanying workbooks to test this out in Excel.