I used the Activate wizard to create a package for Excel (Activate.Excel). There is a class in there that seems to be what we need to open a file:
Activate.Excel.Workbooks.
There is a method that has an Open() command. I tried using it but getting an invalid pointer error.
The parameters are as follows: