Where did you install the macros, same workbook ?
Where do you use the macros, same workbook ?

If you use the macro from a different workbook that
workbook should be hidden if you want access to the
macros without specifying the workbook name.

Excel Window menu, hide files

More information in
http://www.mvps.org/dmcritchie/excel/install.htm

I am assuming you copied Chip's code without changes.
Are the two macro in the same module if they are and one
works then they both in standard modules and neither is
in a class module.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"saturnin02" <saturnin02_at_hotmail.com wrote in message ...
Hi,

I need help on the Macros posted on chip's web site at
http://www.cpearson.com/excel/imptext.htm

(I am a newbie at VB.)

I have basically copied and pasted the 2 macros for importing-each in a
separate module and saved in a file (importtotext.xls).

When I open the file and then minimize it, if I have another file open into
which I want to import text data, I run the macro and it works.

(I may not even be doing this right.)

Doing the same for the EXPORT macro does not work.

I just copied and pasted into a module each of the EXPORT macros but no
joy--I get error messages such as "delimiter" expected here, or parameter
expected etc.

I was wondering if anyone could help me figure it out as I could REALLY use
the export macros!

Tx a million.

S