×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

open in excel as space separated file

open in excel as space separated file

open in excel as space separated file

(OP)
hello
i am stuck on an excel issue when opening space separated text files.
i have many text files that i need to open in excel as space separated files..... i manually click thru the OPEN> etc etc etc  tabs to do this.
can the excel defaults be changed to automatically be set to open all *.* files as space separated files?

thanks for any guidance.

daveleo

RE: open in excel as space separated file

The macro recorder is your friend in cases like this.

RE: open in excel as space separated file

There are a couple of other options for you - if you have to work on this sort of thing regularly - have you considered saving your session as workspace ?  Also, theres a fantastic add-in available at www.addins.com I think called the spreadsheet assistant - I came across it in a excel programming book - and now regularly use it - gives you quite a few options for this sort of thing.

Sean

RE: open in excel as space separated file

(OP)
sean01
are you sure about that URL ??

daveleo

RE: open in excel as space separated file

Let me plug my favorite add-in: www.asap-utilities.com
Several years ago I switched from the spreadsheet assistant to ASAP utilities and never regretted it.

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

RE: open in excel as space separated file

daveleo,

Looks like a simple typo by sean01.
Try this url for spreadsheet assistant:

http://www.add-ins.com/

RE: open in excel as space separated file

(OP)
thanks for all the input ..... guess i am going to learn a lot about add-ins and macros ....  i am semi-decent in VB6 so VBA shouldnt be too bad ....  but i DID think it would be an easy OPTIONS>SET PREFS > ....sequence in EXCEL !!

daveleo


RE: open in excel as space separated file

Daveleo,

If you import a text file, the settings will stay the same for your session. So next time you do the import, you can click Finish right away - until the next day.

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

RE: open in excel as space separated file

(OP)
joerd

that work just fine

thanks.

daveleo

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!


Resources