Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
User select folder name
Hi,
I have a number of csv files which I import into a spreadsheet. This all works fine, but I have hardcoded the name of the folder which contains the csv files. How can I share this spreadsheet with my colleagues and allow then to put their CVs files anywhere on their system, and simply have excel use the open file dialogue to let them navigate to the correct folder? I don't want them to have to select the files (as there will be many csv and other files in the folder). I just want to capture the path of the folder they choose and have excel use this to import the csv files. Thanks, Matt |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
User select folder name
Hi MJKelly
See example 2 http://www.rondebruin.nl/csv.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "MJKelly" wrote in message ... Hi, I have a number of csv files which I import into a spreadsheet. This all works fine, but I have hardcoded the name of the folder which contains the csv files. How can I share this spreadsheet with my colleagues and allow then to put their CVs files anywhere on their system, and simply have excel use the open file dialogue to let them navigate to the correct folder? I don't want them to have to select the files (as there will be many csv and other files in the folder). I just want to capture the path of the folder they choose and have excel use this to import the csv files. Thanks, Matt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
API for a user to select a folder? | Excel Programming | |||
How to Prompt a user to select a Folder. | Excel Programming | |||
Dialog box for user to select a folder | Excel Programming | |||
User select Save To Folder | Excel Programming | |||
allow user to select folder | Excel Discussion (Misc queries) |