automation - import into excel

[Tracy]

hello,

i'm trying to find out if there is a way to open an existing spreadsheet and
have the columns rearranged automatically.
soon i will have to download a .txt file daily, which i need to use in excel
the problem is that the .txt file has several columns of data that i don't
need and the columns of data that i need is not in the right order.
i really do not want to have to sit and rearrange the columns of data that i
need every day, so i'm curious if there is something that i could set up, so
that when i open the .txt file in excel, i only get the data that i need.

any help would be greatly appreciated.

thank you

 

[JLatham]

Tracy,
You could record a macro while going through your manual process. Then in
the future you can import your data and then run that macro to repeat the
process with just a few clicks of the mouse.

Remember that the macro you record is going to perform exactly what you did
when you recorded it, including using the same sheet names and columns/rows
and all.

If you need it to be more "robust", you could record the macro and then post
back asking how to make it more flexible. Be sure you paste a copy of the
macro code with that request if you make the request.

 

[Tracy]

hi j latham

fantastic idea ! ! ! !

thank you so much.


--


Tracy
* * * * * * * * * *

: Tracy,
: You could record a macro while going through your manual process. Then in
: the future you can import your data and then run that macro to repeat the
: process with just a few clicks of the mouse.
:
: Remember that the macro you record is going to perform exactly what you
did
: when you recorded it, including using the same sheet names and
columns/rows
: and all.
:
: If you need it to be more "robust", you could record the macro and then
post
: back asking how to make it more flexible. Be sure you paste a copy of the
: macro code with that request if you make the request.
:
: "Tracy" wrote:
:
: > hello,
: >
: > i'm trying to find out if there is a way to open an existing spreadsheet
and
: > have the columns rearranged automatically.
: > soon i will have to download a .txt file daily, which i need to use in
excel
: > the problem is that the .txt file has several columns of data that i
don't
: > need and the columns of data that i need is not in the right order.
: > i really do not want to have to sit and rearrange the columns of data
that i
: > need every day, so i'm curious if there is something that i could set
up, so
: > that when i open the .txt file in excel, i only get the data that i
need.
: >
: > any help would be greatly appreciated.
: >
: > thank you
: >
: > --
: >
: >
: > Tracy
: > * * * * * * * * * *
: >
: >
: > .
: >