Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
David Langschied
 
Posts: n/a
Default importing into excel by worksheet.

Hello,
I would like to automate one of my processes. Currently, I am going to each
worksheet and importing the appropriate text file for that worksheet. I also
would like to have the import process automatically separate by coma. Is
this possible to do?

I currently have Office 2000, but I am willing to upgrade if the
functionality is available in 2003.

  #2   Report Post  
peter
 
Posts: n/a
Default

I am kinda new to excel but I had recently spent some time on a similar
sheet. I believe what you do first is go to data, get external data,
import text file, delimited, separate by comma. This will import it
once. Then go to data, get external data, refresh data on file open.
You may want to uncheck prompt for filename on refresh. I do not have
my sheet here with me now, but it seems to me I had to also check
overwrite existing cells... 2nd from the bottom. You may or may not
want to do this last step depending on how your sheet is set up, but
you can experiment. I think this will do what you require, but I'm not
sure. Hope it helps.

Peter

  #3   Report Post  
David Langschied
 
Posts: n/a
Default

Thank you! I will try this. It looks too good to be true, but I deserve at
least one such event in my life.


"David Langschied" wrote:

Hello,
I would like to automate one of my processes. Currently, I am going to each
worksheet and importing the appropriate text file for that worksheet. I also
would like to have the import process automatically separate by coma. Is
this possible to do?

I currently have Office 2000, but I am willing to upgrade if the
functionality is available in 2003.

Reply
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
Excel shifts to wrong worksheet automatically Tom77 Excel Worksheet Functions 1 February 24th 05 09:10 PM
create menus in excel worksheet Anthony Excel Worksheet Functions 1 February 23rd 05 04:04 PM
Change position of move or copy worksheet option in Excel JesseAviles Excel Discussion (Misc queries) 1 February 22nd 05 11:25 PM
How do I replace a worksheet with another worksheet in excel Ammnon Excel Worksheet Functions 1 January 12th 05 11:48 AM
How do I convert an existing MS Excel worksheet tracking a simple. NOTANYJOE Excel Discussion (Misc queries) 1 January 4th 05 03:07 AM


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

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"