Because want to EXCEL embedded in VB form window, so the first thing that comes to OLE controls, but OLE is a rectangle, when open the size can't control,
Me for a few days, can't control the size, interface changes, finally gave up
Using mdiform is used, because of a little complicate
So want to directly add an excel object "parts" to the whole, the result is to control the size, the interface be good-looking, but each time the loading window, all need to double click to open,
. When you use the OLE and ole1 doverb to activate, now is to control the size, no sheet1. Doverb, did not move the verb, wiping the activate also not line, no winter verb, how make, I just want to make a bit like the grid form controls, sheet1 without db_click events
Don't want to use the API, it was the API is completely blind
The load form, don't need to double-click directly EXCEL object editor status, ask everybody to help, blocked a few days, there is no choice

CodePudding user response:

Put out the parade, who give directions

CodePudding user response:

Say what? OLE can adjust the size of
1) design pattern
Is just on the edit mode (which can be directly set Excel content), cut the focus out editor (such as the window area) is over, can adjust the OLE control size,
2) running mode
Direct code resize

 Private Sub Form_Resize () 
If Me. WindowState=vbMinimized Then Exit Sub 
On the Error Resume Next 
OLE1. Move 0, 0, ScaleWidth, ScaleHeight 
On Error GoTo 0 
End Sub 

CodePudding user response:

Accidentally drag, or abnormal interface is easy to size with ole box size uniform, there are other possible methods

CodePudding user response:

Since the design mode is not assured, in the run mode code, is used to adjust the size,

CodePudding user response:

How the whole running mode, ole, but the excel can't

CodePudding user response:

Don't understand! People speaking!

CodePudding user response:

Microsoft has a open source OCX, direct comparisons with good,
But if only support 03 previous versions,

CodePudding user response:

It is recommended to use Flexcell controls

CodePudding user response:

refer to the original poster kioskboy response:

because want to EXCEL embedded in VB form window, so the first thing that comes to OLE controls, but OLE is a rectangle, when open the size can't control,
Me for a few days, can't control the size, interface changes, finally gave up
Using mdiform is used, because of a little complicate
So want to directly add an excel object "parts" to the whole, the result is to control the size, the interface be good-looking, but each time the loading window, all need to double click to open,
. When you use the OLE and ole1 doverb to activate, now is to control the size, no sheet1. Doverb, did not move the verb, wiping the activate also not line, no winter verb, how make, I just want to make a bit like the grid form controls, sheet1 without db_click events
Don't want to use the API, it was the API is completely blind
The load form, don't need to double-click directly EXCEL object editor status, ask everybody to help, blocked a few days, there is no choice

Give it up,,, no solution, ole links are not sure, I know what you want effect and achieve the purpose of the
Like I want to use the ole show only the word document, I edit the word in the background, not solve,,,,
But my train of thought is to put the doc or excel save a web page, use the web controls, according to the load change web page source file, and then put into office format, it can maximum limit to keep office software display and style of the

refer to 7th floor vansoft response:

Microsoft has a open source OCX, directly for the use of good,
But if only support 03 previous versions,

Please,,,

CodePudding user response:

Why not direct call EXCEL object?
According to the general way of reference, open, and then set the Application, visible=true can see

CodePudding user response:

Fixed size, form, don't let the user drag
Ole to keep size have to deal with the form of the resize time
This is very troublesome

CodePudding user response:

The

references to the tenth floor WallesCai response:

why not direct call EXCEL object?
According to the general way of reference, open, and then set the Application, visible=true will be can see

This effect is not very good
Frequent switch window procedure not good-looking

CodePudding user response:

The

refer to 12 floor aspower_ reply:

Quote: reference to the tenth floor WallesCai response:

Why not direct call EXCEL object?
According to the general way of reference, open, and then set the Application, visible=true will be can see

This effect is not very good
Frequent switch window procedure not good-looking

Try a new desktop CreateDesktop, run to Excel in this invisible desktop,

CodePudding user response:

I just say a mouth
Most people estimate no dealing with a similar demand

The open source Ocx called Microsoft DSOFramer
Really like shit bad to use, good with no
Many questions.

Really want to have a good treatment, can use other third-party controls
I used Aspose Npoi good
But not under vb use in c #

If you just want to show other word, the best way is to convert images, this Aspose can make it more perfect.

CodePudding user response:

Just want to show the word, word provide EnhMetaFileBits interface
Using SetEnhMetaFileBits to an in-memory object
On page 1. According to the export
ActiveDocument. Windows (1). Panes (1). Pages (1) EnhMetaFileBits
2. If you don't header, footer
Range object on the next page have EnhMetaFileBits interface directly