Hi all,
I have developed a project for extracting data from a HTML file and export that data to a excel sheet. I am storing that extracted data to the db. And then I am exporting that data to excel sheet. But, the data is getting overwritten in that excel sheet each time. I want to get rowcount from excel sheet & then append new data to that sheet. I tried to connect to excel sheet as a database. But, after that I have no idea how to extract rowcount from that sheet.
If somebody helps me, i will be grateful for him/her.
surekha
Would you like to use VBA for this?