PC Review


Reply
Thread Tools Rate Thread

Can we Pass String to FieldInfo Array to OpenText Method.

 
 
Niraj Kumar Singh
Guest
Posts: n/a
 
      8th Jan 2004
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Workbooks.OpenText Method / FieldInfo JP Ronse Microsoft Excel Programming 2 22nd Jan 2010 01:57 AM
OpenText FieldInfo:= Array =?Utf-8?B?UEJlenVjaGE=?= Microsoft Excel Programming 1 28th Mar 2007 07:42 AM
RE: OpenText FieldInfo:= Array =?Utf-8?B?VG9tIE9naWx2eQ==?= Microsoft Excel Programming 0 28th Mar 2007 12:56 AM
How to pass FieldInfo parameter to Workbooks::OpenText(...) in VC+ =?Utf-8?B?TGlseQ==?= Microsoft Excel Programming 1 26th Sep 2005 02:03 PM
Pass string as Parameter in OpenText method Microsoft Excel Programming 0 8th Jan 2004 06:22 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:38 PM.