Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA interactive commands
I want VBA to "save as" and replace an existing file.
When I record the macro, I go through the steps including clicking "yes" when asked if I want to replace the existing file with the one being saved. But that step doesn't show up in the code. Can someone provide a sample code to answer "yes" when asked if I want to replace the file? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
interactive excel | Excel Discussion (Misc queries) | |||
Interactive course | New Users to Excel | |||
Interactive Chart? | Charts and Charting in Excel | |||
Interactive checkboxes | Excel Discussion (Misc queries) | |||
iNTERACTIVE EXCEL FILE NOT INTERACTIVE ON THE WEB | Excel Discussion (Misc queries) |