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-set...
Error message in Office when a file is blocked by registry policy settings https://docs.microsoft.com/en-us/office/troubleshoot/settings/file-blocked-i...
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 rogtrem@gmail.com 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.