1 - set the saved property to .t. before you get rid of the Excel object.
m.loExcel.ActiveWorkbook.Saved=.t.
2 - I bet Ted wants a crack at that one. 😊
--
rk
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of mbsoftwaresolutions@mbsoftwaresolutions.com Sent: Wednesday, September 5, 2018 4:47 PM To: profoxtech@leafe.com Subject: 2 Excel questions using automation from VFP9SP2
See screenshot for case matter: https://www.screencast.com/t/VNdRiSd1D
1) (rose highlight) I've forgotten how to get Excel to close without asking me this every time. Currently, I'm just calling the .Quit() method of my Excel object. I tried passing a .T. parm but that failed.
2) (yellow highlight) Anybody know how to get this slick NETWORKDAYS formula to work in VFP? Would be neat to have this and I thought perhaps someone already built it.
tia, --Mike
_______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/c098c4933dff7f770255511062c0dee9@mbso... ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Report [OT] Abuse: http://leafe.com/reportAbuse/c098c4933dff7f770255511062c0dee9@mbsoftwaresolu...