![]() |
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