You still need the 32 bit version of Excel installed in order to do any COM automation.
--
rk
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of roger tremblay Sent: Monday, February 24, 2020 5:25 PM To: profoxtech@leafe.com Subject: Problem Calling in Excel
I have a program which calls in excel (excel 2010) and it works well however with the advent of Excel 365 I can not make the call and get it to work below is the sample code used and it does work on 2010. Any help would be appreciated.
thank you in advance
Roger
LOCAL loExcel loExcel = CREATEOBJECT("EXCEL.APPLICATION") loExcel.workbooks.open("C:\dev\BARNS\CLIP\BARCODE.xls") loExcel.visible = .t.
-- Roger Tremblay Tremblay and Associates Phone 617 308 4793
_______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: https://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: https://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: https://leafe.com/archives This message: https://leafe.com/archives/byMID/09b86faa-a12b-f5ff-7870-e56976c2ba93@gmail.... ** 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/09b86faa-a12b-f5ff-7870-e56976c2ba93@gmail.com