Excel 2000

A

antinoz

does anybody have example code for importing a txt file using a query table
Set shFirstQtr = Workbooks(1).Worksheets(1) etc etc
with .TextFileParseType = xlFixedWidth that Acctually works in excel 2000.

The excel help file code does'nt work in excel 2000 version 9

it just imports the data into 1 column usually D

if anybody has a example that works in excel 2000 I would Greatly appreciate
it.
 
A

antinoz

Thanks Sebastienm,

After alittle tweaking of the recorded marco everythings working perfectly

A BIG Thank YOU

ant
 
S

sebastienm

You're welcome.
Glad i could help.
Sébastien

antinoz said:
Thanks Sebastienm,

After alittle tweaking of the recorded marco everythings working perfectly

A BIG Thank YOU

ant
Click to expand...
 
Top