VB6 - Excel Help Please

[vbpadawan]

I am attempting to open an excel worksheet and update the links using VB6. For some reason the Excel.Application is not being created and I receive the following error:
<Object variable or With block variable not set>

Below is my code:

Private Sub UpdateLinks()
Dim ExAp As Excel.Application
Dim ExWb As Excel.Workbook

Set ExAp = New Excel.Application

ExWb.Open &quot;C:\Projects\filename.xls&quot;, 3, True

ExWb.RunAutoMacros xlAutoActivate
End Sub

 

[Hypetia]

Try this:
___
Private Sub UpdateLinks()
Dim ExAp As Excel.Application
Dim ExWb As Excel.Workbook

Set ExAp = New Excel.Application
Set ExWb = ExAp.Workbooks.Open(...)

ExWb.RunAutoMacros xlAutoActivate
End Sub

 

[suoirotciv]

for more info

faq222-3383

Please pardon the grammar.
Not good in english.