Click here to Skip to main content
15,891,248 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am using vb2008,windows application forms.

I want use excel as an object.I downloaded PIA services and installed the extracted files o2010pia.but when i register using regsvr32 pathile name i got a message ".dll was loaded, but the DllRegisterServer entry point was not found". i used syswow64.but now i m getting a message when i register windows installer as below

VB
'The Module "c:windowssyswow64o2010pia"failed to load.make sure the binary is stored at the specified path or debug it to check for problems with the binary or dependent dll files.the specified module could not be found' then learnt that service cannot be added in regsvr32,only COM functions can be added.

but when i run the code i am getting an exception in the line FilterXpath = CreateObject("Excel.Application").filterxpath is the excel name.the exception states that 'cannot create Activex component'.so please suggest me what should i do.

i tried using the dll as 'regsvr32 C:\Users\sridevi\Documents\Microsoft.Office.Interop.Excel.dll' but getting a message as 'dll is loaded but entry level dllregisterserver is not found.make sure it is a valid dll'.please i am breaking my head with this problem.waiting for help


i have added the excel 'filterxpath' under resources.
.please advise me
Posted
Updated 29-Oct-12 19:36pm
v2
Comments
Richard MacCutchan 30-Oct-12 5:58am    
Looks like this is a bad DLL, go back to the people who created it and ask for help.

A lot depends on the library itself.

RegSvr32 will only work on COM libraries designed to be dynamically linkable. Those have a special interface that allows RegSvr32 to get the library's meta data. Other types of DLLs, such as .Net assemblies, plug-ins and the like, do not have this interface, so RegSvr32 cannot find its entry point to the meta data. With some libraries, you must register the type library (with an extension of .tlb) and not the DLL.

Your best bet is to get the documentation for the files you want to use, and inquire therein.
 
Share this answer
 
PIA stands for Primary Interop Assembly. That is a .NET wrapper for a COM component. The PIA is managed code, and it forwards the calls to a COM component. The PIA itself cannot be registered, because it is not a COM component.
You use a PIA like any other .Net library. But the COM component must be present (and registered) on the computer, i.e. in your case: Excel must be installed!
 
Share this answer
 
Comments
RaghuBhat 3-Mar-14 2:04am    
I am facing this issue, but I am unable to fix this issue.

I have a WIN 2008 Server R2 Std Edition.

I have a code, which uses AspThumb() class to re-size the images. I tried to register the DLL file and it gives me an error "The module was loaded but the entry-point DllRegisterServer was not found". I am new to .NET and WIN Platform.

Can anyone help me getting this resolved.

Much appreciated for your help.
I am facing the same issue, but not found any solution. please suggest..
 
Share this answer
 
Comments
Richard MacCutchan 4-May-15 6:20am    
Please do not post such questions as Solutions.
AANIL DHAKAD 6-May-15 3:07am    
Sorry Rechard, by mistake... Sorry again

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900