Save New Excel Workbook

Hello,

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.

Thanks,

@sumire,

How you are creating the excel file?

Kindly share some more information

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

@sumire

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.