Overwriting old data

[phil009]

I am running a macro which uses the "OutputTo" function in order to send my query results to an Excel workbook. (I not using "Transferspreadsheet" because I want Excel to start up immediately after I export the data.) I am currently getting a message that says the file I am exporting, "specificCompany", already exists would I like to replace it? Is there anyway to make it so that this message does not appear. I tried turning the warnings off but that didn't work.

If anybody has any ideas it would be great,
Phil

 

[PHV]

You may consider the Kill function

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[phil009]

Thanks for the quick reply PHV, but you explain the "Kill" function a little bit more. I guess I'm not quite sure what you're talking about.

Thanks,
Phil

 

[phil009]

That last post should have said "could you explain"

Sorry about that

 

[PHV]

First sorry for my typo, should be read:
Take a look at the Kill instruction.
While in VBE (Alt-F11) open the immediate window (Ctrl-G), type kill and press F1.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[phil009]

Right now I am trying to use the kill function and it doesn't seem to be working. The code I am using is:

Kill "G:\Finance\2004\Analysis\Compete\CS-54\CS54 Files - Escanaba Excluded\Competitive\all companies.xls"

If anybody sees what is wrong please let me know.

Thanks,
Phil

 

[phil009]

Nevermind it works now for some strange reason. Thanks anyways though.

Phil