To download the workbook used in this video: www.mrexcel.com/download-center/2018/06/save-as-keeping-original-open.xlsm To read the steps, read this article: www.mrexcel.com/excel-tips/save-as-keeping-original-open/
@leonardopetreca144
2 жыл бұрын
Thank you so much for your video! I had spent many hours in my code using only "SaveAs" and I got many problems. With your tip, It has worked fine!
@joem112
6 жыл бұрын
Great video. Withe the SaveAsCopy method you can consider the original workbook a template!
@MrXL
6 жыл бұрын
Joe M right! I knew this video is a bit too geeky, but it will be useful for the right niche!
@ahmedal-dossary4386
6 жыл бұрын
What a cool tip.!! Thanks for sharing Mr. Excel
@MrXL
6 жыл бұрын
+Ahmed Al-Dossary thanks Ahmed!
@excelisfun
6 жыл бұрын
Really cool trick!!!!
@MrXL
6 жыл бұрын
+ExcelIsFun thanks Mike!!! This makes Excel More Fun!
@nikiss8
6 жыл бұрын
very nice, i keep planing to learn to save one sheet as copy innew workbook. when sending emails i do not want to share my macros.
@MrXL
6 жыл бұрын
My video 1505 shows how to do this... kzitem.info/news/bejne/taCVqZlthYVigqA
@HoppersLab
2 жыл бұрын
ActiveWorkbook.SaveAs Filename:="C:\Temp\Shift_Summary_" & Format(Now(), "DD-MMM-YYYY") & ".xlsm", FileFormat:=52 Can you tell me why this locks Excel when i save the file, sometimes Excel will restart on it's own and most of the time it just says Not Responding.
Пікірлер: 13