Number of rows with data from closed workbook

[hoongz]

Hi, I learn that i could use the following code to get the number of the last row with values in it.

Please Login or Register  to view this content.

I would like to check if there is anyway of finding the number of the last row with value in a closed workbook.

Thanks in advance for any advise and inputs.

[hoongz]

Any advise please

[FDibbins]

You can do what you want with a regular formula too....
=COUNTA('\\fullpath\[filename.xlsm]sheetname'!$A:$A)

either type inthe fullpath, filename etc, or open the file and point to the range. you can then close the other WB

[hoongz]

Apologies that I didn't make it clear earlier. I'm working with VBA as I need the number of rows that has details to do a while loop to retrieve data from the closed workbook for processing. Is there any way of doing so in VBA instead of formula in the sheet itself?

[hoongz]

Any help on this?

[Izandol]

How do you retrieve data from the closed workbook?