I'd like to open by vb6 excel, for the subsequent operations (the record import listbox)
But the creatobject (" excel. Application ") automation error always prompt automation error
Excel version is 2013 32-bit
Has been cited in the engineering Microsoft excel 15
Don't know how to solve the
Thank you all for the

CodePudding user response:

Reference library and do not match your current version of excel

CodePudding user response:

Less a letter,,,
Creat e Object

CodePudding user response:

The

reference 1/f, worldy response:

reference library do not match your current version of excel

Excel2013 is excel 15
I refer to is Microsoft excel 15 object library
And file is built using excel 2013. XLSX

CodePudding user response:

refer to the second floor crazy0qwer response:

less,,,
Creat e Object

Sorry this is I just write write wrong
The original file no less

CodePudding user response:

Try this:
The set exc=new excel application

CodePudding user response:

 
Dim Row As Integer 
Dim Excel As Excel. Application 
Dim Worksheet As Worksheet 

The Set of Excel=New Excel. Application 
The Set Workbook=Excel. Workbooks. Add 
Workbook. Activate 
Excel. Visible=True 

The Set Worksheet=Workbook. ActiveSheet 
The Row Row + 1=
Worksheet. Rows. Cells (Row, 1)=Text1. Text