View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
saturnin02[_2_] saturnin02[_2_] is offline
external usenet poster
 
Posts: 36
Default Chip Pearson Import/Export Macros

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