Dialogue box to select folder >files for import?

**firebladejr** · 03-05-2008, 09:48 PM

Hi,

The below code imports seperate csv's from "C:\Temp\OTC_Files\", then populates the workbook with each csv becoming a worksheet. Is it possible to amend the code to present the user with a dialogue box where they can browse to the folder containing the files, then select the necessary files? I've tried a few different methods but seem to be making a mess of the code rather than progress...

any help would be great.

Please Login or Register  to view this content.

**dominicb** · 03-06-2008, 06:22 AM

Good morning firebladejr

Originally Posted by firebladejr

Is it possible to amend the code to present the user with a dialogue box where they can browse to the folder containing the files, then select the necessary files?

You need to have a look at the GetOpenFilename function in VBA help :

Please Login or Register  to view this content.

The code above will ask you to choose a file, and dump the path / filename into the variable f, for you to do with as you please.

HTH

DominicB

**chrismann85** · 06-04-2008, 08:38 AM

This is the code I use, I thought it may be of use to you:

Please Login or Register  to view this content.

Dialogue box to select folder >files for import?

LinkBack

Thread Tools

Rate This Thread

Display

Dialogue box to select folder >files for import?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions