Save New Excel Workbook


I want to save a new Excel workbook on screen (created by Access macro and not saved yet)
without using “send hot key”.
Please anyone tell me how to do.



How you are creating the excel file?

Kindly share some more information

Access macro
CreateObject(“Excel.Application”) and Workbooks.Add() then set data


If you are using excel application scope, check the property Auto save.


at first, I can not find how to attach Excel workbook, because it is not saved yet so it doesn’t have file name.