Results 1 to 2 of 2

Thread: Open file in Excel

  1. #1

    Thread Starter
    New Member
    Join Date
    Jan 2000
    Location
    Phoenix, AZ. USA
    Posts
    1

    Post

    When opening a file in Excel I use this
    Workbooks.open.filename:=_ "C:\dir\dir\free.xls". DOes anyone know how to have this name look at an actual cell address on a common page???

  2. #2
    Conquistador
    Join Date
    Dec 1999
    Location
    Australia
    Posts
    4,527

    Post

    in vba it's:
    Code:
    msgbox range("A1").value

    ------------------
    david
    Teenage Programmer


Posting Permissions

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



Click Here to Expand Forum to Full Width