Re: Chip Pearson Import/Export Macros

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: saturnin02 (saturnin02_at_hotmail.com)
Date: 04/03/04 

Date: Fri, 2 Apr 2004 20:46:29 -0500

Chip, Bear with me but I do not understand.
Do you mean in the same workbook as the import one, separate workbook .....
Which macro first, etc.
I am really a newb--please help me get going.
TX.
S

"Chip Pearson" <chip@cpearson.com> wrote in message
news:#W6JrGRGEHA.3188@TK2MSFTNGP10.phx.gbl...
> 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
> news:%230d2j6QGEHA.744@TK2MSFTNGP09.phx.gbl...
> > 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
> >
> >
> >
>
>

Relevant Pages

  • Re: run macros on a protected sheet?
    ... Chip -- That's what I suspected. ... >prior to executing the macro. ... >Pearson Software Consulting, LLC ... >> Is it possible to run a macro on a protected sheet? ...
    (microsoft.public.excel.programming)
  • Re: Delete a macro with a macro
    ... Vaya con Dios, ... Chip does it the right way but John Walkenbach has also suggested another ... 1- Chips procedures require setting a reference to the "Microsoft Visual ... Private Sub Workbook_Openmacro ...
    (microsoft.public.excel.programming)
  • Re: Please help, file name issue
    ... Thanks Chip, that is ... >Dim AWB As Workbook ... >Pearson Software Consulting, LLC ... >> How do I setup a macro to where no matter what file runs ...
    (microsoft.public.excel.programming)
  • Re: Open Directory
    ... Thanks Tom and Chip for your suggestions. ... The reason that I want the macro to only open the directory and no more is ... > Microsoft MVP - Excel ...
    (microsoft.public.excel.programming)
  • Re: Password Protect Macro?
    ... Chip has described the method. ... > Basic macro but deny the user access to the macro. ... To protect a project, open ... >> the VBA Editor, go to the Tools menu, choose VBA Project ...
    (microsoft.public.excel.programming)