Click here to Skip to main content
14,695,503 members
Home » Discussions » Visual Basic
   

Visual Basic

 
AnswerRe: Compare File Date Created Date Modified in VBA ( Allow Download time 20 mintes Buffer Time) Pin
Richard MacCutchan25-Apr-20 5:14
mveRichard MacCutchan25-Apr-20 5:14 
QuestionBinding Navigator Movement Event Error Pin
Member 1480975422-Apr-20 0:23
MemberMember 1480975422-Apr-20 0:23 
AnswerRe: Binding Navigator Movement Event Error Pin
Gerry Schmitz22-Apr-20 10:14
mveGerry Schmitz22-Apr-20 10:14 
GeneralRe: Binding Navigator Movement Event Error Pin
Member 1480975423-Apr-20 0:16
MemberMember 1480975423-Apr-20 0:16 
GeneralRe: Binding Navigator Movement Event Error Pin
Mycroft Holmes23-Apr-20 12:16
professionalMycroft Holmes23-Apr-20 12:16 
QuestionLogoff or disconnect system account session at Ctrl + Alt + Delete screen Pin
Member 146239898-Apr-20 18:20
MemberMember 146239898-Apr-20 18:20 
AnswerRe: Logoff or disconnect system account session at Ctrl + Alt + Delete screen Pin
Member 1462398914-Apr-20 10:23
MemberMember 1462398914-Apr-20 10:23 
QuestionVisual Basic "originated from an internet" EXCEL Pin
raeyoung7-Apr-20 5:18
Memberraeyoung7-Apr-20 5:18 
I 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)

QuestionRe: Visual Basic "originated from an internet" EXCEL Pin
Richard MacCutchan7-Apr-20 5:50
mveRichard MacCutchan7-Apr-20 5:50 
AnswerRe: Visual Basic "originated from an internet" EXCEL Pin
raeyoung7-Apr-20 8:22
Memberraeyoung7-Apr-20 8:22 
GeneralRe: Visual Basic "originated from an internet" EXCEL Pin
Richard MacCutchan7-Apr-20 8:59
mveRichard MacCutchan7-Apr-20 8:59 
GeneralRe: Visual Basic "originated from an internet" EXCEL Pin
raeyoung7-Apr-20 9:07
Memberraeyoung7-Apr-20 9:07 
GeneralRe: Visual Basic "originated from an internet" EXCEL Pin
Richard MacCutchan7-Apr-20 10:12
mveRichard MacCutchan7-Apr-20 10:12 
AnswerRe: Visual Basic "originated from an internet" EXCEL Pin
Mycroft Holmes7-Apr-20 12:15
professionalMycroft Holmes7-Apr-20 12:15 
QuestionInstall a VB Net application to install a sql database on other computers Pin
Member 147798703-Apr-20 13:41
MemberMember 147798703-Apr-20 13:41 
AnswerRe: Install a VB Net application to install a sql database on other computers Pin
Dave Kreskowiak3-Apr-20 15:12
mveDave Kreskowiak3-Apr-20 15:12 
AnswerRe: Install a VB Net application to install a sql database on other computers Pin
evry1falls6-May-20 10:22
Memberevry1falls6-May-20 10:22 
QuestionLinq GroupBy Invoice Number, iterate all items before group Pin
jkirkerx3-Apr-20 8:48
professionaljkirkerx3-Apr-20 8:48 
AnswerRe: Linq GroupBy Invoice Number, iterate all items before group Pin
jkirkerx3-Apr-20 9:51
professionaljkirkerx3-Apr-20 9:51 
GeneralRe: Linq GroupBy Invoice Number, iterate all items before group Pin
Richard Deeming6-Apr-20 2:19
mveRichard Deeming6-Apr-20 2:19 
GeneralRe: Linq GroupBy Invoice Number, iterate all items before group Pin
jkirkerx6-Apr-20 8:28
professionaljkirkerx6-Apr-20 8:28 
GeneralRe: Linq GroupBy Invoice Number, iterate all items before group Pin
Richard Deeming6-Apr-20 9:01
mveRichard Deeming6-Apr-20 9:01 
GeneralRe: Linq GroupBy Invoice Number, iterate all items before group Pin
jkirkerx6-Apr-20 10:20
professionaljkirkerx6-Apr-20 10:20 
GeneralRe: Linq GroupBy Invoice Number, iterate all items before group Pin
Richard Deeming7-Apr-20 1:30
mveRichard Deeming7-Apr-20 1:30 
GeneralRe: Linq GroupBy Invoice Number, iterate all items before group Pin
jkirkerx7-Apr-20 8:05
professionaljkirkerx7-Apr-20 8:05 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.