Hi, I'm wondering if anyone has ever attempted a similar function to
what i'm trying to achieve.
I have the problem of having to import a great deal of raw data to a
excel file from a number of different workbooks. I have created a nice
loop statement and number of subs that complete this requirement.

The procedure is driven by having the filenames and there paths located
within a sheet in my workbook, i have done it this way because the
filenames that i retrieve data from have there names changed in order
to maintain an audit trail e.g import_q1, import_q2 etc and i didn't
want users messing with hardcoded pathways.

I would like to create a button that allows the user to use the
applications.dialogs(something) functionality or something similar to
find the exact file that holds the information, when they close the
dialog then the name is saved in the correct postion on the worksheet,
once all files have been updated then the import procedure can be run.

I have done something similar that prompted a user to choose whether or
not to use a certain path, if they chose vbno then the new file was
treated as the correct one and the new filepath was saved on its
completion. Setting up the filepaths beforehand would improve the
interface and allow thecode to run without interuption.

Has anyone completed something like this before and could give me some
tips, or come across a post that may point me in right direction? I've
had a good look but not found anything yet! thanks


--
cereldine
------------------------------------------------------------------------
cereldine's Profile: http://www.excelforum.com/member.php...o&userid=32069
View this thread: http://www.excelforum.com/showthread...hreadid=536745