ActiveWorkBook is returning an object with <no variables>

I am going crazy trying to understand what is wrong with my code. The entire routine is down below.

I'm using Workbook.OpenText to get a TXT file. I then use

Please Login or Register  to view this content.

which is the recommended practice from what I've seen on the forums. The problem is, my Watch Window shows a + symbol, but when I expand it, it says <no variables> (I have a break point so that I should be able to see the data). I get no errors on the following lines when I grab the number of non-blank rows (my function), and I can print the wb.Name as well. But when I try to set the values in the Range to an array, they're all blanks.

Perhaps related, I get a "Range of object '_Worksheet' failed" error if I try to use DataWS.Range() instead of DataWS.Cells() in the For Loop down below.

Does anyone know why I can't see the object data in the Watch Window, and why my array values are all blank strings? Thanks in advance!!!

Colin

P.S. I'm using Option Explicit and am using the standard Excel error handler during debugging.

Please Login or Register  to view this content.

Thanks for the reply.

Yes, mLastRow is a User Defined Function that is successfully returning a non-zero integer. The code is:

Please Login or Register  to view this content.

And the constants are:

Please Login or Register  to view this content.

At the very least, can someone explain why the Watch Window would say that the workbook wb has <no variables>? There are no errors reported and the Debug line gives me the name of wb.

Please Login or Register  to view this content.

I got my code working almost as it is, and am commenting here for posterity. I still don't know why I can't see the object in the Watch window. Seems like a bug to me and is rather frustrating. But, I am able to access/store properties and debug.print properties whenever I want.

The reason the array values were all empty strings was because I was successfully opening my text file, but not with the correct delimiter, so all the Row1 data was in Column1 (instead of Col1, Col2, Col3...) and I was trying to read columns 5 and 6. Once I fixed the delimiter, it read in all the data.

I have the exact same problem so i am bumping this old thread for anyone else that stumbles upon it. I haven't truly solved for it but i formulated a workaround. I open the text file, save it as an xlsx, CLOSE it, then immediately re-open and the object then shows all properties and such in the Watches windows. But during this experiment, I discovered that the object was always created even though it wasn't showing up in the Watches window. So i removed the close and reopen code and will ignore this silly bug going forward.