I generate reports using vb to call excel template, the splash screen, does not appear excel interfa-CodePudding

I am using vb under the xp call office2003 generator, but the reference is 13th object library, now want to use under Windows 7, Windows 7 has an and WPS, but the runtime, call excel is a splash screen, did not appear excel interface, how to do

CodePudding user response:

14 is MS office 2010, office and the office is 12, 2007, 2003 should be office 10,

I really don't know you is how to reference...

And you install the WPS and MS Office at the same time, it is between the two COM type library if there is a conflict,
If you have installed WPS, this sounds like the "Excel object" jinshan et object, no longer call to MS Excel interface,
Suggest you or "clean environment" to say again first,

Anyway, I am never "static reference" way,
Are using CreateObject () to create Excel. Application object, didn't go to tube "version",
Seems haven't had any questions,

CodePudding user response:

Chen8013
I have two questions, first, whether reference which version of office, in the use of environment will use this version of the office, not in other versions, second, if installed WPS and office, whether to delete the WPS environment can be restored to normal office calls, thank you

CodePudding user response:

Your top one

CodePudding user response:

Ha ha, I started programming also encounter this problem is the whole for a long time,,
Appplication. Visiale=true;;;;;

CodePudding user response:

refer to the second floor blue23 response:

chen8013
I have two questions, first, whether reference which version of office, in the use of environment will use this version of the office, not in other versions, second, if installed WPS and office, whether to delete the WPS environment can be restored to normal office calls, thank you

The first: under the "development environment", seems to be "fixed", which version of your project reference library,
"In a computer" open project, as if also requires is the same version of the library,
(remember the first time, as if someone had asked in the BBS, because the reference version of the "library" is different, cause project can not run)
But the compiled exe didn't seem to this requirement: I have got a simple program to try once,
Windows 7/64 a/an, WinXP/Office2003,
Operation is to create ExcelApp object, showing the Excel window, to create a new workbook, closed, quit,
The two systems, their corresponding library reference, and then compiled into exe, run into another system, all is normal,

The second: this seems to be no, contact before jinshan WPS, it won't wipe off the bottom after unloading, many didn't clean up the registration information,
Anyway, ok, you tried to say again, it wasn't my development of the software, which will have what problem I told?
First uninstall the WPS, if there is a problem, seek tool software to clear up the registry, the MS Office reset again,
(it is better to put the two, have to clean up the registry, and then reinstall Office)
Anyway, you need to ensure no problem in MS Office of each environment, to consider the matter of "compatible with jinshan WPS,
Your program is not "normal" operation, is to find the problem of "compatibility", you don't feel like going in the wrong direction?

Another point:
What are you doing in XP installation is under 2003, to quote 2010 libraries (where I feel strange: 2010 libraries for you reference?) !!!!!!!!!
Own level is not up to level of "at", don't go to the "game"!
Norm to do, is king...

CodePudding user response:

reference 5 floor Chen8013 reply:

Quote: refer to the second floor blue23 response:

Chen8013
I have two questions, first, whether reference which version of office, in the use of environment will use this version of the office, not in other versions, second, if installed WPS and office, whether to delete the WPS environment can be restored to normal office calls, thank you

The first: under the "development environment", seems to be "fixed", which version of your project reference library,
"In a computer" open project, as if also requires is the same version of the library,
(remember the first time, as if someone had asked in the BBS, because the reference version of the "library" is different, cause project can not run)
But the compiled exe didn't seem to this requirement: I have got a simple program to try once,
Windows 7/64 a/an, WinXP/Office2003,
Operation is to create ExcelApp object, showing the Excel window, to create a new workbook, closed, quit,
The two systems, their corresponding library reference, and then compiled into exe, run into another system, all is normal,

The second: this seems to be no, contact before jinshan WPS, it won't wipe off the bottom after unloading, many didn't clean up the registration information,
Anyway, ok, you tried to say again, it wasn't my development of the software, which will have what problem I told?
First uninstall the WPS, if there is a problem, seek tool software to clear up the registry, the MS Office reset again,
(it is better to put the two, have to clean up the registry, and then reinstall Office)
Anyway, you need to ensure no problem in MS Office of each environment, to consider the matter of "compatible with jinshan WPS,
Your program is not "normal" operation, is to find the problem of "compatibility", you don't feel like going in the wrong direction?

Another point:
What are you doing in XP installation is under 2003, to quote 2010 libraries (where I feel strange: 2010 libraries for you reference?) !!!!!!!!!
Own level is not up to level of "at", don't go to the "game"!
Norm to do, is king...

Static reference is fixed, (dim xx as new... ), when the program compiled to bind class ID in, change the machine, change the office version not
Dynamic reference is variable, is createobject, belong to the late binding, is a program run time binding objects to
I was appplication visiale=true