Save New Excel Workbook

[sumire (mitsuko kurata)]

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,

[sarathi125 (Parthasarathi)]

@sumire,

How you are creating the excel file?

Kindly share some more information

[sumire (mitsuko kurata)]

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

[Sreelatha278 (Sree Latha Reddy)]

@sumire

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

[sumire (mitsuko kurata)]

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