Deleting workbook
I'd have to do some digging to verify this, but can you
write: Workbooks("workbookname").Delete -----Original Message----- Hello Is it possible to delete a workbook in a macro? I would like to delete old workbook in first line of code so when the macro uses the save as command with this name later in code it does not produce prompt to replace ActiveWorkbook.SaveAs Filename:="R:\PROTEUSIMP.xls", FileFormat:= _ xlNormal, Password:="", WriteResPassword:="", ReadOnlyRecommended:=False _ , CreateBackup:=False or is there away to enter true to replace when I tried with recordmacro nothing was recorded thanks Tina . |
All times are GMT +1. The time now is 09:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com