Dismissing/ Bypassing the Excel Save prompt

[Anonymous]

Hello,

My question is when I use GoExcel.CellValue (or other similar Excel link) snippet in iLoggic to write on a Excel sheet, I get a save prompt for the respective Excel file.

i.e.

GoExcel.CellValue ("WB1.xls", "Sheet1", "A1") = 1234

(Run Rule)

(I get a message box saying)

"Do you want to save the changes you made to "WB1.xls?"

Yes / No / Cancel

 How can i bypass this message, I would prefer it is can be done through the iLogic Rule?

 Thanks

WajihHassan

[mrattray · Accepted solution]

If you put an auto save on close sub into the excel sheet then you wont have this problem.

[Anonymous]

Thanks Mike.

 .

I am not sure how to put an AutoSave?

I have a GoExcel.Save snippet.

But what should I do in case of more than one Excel file,

Also, I do not want to save one of them (as it contains some predefined formulas)

[Curtis_Waguespack · Accepted solution]

Hi WHassan,

I think you can use this:

excelApp.DisplayAlerts = false

There is an example of it in use here:

http://forums.autodesk.com/t5/Autodesk-Inventor-Customization/How-to-create-a-excel-file-using-ilogi...

I hope this helps.
Best of luck to you in all of your Inventor pursuits,
Curtis
http://inventortrenches.blogspot.com