| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Eliminating save message
Hi-
I wrote a Macro to automatically save a sheet in a text file output format. This is the code used: Sheets("AccessTable").Select Cells.Select ActiveWorkbook.SaveAs Filename:="C:\Data\RV Reserve\AccessTable.txt", _ FileFormat:=xlText, CreateBackup:=False How can I stop Excel from asking if I want to replace the existing saved file? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to Save without the Save Message | Excel Discussion (Misc queries) | |||
| How to save file without the save message? | Excel Programming | |||
| eliminating "newer version" message when saving | Excel Programming | |||
| save on exit message box | Excel Programming | |||
| save on exit message box | Excel Programming | |||
Threaded Mode
