Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    13

    Unanswered: Using differant PC's

    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

  2. #2
    Join Date
    Dec 2003
    Location
    San Diego, CA
    Posts
    153
    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
    Last edited by Smitty; 04-27-04 at 23:53.

  3. #3
    Join Date
    Mar 2004
    Posts
    13

    Thx

    Yes that helps thank you

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •