doesn't matter. They both fail in production, both open no problem in dev.
R
raeyoung
@raeyoung
Posts
-
Visual Basic "originated from an internet" EXCEL -
Visual Basic "originated from an internet" EXCELProduction - interop 12
-
Visual Basic "originated from an internet" EXCELI have a visual basic application developed to read an EXCEL file. It is written with late binding because my development machine has Microsoft.Office.Interop.EXCEL 14 and the production machines uses Microsoft.Office.Interop.EXCEL 12. We get an error opening the workbook on the production machine but not on the development machine. It only happens for files that have the "originated from an internet" ADS. Is there an EXCEL or FILE setting I have missed?
Dim oXL As Object = CreateObject("Excel.Application") Dim oWBK As Object = oXL.workbooks Dim oWS As Object = CreateObject("Excel.Sheet") oXL.AutomationSecurity = 3 oXL.DisplayAlerts = False oXL.Visible = False oXL.AskToUpdateLinks = False oWBK = oXL.Workbooks.Open(Path.Combine(l\_s\_SourcePath, l\_s\_SourceFileName), UpdateLinks:=False, ReadOnly:=True, CorruptLoad:=1)