Results 1 to 2 of 2

Thread: Open an Excel file

  1. Sep 6th, 2004, 03:18 PM #1
    Norah
    Norah is offline

    Thread Starter
    Member
    Join Date
    Mar 2004
    Location
    Argentina, Buenos Aires
    Posts
    38

    Open an Excel file

    I want to open an Excel file from VB. I open Complements,then Visual administrator of data, then File, then Open existing data basis, then Excel. I get error 3170: DAO.Workspace.ISAM instalable not found. Can anyone help me?
    Reply With Quote Reply With Quote
  2. Sep 9th, 2004, 08:47 AM #2
    writelearner
    writelearner is offline
    Lively Member
    Join Date
    Jun 2003
    Location
    france
    Posts
    71
    i don't really get the question but I usually use this

    VB Code:
    1. wbname = "tarif.xls"

    2.         ChDir "C:\Documents and Settings\All Users\Documents\lascombes\tarifs\"

    3.         Workbooks.Open (wbname)
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width