Runtime error blues

[DThib]

The snippet of code below is giving me fits.
I have a couple of input boxes putting in the variable name and the Stub1 is the path and the name of the file.

It is throwing an error when I point to the network.
"Run-time error '1004':
Method 'OpenText' of Object 'Workbooks' failed.

I cannot find anything that talks about this error in Excel 365

workbooks.OpenText Filename:=Stub1, Origin:=65001, StartRow:=1, DataType:=xlDelimited, _
        Comma:=True, FieldInfo:=Array(Array(1, 2), Array(2, 1), Array(3, 1), Array(4, 1), _
        Array(5, 1), Array(6, 1), Array(7, 1), Array(8, 1), Array(9, 1), Array(10, 1), _
        Array(11, 1), Array(12, 1), Array(13, 1), Array(14, 1), Array(15, 1)), TrailingMinusNumbers:=True

What's going on?

Help, please!

Dthib

 

[jproffer]

Did you try Workbooks.Open ?

 

[DThib]

Thanks for the suggestion.

Same result, though.


DThib

 

[DThib]

It works now!
The server addresswas throwng an error that stalled at this step since it could not resolve itself.

DThib

 

[jproffer]

Sorry I didn't come back on...to be honest, I had never seen Workbook.OpenText and when you said that .Open didn't work either, I didn't really have anything useful to add. I'm glad you got it working though