Workbooks.OpenText Error

Originally Posted by sperry2565

the only thing I changed was the way it gets the path to the file....

no-you tried to assign the result of Opentext to a variable, which doesn't work because there is no result. the macro does not try to do that-it's just

workbooks.opentext...

and not

set tsiB = Workbooks.opentext(...)