LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default automation - import into excel

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
* * * * * * * * * *


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Excel with automation Thomas Bodell Excel Discussion (Misc queries) 5 May 8th 09 03:09 PM
How to Start Excel in Text Import Wizard for data import rlelvis Setting up and Configuration of Excel 0 July 10th 08 08:40 PM
Automation to Excel from Access Bob Barnes Excel Discussion (Misc queries) 1 February 11th 08 05:18 AM
Excel spradsheet automation help deepika New Users to Excel 1 January 4th 08 06:22 PM
automation from access into excel SAm Excel Discussion (Misc queries) 7 January 27th 06 02:49 AM


All times are GMT +1. The time now is 09:02 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"