Import txt files but not being forced to select them from one location (path)

**superbob** · 03-28-2011, 12:05 PM

Hi All,

I need to import mulitple text files into one Excel 2007 worksheet which are delimited by '|'. However, rather than hardcoding the folder path where the .txt files are saved, I'd like the user to be able to select the folder and file from wherever they saved them. I don't want them to go through the import wizard though.

Any thoughts?

Thanks

bob

**JBeaucaire** · 03-28-2011, 12:26 PM

here's a snippet of code to set the import path via popup selection window, that folder will be stored as the variable fPath, then you can use that reference in the rest of your existing macro...which you didn't share, so I expect you'll adapt it.

Please Login or Register  to view this content.

**superbob** · 04-04-2011, 07:04 AM

Hi,

Thanks but I haven't built a macro yet. I wanted the whole macro to import a text file into the current worksheet with a pop-up window to select the file as the files will be in different locations depending on the user.

Thanks

SB

**JBeaucaire** · 04-04-2011, 09:00 AM

Since during the importation of a text file there are several decisions you have to make, turn on the macro recorder and record all the steps you currently go through to get a text file imported. Post the resulting code and we can adjust it together to add the snippet above.

**superbob** · 04-04-2011, 09:19 AM

Hi,

Thanks for your help! I did what you suggested and below is the code:

Please Login or Register  to view this content.

**JBeaucaire** · 04-04-2011, 06:07 PM

Simple enough. Look carefully at your macro, my original snippet, then compare them to the version here, make sure the changes I made make sense to you so you can edit, adapte, reuse this technique in the future:

Please Login or Register  to view this content.

Import txt files but not being forced to select them from one location (path)

LinkBack

Thread Tools

Rate This Thread

Display

Import txt files but not being forced to select them from one location (path)

Re: Import txt files but not being forced to select them from one location (path)

Re: Import txt files but not being forced to select them from one location (path)

Re: Import txt files but not being forced to select them from one location (path)

Re: Import txt files but not being forced to select them from one location (path)

Re: Import txt files but not being forced to select them from one location (path)

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions