Problem with ExecuteExcel4Macro

[sethmac86]

Hello I am using the ExecuteExcel4Macro to find the value of a cell in another file without opening the file. All is working however when first opening the spreadsheet and running the macro which calls ExecuteExcel4Macro it returns null values, however 2nd time around (by activating it myself within VBA) it works just fine?

I am passing the location of a cell value as a text string to ExecuteExcel4Macro and have it working properly, just not after inital startup/load of the spreadsheet... any ideas?

 

[sethmac86]

When I try running the code the 1st time, i get that the return value from ExecuteExcel4Macro is "Error 2023"... then when I add ExecuteExcel4Macro to the watches it will then clear the error and display the correct value....???? what in the world is going on???