ExecuteExcel4Macro in GetValue not working

D

dusty

G'Day All,

I've used John Walkenbach's GetValue to retrieve values from closed
many time with no problems.

Two days ago the method failed when using a workbook created via a DLL
in another system.

It seems the format is wrong. e.g if the system created workbook is
opened and saved as an Excel workbook in any format from Excel 5.0/95
and above, GetValue works on the newly saved workbook.

If the system cretade workbook is opened in Excel and saved in Excel
4.0 format, GetValue fails to work with the newly saved workbook.

Can anyone confirm that ExecuteExcel4Macro in GetValue is dependent on
the format of the supposedly Excel file?

Can anyone then explain why it ExecuteExcel4Macro doesn't like Excel
4.0 files?

Thanks for your time,

Clive
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ExecuteExcel4Macro 4
Access data in a closed workbook with ExecuteExcel4Macro 5
Function not working correctly 1
Can I still register a function in a DLL using ExecuteExcel4Macro REGISTER? 6
Excel 2007 Access the Content Created File property in vba 3
Open Workbook to Specific Cell 5
User defined menu stops working when workbook saved with a newname??? 4
Excel 4.0 Macro - Save XLS in Excel 4.0 format? 2

Top