Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
OpenText method not working
I am automating a text file from Word to Excel. When I try to open the text
file in Excel from Word using: xlApp.Workbooks.OpenText Filename:= _ wdFile & ".txt", Origin:=437, _ StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlNone, _ ConsecutiveDelimiter:=True, Tab:=False, Semicolon:=False, Comma:=False _ , Space:=True, Other:=False, TrailingMinusNumbers:=True I get an error. If I delete everything except the filename and the origin, it works correctly. However, I need to have the file delimited by spaces. What is wrong with this? Thanks, Pflugs |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
opentext method | Excel Programming | |||
OpenText Method | Excel Programming | |||
OpenText Method failure | Excel Programming | |||
How to use Opentext method with xlFixedWidth? | Excel Programming | |||
Pass string as Parameter in OpenText method | Excel Programming |