Close an Excel Spreadsheet with VBA
Posted on 2013-12-23
I have an access database that manipulates data from a workbook that is downloaded from a website. I have a button and some code that uploads the data automatically. Here is the issue: the format in which the internet provides it seems to be in .xls and it saves it as such but when the user re-opens it or saves it it wants to be a web file. Because of this access cannot upload it so I have copied some VBA that opens the saved file, re-saves it as a CSV which then allows me to successfully uploads it. Once that process is done, I have the program delete the newly created CSV as well as the original file.
However, when the user goes to download the NEXT bit of data, the OLD, presumed deleted CSV file (with the same name) is opened and without the user having to go thru a bunch of steps I dont want them to - the old one saves as the new one.
Any thoughts on how to kill it after its deleted?