Call excel_app.Workbooks.Close

Call excel_app.Workbooks.Close

shastu
Advisor Advisor
359 Views
1 Reply
Message 1 of 2

Call excel_app.Workbooks.Close

shastu
Advisor
Advisor

I can get this to work from within VBA of my Inventor macro, but when the file closes I see a Microsoft Excel dialog box that opens and says, "Do you want to save the changes you made to 'Book1?'  and has three buttons, "Save", "Don't Save", and "Cancel"  Is there anyway to use this command without seeing this dialog box and saving the file to a location with a specific name?  I would greatly appreciate any help with this.

0 Likes
Accepted solutions (1)
360 Views
1 Reply
Reply (1)
Message 2 of 2

shastu
Advisor
Advisor
Accepted solution

Never mind,  I got it.

 

excel_app.ActiveWorkbook.Saveas FileName:="C:\Users\ShaStu\Documents\" & sProp & ".xlsx"

0 Likes