Public Sub openExcel () 
'set properties dialog box that is used to specify the EXCEL file 
CommonDialog1. Filter="Excel file *. XLS" 
CommonDialog1. Action=1 
If CommonDialog1. FileName<> "" Then 
Expath=CommonDialog1. FileName 
'open the dialog box to specify the EXCEL workbook 
Workbooks. Open FileName:=expath, this error, prompt error loading DLL 
Oldbook. Close 
The Else 
End the If 
End Sub 

CodePudding user response:

Your computer is installed office

Vb EXCEL operation need to have the office of the relevant material

CodePudding user response:

reference 1st floor arthaslsq response:

your computer installed office?

Vb EXCEL operation requires the office of the relevant material

Office2003, 2007 have installed

CodePudding user response:

Use oldxls. Workbooks. Open FileName:=expath

CodePudding user response:

Whether the new excel related classes
Decomposition problem, need not commandbar directly in the app. The path below to create a Exel look smooth operation