Heres the problem,
I have a VB6 Program that I'm using to open an excel file then run a macro.
The program runs fine if the excel file is not compiled (I EXPORT OUT ALL THE VBA THEN RE-IMPORT IT)
when compile I get a Run-Time '-2147417851 (80010105) Method '~' of object '~' failed
Also I have noticed that the file
uncompiled is 404k
compiled is 736k
any ideas
running windows XP Pro
excel 2003
thanks for any input you can provide
steve
I have a VB6 Program that I'm using to open an excel file then run a macro.
Code:
Private Sub btnOPEN_Click()
Dim xl As Object
Set xl = CreateObject("Excel.Application")
'xl.Visible = True
frmMain.Visible = False
xl.workbooks.Open "\\termsrv-2\SE\BUILDERS\TEMP\PRJ\DATA\ss template.xls", False, True
xl.workbooks("ss Template.xls").Worksheets("Data SS").Range("LOTID") = ACCPACID
xl.workbooks("ss Template.xls").Worksheets("Data SS").Range("COMMUNITY_ID") = COMMID
xl.workbooks("ss Template.xls").Worksheets("Data SS").Range("rngUNIQID") = 0
xl.workbooks("ss Template.xls").Worksheets("Data SS").Range("rngREVISION") = REVISION
xl.Run "Main_Code"
frmMain.Visible = True
End Sub
The program runs fine if the excel file is not compiled (I EXPORT OUT ALL THE VBA THEN RE-IMPORT IT)
when compile I get a Run-Time '-2147417851 (80010105) Method '~' of object '~' failed
Also I have noticed that the file
uncompiled is 404k
compiled is 736k
any ideas
running windows XP Pro
excel 2003
thanks for any input you can provide
steve