count rows in new open excel

[smarty.1211]

Hello,

I am opening new excel file using my current excel file (in which I have wrote macro)
I can read the current excel file total number of rows using following line

Please Login or Register  to view this content.

following error appears "unable to get the CountA property of the WorksheetFunction class"

Thanks in advance for your suggestions

Regards,
Nitin Salunkhe

[Lifesigns]

Hi there,

Without an example I'm not sure why you would want to know the amount of rows, I assume there must be data in column A.

Anyway instead of initiating a new instance of Excel you can maybe do it like this:

Please Login or Register  to view this content.

lifesigns

[snb]

Please avoid Select & Activate in VBA

Please Login or Register  to view this content.

[arlu1201]

Usually when you are active in one instance of excel, it doesnt allow you to perform an action in another instance. Hence, instead of starting another instance, just add a workbook thru -

Please Login or Register  to view this content.

Then proceed to count.

[Leith Ross]

Hello smarty.1211,

Welcome to the Forum!
Your syntax is correct until the last statement. Here is the corrected and working code.

Please Login or Register  to view this content.