Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro error opening text file | Excel Discussion (Misc queries) | |||
Problems opening a text file using macro! | Excel Programming | |||
Opening text file in Excel through macro | Excel Programming | |||
Opening text file in Excel through macro | Excel Programming | |||
Opening text file in Excel through macro | Excel Programming |