I've got a macro in Excel that
1. Opens a file
2. does a save As in another file format
3. Closes the file (theoretically without saving it again).
The problem is that if the save as file finds an existing file of the same name, the it comes back with a "Do you want to overwrite?" the file? Also, when it doesn't I still get a ""Do you want to save this in another format?"
Basically I want to surpress ALL the messages.
Here is the code which is generated by the macro recorder. Each sheet is a single page, there is no need for workbooks, or anything.
Workbooks.Open FileName:="\\kryton\middle\sds spreadsheets\advancement.xls"
ActiveWorkbook.SaveAs FileName:="c:\data\uvmphones\data\advancement.dbf", _
FileFormat:=xlDBF4, CreateBackup:=False
ActiveWorkbook.Close
Under the SaveAs I'm thinking (praying?) that there is a parameter that says ShutUp:=True or something like that....
Thnx.
--- Larry
-- Larry Keyes
Remember only You can prevent Gray Goo. Never release nanobot assembers without replication limiting code.