Home > Software engineering >  How to import vb. XLS file to OLE1 excel, and read the corresponding content of cells
How to import vb. XLS file to OLE1 excel, and read the corresponding content of cells

Time:09-29

How to import vb. XLS file to OLE1 excel, and let him show out

CodePudding user response:

OLE this thing is heavy, is not convenient to operate, it is better to directly call the excel object.

CodePudding user response:

Direct call excel

Can't directly on the VB editor

Why I searched for a long time, the whole day couldn't search the direct method, it is too simple or not easy to get,

My idea is very simple, it is the user to select an.xls files, point opened, in the form of embedded OLE is shown in the excel spreadsheet content,

In this way, the user can add,

CodePudding user response:

Mama of, is a code that can be make didn't search, I search for a day,
 
OLE1. CreateLink "C: \ ABC. XLS"

CodePudding user response:

reference hanlong96 reply: 3/f
mama of, is a code that can make didn't search, I search for a day,


It's telling, because it's not much.

CodePudding user response:

Now I done, I think than calling EXCEL much better,

Just along with my original idea, and meet the needs of me

CodePudding user response:

Make a mark, and learning
  • Related