Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2007
    Posts
    1
    how to Open excel file from MS Excel using VBA

  2. #2
    Join Date
    Jan 2002
    Location
    Bay Area
    Posts
    507
    Here are a couple of ways to do it:

    Workbooks.Open filePath & fileName & ".xls"
    Workbooks.Open "c:\Temp\MyWorkbook.xls"

    Jerry

  3. #3
    Join Date
    Oct 2003
    Posts
    1,091
    Or GetFileOpen works as well.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

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