Relative references for external data

M

msipatel

How do you have relative references for imported external data?

The data is in the form of CSV files. I need to refer to files in the
same directory as the directory in which the Excel file resides. This
directory could be moved around and there would be no problem. The data
is automatically refreshed when the workbook is opened.
 
Top