I'm not quite sure what you're doing.

But if you're doing this from a macro, maybe you could just use
application.getopenfilename. It would allow you to browse for your file.

Or if the .csv file is in the same location as the workbook that contains the
macro, you could find the path of that workbook by using

thisworkbook.path

So you could use...

dim myCSVFileName as string
mycsvfilename = thisworkbook.path & "\filename.csv"



Christopher Blue wrote:

I know how to import external data from a .csv, but how can I have the path
be relative so I can move the directory around without having to update the
.csv file location manually?

--

Dave Peterson