ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA interactive commands (https://www.excelbanter.com/excel-programming/276093-vba-interactive-commands.html)

bill

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.


All times are GMT +1. The time now is 05:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com