Vb2017 using API function to EXCEL binding in his own form, form area has no reaction, Word completely normal operation after binding, office version of 2013, in 2010 before the EXCEL as if the same code can edit, is now a mouse and keyboard form area completely don't respond, open the function button scroll bar is normal, amateur, unable to find a reason, please great god glad,


Code to run without error, the estimate is excel itself question,
Fuzhuwindowstyle=GetWindowLong (fuzhuProcess MainWindowHandle, GWL_STYLE) '//remove the window frame.
SetWindowLong (fuzhuProcess MainWindowHandle GWL_STYLE, fuzhuwindowstyle And Not WS_CAPTION And Not WS_EX_TOOLWINDOW And Not WS_SIZEBOX)
Dim innerWnd1 As IntPtr=fuzhuProcess. MainWindowHandle
SetWindowPos (innerWnd1, IntPtr. Zero, 0, 0, auxiliary CPanel. ClientSize. Width, auxiliary CPanel. ClientSize. Height, SWP_NOZORDER)

CodePudding user response:

Find the ms are not necessarily know where the problem is
Or you can consider using vsto development excel extensions

CodePudding user response:

reference 1st floor stherix response:

this find ms all don't know where the problem is
Or you can consider using vsto development excel extensions

code about nine years ago, was still useful, monitoring and control process, to create excel, recording process, binding to its own form and can facilitate the formatting, edit, insert the contents of the database, simple, practical, and now want to use again, eyes watching function fail, unfortunately, vsto unused, estimates that can't embed themselves in the form? Dsoframer was tried, there are always problems,

CodePudding user response:

Vb can still be operated on the excel, area of mouse and keyboard didn't reflect is form,

CodePudding user response:

May be I operate excel is a problem with the statement, the table lock, I'm sorry, I slowly adjust it, time is too long.

CodePudding user response:

Before written some programs to manipulate the Excel, each Excel in a version will appear at sixes and sevens, then use VBA, is much more stable
The building Lord try VBA

CodePudding user response:

reference 5 floor it_gz_xi reply:

written some programs to operate Excel, before each Excel in a version will appear at sixes and sevens, then use VBA, is much more stable
I try VBA

is indeed, the original program compiled a bit big for me, office a system upgrade to don't willing to adjust, VBA was come from, because Excel database too slow, switch to access, even operating picture, word, cad, so I use vb, I think is not serious, Microsoft Excel wysiwyg do no old version,

CodePudding user response:

Should be to handle without the,

CodePudding user response:

Why do you want to use the API? Can't compatible with infinite,
Use NTKO, use third party controls, simple point,