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

"antinoz" wrote:

Thanks Sebastienm,

After alittle tweaking of the recorded marco everythings working perfectly

A BIG Thank YOU

ant

"antinoz" wrote:

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.