Hi,
Here data scrapping is being performed. From the data scrapping data i need to fetch the filename. For that I am using the excel sheet to write the data, problem here is the overwriting not clearing the sheet.
Only for 1st iteration its clearing for rest its over writing. Not able to use clear data table getting error as object not set to instance of object. So i used write cell
Its working only for 1st iteration and same data over writing.
I used invoke vba also same issue. Can any one help me on this.
Regards,
Lakshmi