Post the code you are using to call the export macro.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"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