Hi Roger, no problem running your code with Excel 365 but read the following article:
Changing File Block settings to enable old Excel file types to be opened as normal https://www.clouddirect.net/knowledge-base/KB0011787/changing-file-block-settings-to-enable-old-excel-file-types-to-be-opened-as-normal Error message in Office when a file is blocked by registry policy settings https://docs.microsoft.com/en-us/office/troubleshoot/settings/file-blocked-in-office Opening an XLS file gives the error "You are attempting to open a file type (Excel 2) that has been blocked by your File Block settings in the Trust Center." Opening ax XLSX file works flawlessly. Gianni On Mon, 24 Feb 2020 17:24:57 -0500, roger tremblay <[email protected]> wrote: 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. _______________________________________________ Post Messages to: [email protected] 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/[email protected] ** 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.
