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?
Printable View
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?
i don't really get the question but I usually use this
VB Code:
wbname = "tarif.xls" ChDir "C:\Documents and Settings\All Users\Documents\lascombes\tarifs\" Workbooks.Open (wbname)