yesthattom (![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png)
yesthattom) wrote2005-05-22 05:34 pm
yesthattom) wrote2005-05-22 05:34 pm
MS-Excel macro help!
I’m writing a macro that, among other things, saves the MS-Excel spreadsheet:
ActiveWorkbook.SaveAs Filename:= “EventList.txt”, FileFormat:= xlText
However, every time it runs I get a dialog box asking for permission to replace the old file.
Anyone know how to disable that box?
ActiveWorkbook.SaveAs Filename:= “EventList.txt”, FileFormat:= xlText
However, every time it runs I get a dialog box asking for permission to replace the old file.
Anyone know how to disable that box?