file location - function/ VBA statement.

[ag273n]

is there some function or VBA statement that can return the current file location of the excel file?

i am trying to create a file that is integrated with a set of files.. and what concerns me is that the specific link is hardcoded (VBA) into the file.. the main file opens and retrieves data from the other files, then closes it... and.. a problem is that.. if the file location is changed, the VBA code would get an error and discontinue.. what i am planning.. is if possible, to integrate to the code a statement that can identify the location of the file, thus regardless of the file location, the code would still continue.


any help please...

[JieJenn]

thisworkbook.FullName gives you the file location + the file name

thisworkbook.path gives you the file location