How to use Opentext method with xlFixedWidth?

T

Together

Hi, everybody,

I want to import a text file into excel file, and I can use opentex
method. But the problem is that I want to convert each column in tex
file into one column in excel file. So I can use xlFixedWidt
parameter. But I do not know to fix the width ( I hope the width is on
character, the minimum). If I write code like these:

Workbooks.opentext Filename:=DaSourceBefore & DaSourceFile, _
Origin:=xlWindows, _
StartRow:=1, _
DataType:=xlFixedWidth, _

Width :=1

TextQualifier:=xlTextQualifierSingleQuote


It can not work. Please help me. Thanks
 
S

shockley

Do the import manually with the macro recorder turned on. That way you can
see and adjust graphically how Excel is splitting the text file into
columns. Then recover and edit the code in the vb editor.

HTH,
Shockley
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conversion from text to excel 2
Open Text Method Fails 7
Open a text file in a template 4
Cannot open text workbook 1
Pass string as Parameter in OpenText method 0
opentext method 0
Err 1004 when move Workbooks.OpenText to called Sub 2
Which Excel event to call when opening a .txt file 1

Top