When I write something in vb it put the link in from were the file is
Private Sub CommandButton1_Click()
ChDir "C:\Documents and Settings\Mad1\Desktop\New Folder"
Workbooks.Open Filename:= _
"C:\Documents and Settings\Mad1\Desktop\New Folder\Week One.xls"
how can I put this onto another PC so it doesnt look for my PC, it just looks in the folder were the files are