ok ill try and explain this as easily as i can.

I export a csv daily (1-Borrowed Hours ddmm.csv) ddmm would be the date
and month

I keep this folder in a similar filepath to the below

g:\folder1\folder2ddmm\1-borrowed Hours ddmm.csv

I have another spreadsheet that links to this spreadhseet for example
lets say cell A1 on my new book links to cell A1 on the saved csv
file.

i would like to place a date in cell c1 and month d1 in my new book and
the filepath change to the required new csv. I realise that if the path
does not exist then this will cause an error.

I tried using the concatenate function with no joy and im not even sure
if this can be done, possibly using VB im not sure.

Can anyone help?


--
ceemo
------------------------------------------------------------------------
ceemo's Profile: http://www.excelforum.com/member.php...o&userid=10650
View this thread: http://www.excelforum.com/showthread...hreadid=382189