I have a Excel instance from VB, using CreateObject. After populating data into Excel sheet from VB, I have closed the Excel sheet. When I try to invoke Excel instance for the second time, I couldn't populate the data. Everytime I need to close both Excel application and VB application. I don't want save the content of the Excel. Any idea.
