Using differant PC's

allmad · #1 (**permalink**) 04-27-04, 22:44

When I write something in vb it put the link in from were the file is

ie
__________________________________________________ _____________
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"
Sheets("Home W1").Select
End Sub
__________________________________________________ _____________

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

Mark

Smitty · #2 (**permalink**) 04-27-04, 22:51

I use the All Users Profile:

Code:

"C:\Documents and Settings\All Users\Desktop\New Folder\Week One.xls"
'  Sheets("Home W1").Select
'  Edit: No need to select
   Application.Goto Reference:=['Home'!W1]
End Sub

Just make sure that you code it to save there.

Hope that helps,

Smitty

allmad · #3 (**permalink**) 04-28-04, 14:22

Yes that helps thank you

Internet Services

Web Development

Digital Marketing

Consumer Tech