View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
hmm hmm is offline
external usenet poster
 
Posts: 175
Default 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)