Vba Activeworkbooksave False. So, the True/False status of the saved property does not help us to know if a file has ever been saved. I have a VBA macro which is called from a spreadsheet function (user defined function, UDF).
Stop searching for VBA code online. Workbooks can be accessed through the Workbooks collection. However when running the macro or stepping through this function call in DEBUG mode it still saves the file.
Stop searching for VBA code online.
However when running the macro or stepping through this function call in DEBUG mode it still saves the file.
Save As behaves similarly to Save, except you also need to specify the name of the new file. Generate accurate VBA code in seconds with AutoMacro. This video is about using VBA to open workbooks, save workbooks, and close workbooks.