| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can we Pass String to FieldInfo Array to OpenText Method.
Hi ,
Let me introduce myself first .Myself is niraj working as developer in Singpore. Pls help me out to resolve this issue. I export data from text file to excel Using Workbook.OpenText method. Find below Syntax . Workbooks.OpenText FileName:="C:\ips\ips.txt", Origin:=xlWindows, _ StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _ ConsecutiveDelimiter:=False, Tab:=False, Semicolon:=False, Comma:=True _ , Space:=False, Other:=False, FieldInfo:=Array (Array(1, 2)) .. Can i Pass string parameter to FieldInfo . FieldInfo is one of the optional argument of OpenText method. I would like to do this |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cant pass array to excel from c++ using xloper structure | Excel Worksheet Functions | |||
| combining cells and array from different sheets into an array to pass to IRR() | Excel Discussion (Misc queries) | |||
| warning: cannot change part of an array. how do I by pass this? | Excel Worksheet Functions | |||
| Pass an array to Rank | Excel Worksheet Functions | |||
| After OpenText all pastes from external apps use format from OpenText | Excel Programming | |||
Linear Mode
