Excel 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Thanks Sebastienm,

After alittle tweaking of the recorded marco everythings working perfectly

A BIG Thank YOU

ant
 
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...
 
You must log in or register to reply here.

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

querytable connection 1
User Select File on Import External Data 3
Workbooks.OpenText Error 1004 3
Excel 2003 and 2000 and VBA Macro 2
Selection.Sort Key1: Problem 4
Looping a Macro 1
excel importing data 16
importing text file in excel97 1

Back
Top