Hi Everyone,

Is it possible to search for a file and open it even if the path where the folder is located changes.Like for example with the sample code below the "C:\Users\desmondm\Desktop" might be different.

Set del = Workbooks.Open("C:\Users\desmondm\Desktop\Group Accounts 2013-2014\March 2013\Accpac Reports\Academy-xpert for Paracon_FR.001.xls")

Regards
Desmond