Macro Help - Referencing cell

[Sunvisor]

I have names of sheets and paths in my macro but I'd like to use the active workbook cell reference instead so users can change it to their path without going into the code...

path = "C:\Documents and Settings\M08040\My Documents\Test1"

This would be in sheet1 cell I7

and then later on in the code it says

Windows("MRCollection.xls").Activate

and this would be in sheet1 cell i9

Thanks for your help!