| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save without prompt and Activate a file
1. How to save a workheet to a same text file without prompted by replace or
not ? ( ActiveWorkbook.SaveAs Filename:= _ "C:\Documents and Settings\lem83mk.MALAYSIA\My Documents\dummy2.txt", _ FileFormat:=xlText, CreateBackup:=False ) . I want the file is saved automatically when macro is run without promted to be replaced or not. 2. I would like to run a macro that can activate ( double-click ) a batch file in the directory ( C:\abc.bat ). Can this be done in the VBA macro ? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Save without prompt and Activate a file
See either of your other two posts for responses
--- Regards, Norman "mok707" wrote in message ... 1. How to save a workheet to a same text file without prompted by replace or not ? ( ActiveWorkbook.SaveAs Filename:= _ "C:\Documents and Settings\lem83mk.MALAYSIA\My Documents\dummy2.txt", _ FileFormat:=xlText, CreateBackup:=False ) . I want the file is saved automatically when macro is run without promted to be replaced or not. 2. I would like to run a macro that can activate ( double-click ) a batch file in the directory ( C:\abc.bat ). Can this be done in the VBA macro ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Turning off prompt to save file with no changes | Excel Discussion (Misc queries) | |||
| Prompt to save file | Setting up and Configuration of Excel | |||
| save prompt for user exit, but no save prompt for batch import? | Excel Discussion (Misc queries) | |||
| Prompt for Save when closing a file | Excel Discussion (Misc queries) | |||
| Prompt user to save their file | Excel Programming | |||
Linear Mode
