Using ADO to read closed file does not read formulas

First of all, thanks for all the great help and quick responses, this place has been invaluable!

I'm using ActiveX Data Objects to gain access to another closed .xlsm excel file. Mainly to read large ranges of information at one time. The problem I am running into is the information that is returned is basically the .value of of the cells, not the .formula of the cells. I know very little of what is really going on with the connection strings and the ADO object, but I have been able to modify other people's code, and read up quite a bit on it to produce what I have below. There may not be a solution to this, but is there some way to modify the properties string to return the .formula information, or anything else that can be done? Below is the code I have put together. It takes a file path, and a worksheet name to return every non empty cell value as a two dimensional array.

Please Login or Register  to view this content.

I'm afraid not. The provider has no concept of formulas, only values.

Open it, dump the formulas into an array and then close the workbook. Why do you need the formulas rather than the values as a matter of interest?

Well, that is one very good reason for not hardcoding data into formulas, unfortunately.

If you want values:

Please Login or Register  to view this content.

or formulas:

Please Login or Register  to view this content.