Macro terminates upon opening text file
A macro worked well when it was called from the the same workbook that I
designed it in. I saved the macro to a dedicated worksheet in XLSTART. Now
when I call it from another worksheet, the procedure inexplicably terminates
upon opening a text file. The debugger just lets go - not even an error
message.
Can anyone give me any ideas as to why this might occur?
JFI, the calling line is:
Workbooks.OpenText Filename:=strPath, Origin:= _
xlWindows, StartRow:=1, DataType:=xlDelimited, TextQualifier:= _
xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=False,
Semicolon:=True, _
Comma:=False, Space:=False, Other:=False, FieldInfo:=Array(1, 1)
|