Consulting

Results 1 to 4 of 4

Thread: workbook full path

  1. #1
    VBAX Mentor
    Joined
    Jun 2005
    Posts
    374
    Location

    workbook full path

    hello
    i want to attach a macro to a button for a workbook that has all my macros in it. i want it to open the workbook.


    [VBA]
    Workbooks.Open [C:\Documents and Settings\user1\My Documents\excelove.xls]
    [/VBA]

    what is wrong?
    thanks
    moshe

  2. #2
    VBAX Contributor moa's Avatar
    Joined
    Nov 2006
    Posts
    177
    Location
    [VBA]Workbooks.Open("C:\Documents And Settings\user1\My Documents\excelove.xls")[/VBA]

    should work.
    Glen

  3. #3
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    [vba]

    Workbooks.Open Filename:="C:\Documents And Settings\user1\My Documents\excelove.xls"
    [/vba]

  4. #4
    VBAX Contributor moa's Avatar
    Joined
    Nov 2006
    Posts
    177
    Location
    What's the difference?
    Glen

Posting Permissions

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