In my workplace I've been put in charge of deliviring a couple of reports. They are all done in MSSQL, and so far no problem. The problem is when I'm reformatting it in Excel.
I start with an empty spreadsheet (with only the macro behind it) that runs the reports, reformat it and save it to another completly empty spreadsheet. This way I wont get any problem with file already exists or anything like that. My problem is though, that the file with the macro is supposed to stay empty. Everytime I'm running the reports it has to be closed, and to close it I have to save it so I wont get the annoying "The file has been changed, do you want to save it". When I save it the last query is saved with it, and it builds up, so if I'm on vacation the file will be huuuuge when I come back since no one has emptied the lingering query.
My question is now:
How do I delete a query before I save the file
How do I close the file without saving it?
Any option would suit me as the macro file should remain constant and not change at all.
Any help here would be greatly appreciated.