Runtime error 91

[John_B]

Hello, When Ever I run my code I get the runtime '91': object variable or with block variable not set.

Any help?



Dim oXL As Excel.Application
Set oXL = CreateObject("Excel.Application")

oXL.Visible = True
oXL.VBE.ActiveVBProject.vbComponents.Import ("\\LG-NAS\Parallax")

 

[VBA Geek]

you get this error because there are no workbooks in your oXL

Dim oXL As Excel.Application
Set oXL = CreateObject("Excel.Application")
oXL.Visible = True
[COLOR=#ff0000][B]oXL.Workbooks.Add[/B][/COLOR]
oXL.VBE.ActiveVBProject.VBComponents.Import "D:\ProjX\mProjx.bas"

Hello, When Ever I run my code I get the runtime '91': object variable or with block variable not set.

Any help?



Dim oXL As Excel.Application
Set oXL = CreateObject("Excel.Application")

oXL.Visible = True
oXL.VBE.ActiveVBProject.vbComponents.Import ("\\LG-NAS\Parallax")