Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am trying to open a text report-type document and put it into an excel
spreadsheet. To prototype my command, I tested the following statement: Excel.Workbooks.OpenText FileName:=sAttachPath & "\" & EMAttachment, fieldinfo:=Array(Array(0, 1), Array(13, 1), Array(23, 1), Array(39, 1), Array(70, 1), Array(75, 1), Array(83, 1), Array(94, 1)) .... which works very well. But when I try to make it customizable, I tested the following statement: Excel.Workbooks.OpenText FileName:=sAttachPath & "\" & EMAttachment, fieldinfo:=sFieldInfo .... where sFieldInfo is set to "Array(Array(0, 1), Array(13, 1), Array(23, 1), Array(39, 1), Array(70, 1), Array(75, 1), Array(83, 1), Array(94, 1))", I get the error that I put in the Subject of this post. Anyone got any ideas?? Seems kinda' strange. TIA!! Bryan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
OpenText Method of Workbook Object Question | Excel Programming | |||
Runtime error 1004 with method OpenText - but only on one computer | Excel Programming | |||
How to use Opentext method with xlFixedWidth? | Excel Programming | |||
Pass string as Parameter in OpenText method | Excel Programming | |||
Can we Pass String to FieldInfo Array to OpenText Method. | Excel Programming |