So far I've been able to find answers to all my questions by looking through old threads, but this one has me stumped.

Basically I'm just trying to import all the .txt files in a given folder into Excel and format the results. I have no problem doing this so long as I give an absolute path to the folder with the .txt files. I really need to be able to use a relative path for this, though, and can't figure it out.

Here's a snippet of my code:

With Application.FileSearch
'Change this to your directory
.LookIn = "\\NWS_APPS01\VOL1\CSCO Learning Lounge\Production\Assessment\Assessment 1\Data"
.SearchSubFolders = False
.Filename = "*.txt"

I've tried changing the .Lookin to just "\Data" or "Data" to try and have it look in a data folder that is in the same location as the excel file, but that doesn't seem to work. Is there something special about relative paths in Excel that I'm missing?

Thanks for any help.