+ Reply to Thread
Results 1 to 2 of 2

Import Wizard settings

  1. #1
    Pat
    Guest

    Import Wizard settings

    I'm importing comma delimited files into excel. I would like to set the
    import wizard settings so that it is always "delimited" (rather than "fixed
    width") and "comma" (rather than "tab"). Is there a way to do this?

    Thanks
    Patricia

    --
    ***This message has been scanned for viruses by Norton Utilities ***



  2. #2
    Pete_UK
    Guest

    Re: Import Wizard settings

    You could record a macro while you do it once and choose the settings
    you require for each stage. Then in future you only need to run the
    macro.

    I think Dave Peterson gave a skeleton outline a few day's ago in
    response to a similar request.

    Hope this helps.

    Pete


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1