Anyone ever use %Activate with Excel?
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:
I put in the Filename parameter and created a %Activate.Variant var with NULL values and passed that as the remaining parameters. I also just tried just the Filename parameter since according to Microsoft the rest of the parameters is optional / not required.
Here is a link from Microsoft for this method:
https://docs.microsoft.com/en-us/office/vba/api/excel.workbooks.open
Has anyone ever used this before or any advice on how to use a %Activate type ( this is my first time).
Thank you in advance for y our replies.