Results 1 to 7 of 7

Search and open feature

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-06-2006
    Posts
    108

    Search and open feature

    The pictures speak for themselves:

    \1

    \1

    I already tried to fix this using the following macro but no success

    Sub OpenWorkbook()
    Dim s1 as String, bk as Workbook, bk1 as Workbook
    s1 = "C:\Documents and Settings\" & _
    "fackt0\Desktop\Shipments\"
    
    set bk = activeWorkbook
    if dir(s1 & Range("C3").Text & ".xls") <> "" then
    set bk1 = Workbooks.Open(s1 & Range("J5").Text & ".xls")
    bk.Activate
    else
    msgbox "workbook not found"
    End if
    End sub
    Anyone with an idea what might be wrong?
    Last edited by TomBP; 07-07-2006 at 04:59 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1