I will apologise in advance, if there is already an existing thread answering my question.
I currently have a excel based 'system' that is basically consist of different workbooks. To navigate from one workbook to another I have written the macro:
Workbooks.Open Filename:= _
"C:\...\workbook.xlsm" _
, UpdateLinks:=3
Workbooks("original workbook").Close
This was fine until I noticed a problem. The problem is that the macro code I wrote is built upon the file directory for my computer, however as soon as I bring this system to my school, the file directory becomes invalid. Therefore I am hoping someone can provide me with an easy solution (as you can see I'm not very good with Excel) -.-'.
Thank you in advance
Bookmarks