don't ask what the cause of the DLL file not registered, because on this computer, equipped with k3ERP, and can be normal use, here are just call K3 components,
Before loading is office2010, not out of the error, can the normal execution of VBA scripts, now is to update the 64 office2013 out this problem
The relevant code

 
Public Conn As New ADODB. Connection 
Public K3Login As Object 
Public strFileName, strBillType As String 

'first call the K3 landing components to do the operation of the K3, connect to the database string, complete the connection to the database 
'and then open to import EXCEL table 
'according to open the table into the corresponding data (customer/supplier, sales invoice/purchase invitation content, sales list/purchasing list) 
'finally close the connection 


Sub K3ErpLogin () 
Dim strConn As String 
The Set K3Login=CreateObject (" K3Login. ClsLogin ") 
If Not K3Login. CheckLogin Then 
MsgBox "connection is not successful" 
The Set K3Login=Nothing 
End 
End the If 
StrConn=Split (Split (K3Login PropsString, "} ") (0), "{") (1) 
The Set K3Login=Nothing 
Conn. 

Also is this problem, a 64 - bit Excel, 32-bit DLL cannot be used, no solution,

CodePudding user response:

Don't be A language code is modified to B language code busywork,
Also don't use A language code to directly invoke B language code base, this complicated things so easy to get wrong,
Just make A, B language code of input and output is redirected to A text file, or modify A, B language code let it through text file input and output,
Can easily make A, B coordination between the two languages,
For example:
A will request data written to A file a.t xt, renamed after finish aa. TXT
B find aa. TXT, read its contents, call the corresponding function, and writes the results file b.t xt, after finish delete aa. TXT, then b.t xt renamed bb. TXT
Found A bb. TXT, read the content, after finish delete bb. TXT
Above can be replaced by any kind of A language or development environment, B can be replaced by any kind of with the development of A different language or development environment,
Unless A or B does not support to determine whether A file exists, file read and write and file name,
But who can name does not support to determine whether a file exists, file read and write and file name for the development of language or development environment?
Can put the temporary files on the RamDisk efficiency decrease wear disk,
Data structure is very complex, a text file format problems refer to a json or XML

The communication methods between the temporary text file sharing this process there are plenty of advantages, compared to other method only listed below I can think of now:
Loose coupling between process,
Can be on the same machine, process, also can cross machine, across the operating system, hardware platform, and even multinational,
, convenient debugging, and monitoring, only let the third party or artificial view the temporary text files,
Switch, convenient online service, need to delete or create the temporary text files,
, is convenient to realize distributed and load balancing,
Services to provide convenient, queue, queue is full and it is almost impossible to happen (unless the hard disk space full)
DE...

"Across different languages, machine, across the operating system, hardware platform, multinational, cross *. *" misery,
Back is "the use of Shared a plain text file information communication" of the shore!

Please make your own will be more than A language replaced by Excel, 64 B language replaced with 32-bit DLL,

CodePudding user response:

I also met the same problem when calling WMP, manual insert activex in excel in advance, and then to the insertion of operated object can use in advance, this is a kind of compromise, there must be a better solution,