How to direct a path name in VBA

Hi all,
I will apologize in advance for asking such a mundane question, but I'm very new at this. I have a large workbook that I would like to use as a template on many directories of information. What I hope to do is have the user specify what directory the information is located in and then import a bunch of data from that folder into various worksheets. From searching online, I found the following macro for selecting the directory:

Please Login or Register  to view this content.

From what I understand, the directory path (ie. "C:\Files\Data") is stored as the string path. Is this correct? If so, then I would like to replace my data import syntax with this path. In the following example, how do I replace "C:\Documents and Settings\Administrator\Desktop\Test of unmixing EZ-C1 3.50\CD\CD - High Accuracy Average Reference Spectra" with my path string?

Please Login or Register  to view this content.

Thanks in advance!

Welcome to the Forum. Please take the time to read the Forum Rules, they are posted at the top of each Forum, & use Code tags in future. i will add them this time.

Try

Please Login or Register  to view this content.