but if use below code, i must offer path file , then i must save the file first........
How to export the excel and not call book1, if user want to save , then save the file and default the file name call aa......
Not save the file in direct paht first....
How to change my default Workbook template?
XL.ActiveWorkbook.SaveAs(path and name of the file, Format Of The File)