Saving Excel automatically.
Posted on 2004-09-29
1) How can I save excel directly in the following peice of code?
Open "test.xls" For Output As #ff
' make changes
2) On another form I save changes using wb.save and unload the form.
For example I have deleted a particular row and then i save changes.
Then when i load the form again and search for the deleted row, it still appears.
It is not refereshed.
How can I refresh my excelsheet, such that, after I delete and rerun a query, I donot see it.
Thanks a lot.