macro for copying

Hi all

I am trying to create a macro that copies from a txt file into excel but it
does not work.

I have a excel file with 12 sheets for each month and in each 5 columns headed
year, period,account,location,value.

I want it to get info from a txt file and paste it in columnsC,D and E.
The problem is that it doesn't give me the chance to everytime I run it,
choose which file to get the info from (there are a few txt files to chose
from) or what tab to paste it to.
Is there a way to create this macro?

Any help would be very much appreciated. I have excel 2000 pro.

Thanks

Typically you use the Application.GetOpenFilename method to have the user
pick a file. See VB Help for more on this.

--
Jim
"pedro AM" <pedroAM@discussions.microsoft.com> wrote in message
news:3B963F81-3F8F-4703-95D0-1E790EC415DE@microsoft.com...
> Hi all
>
> I am trying to create a macro that copies from a txt file into excel but
> it
> does not work.
>
> I have a excel file with 12 sheets for each month and in each 5 columns
> headed
> year, period,account,location,value.
>
> I want it to get info from a txt file and paste it in columnsC,D and E.
> The problem is that it doesn't give me the chance to everytime I run it,
> choose which file to get the info from (there are a few txt files to chose
> from) or what tab to paste it to.
> Is there a way to create this macro?
>
> Any help would be very much appreciated. I have excel 2000 pro.
>
> Thanks

thanks Jim
I will try it as soon as I can

"Jim Rech" wrote:

> Typically you use the Application.GetOpenFilename method to have the user
> pick a file. See VB Help for more on this.
>
> --
> Jim
> "pedro AM" <pedroAM@discussions.microsoft.com> wrote in message
> news:3B963F81-3F8F-4703-95D0-1E790EC415DE@microsoft.com...
> > Hi all
> >
> > I am trying to create a macro that copies from a txt file into excel but
> > it
> > does not work.
> >
> > I have a excel file with 12 sheets for each month and in each 5 columns
> > headed
> > year, period,account,location,value.
> >
> > I want it to get info from a txt file and paste it in columnsC,D and E.
> > The problem is that it doesn't give me the chance to everytime I run it,
> > choose which file to get the info from (there are a few txt files to chose
> > from) or what tab to paste it to.
> > Is there a way to create this macro?
> >
> > Any help would be very much appreciated. I have excel 2000 pro.
> >
> > Thanks
>
>
>