Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pass string as Parameter in OpenText method
Hi Folks
I am trying to import data from text file to excel using OpenText method. It works fine . Can i pass a string contains list of fields to be imported and thir data type. 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)) What i mean is StrCode = "Array(Array(1,2))" 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:= StrCode Here i assign FieldInfo to variable strCode. If u have any soultion please let me know. Thanks & Regards Niraj |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pass date parameter into MS Query | Excel Discussion (Misc queries) | |||
Is it possible to pass a parameter into IN operator in Query? | Excel Discussion (Misc queries) | |||
How to: Pass Command Line Parameter ??? | Excel Worksheet Functions | |||
How to pass a workshhet name as a parameter into a subroutine ? | Excel Discussion (Misc queries) | |||
Can we Pass String to FieldInfo Array to OpenText Method. | Excel Programming |