473,395 Members | 1,401 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

Project works on dev machine only

Stumped here.

When I access a ComClass enabled library in Excel on the development
machine, it works fine. When I install the app on another machine, and try
to access it, I get an error:

"File or assembly name DotNetApp, or one of its dependencies, was not
found."

I have a Class Library vb.net solution. It uses ComClass method to make it
accessible from a COM application (Excel). The "register for COM interop" is
checked. It also uses a 3rd party control. After I install the app, I can
see the 3rd party DLLs as well as the DotNetApp.DLL and DotNetApp.TLB in the
destination directory.

An Excel macro instantiates the class and shows a form. When I run this from
the development machine, it works fine.

When I install it onto another machine and try to instantiate the class, it
errors.

Dim c As DotNetApp.ClassName
Set c= New DotNetApp.ClassName ' ERROR
The 2nd line produces an error:

"File or assembly name DotNetApp, or one of its dependencies, was not
found."

What am I not doing, or doing wrong?
--
Tim Zych
SF, CA
Nov 15 '07 #1
8 1242
On Nov 15, 1:36 pm, "Tim Zych" <tzych@NOSp@mE@RTHLINKDOTNETwrote:
Stumped here.

When I access a ComClass enabled library in Excel on the development
machine, it works fine. When I install the app on another machine, and try
to access it, I get an error:

"File or assembly name DotNetApp, or one of its dependencies, was not
found."

I have a Class Library vb.net solution. It uses ComClass method to make it
accessible from a COM application (Excel). The "register for COM interop" is
checked. It also uses a 3rd party control. After I install the app, I can
see the 3rd party DLLs as well as the DotNetApp.DLL and DotNetApp.TLB in the
destination directory.

An Excel macro instantiates the class and shows a form. When I run this from
the development machine, it works fine.

When I install it onto another machine and try to instantiate the class, it
errors.

Dim c As DotNetApp.ClassName
Set c= New DotNetApp.ClassName ' ERROR
The 2nd line produces an error:

"File or assembly name DotNetApp, or one of its dependencies, was not
found."

What am I not doing, or doing wrong?

--
Tim Zych
SF, CA
You do have Excel on the other machine right?

Thanks,

Seth Rowe
Nov 15 '07 #2
Yes, the other machines have Excel (I have tried this on 3 diff
machines..same problem) I can see the reference in Excel's VBE, and can Dim
a variable to the vb.net class. I just can proceed with the 2nd line.

As far as I can tell, the environments are similar. Same versions of Excel,
same versions of the Framework.

--
Tim Zych
SF, CA

"rowe_newsgroups" <ro********@yahoo.comwrote in message
news:da**********************************@e1g2000h sh.googlegroups.com...
On Nov 15, 1:36 pm, "Tim Zych" <tzych@NOSp@mE@RTHLINKDOTNETwrote:
>Stumped here.

When I access a ComClass enabled library in Excel on the development
machine, it works fine. When I install the app on another machine, and
try
to access it, I get an error:

"File or assembly name DotNetApp, or one of its dependencies, was not
found."

I have a Class Library vb.net solution. It uses ComClass method to make
it
accessible from a COM application (Excel). The "register for COM interop"
is
checked. It also uses a 3rd party control. After I install the app, I can
see the 3rd party DLLs as well as the DotNetApp.DLL and DotNetApp.TLB in
the
destination directory.

An Excel macro instantiates the class and shows a form. When I run this
from
the development machine, it works fine.

When I install it onto another machine and try to instantiate the class,
it
errors.

Dim c As DotNetApp.ClassName
Set c= New DotNetApp.ClassName ' ERROR
The 2nd line produces an error:

"File or assembly name DotNetApp, or one of its dependencies, was not
found."

What am I not doing, or doing wrong?

--
Tim Zych
SF, CA

You do have Excel on the other machine right?

Thanks,

Seth Rowe

Nov 15 '07 #3


Did you register your comclass with Regasm or did you used a installer
module with the com flag on to install your custom com class on the target
machine ?
cause the IDE will do this automaticly for you

HTH

Michel

"Tim Zych" <tzych@NOSp@mE@RTHLINKDOTNETschreef in bericht
news:ex*************@TK2MSFTNGP06.phx.gbl...
Stumped here.

When I access a ComClass enabled library in Excel on the development
machine, it works fine. When I install the app on another machine, and try
to access it, I get an error:

"File or assembly name DotNetApp, or one of its dependencies, was not
found."

I have a Class Library vb.net solution. It uses ComClass method to make it
accessible from a COM application (Excel). The "register for COM interop"
is checked. It also uses a 3rd party control. After I install the app, I
can see the 3rd party DLLs as well as the DotNetApp.DLL and DotNetApp.TLB
in the destination directory.

An Excel macro instantiates the class and shows a form. When I run this
from the development machine, it works fine.

When I install it onto another machine and try to instantiate the class,
it errors.

Dim c As DotNetApp.ClassName
Set c= New DotNetApp.ClassName ' ERROR
The 2nd line produces an error:

"File or assembly name DotNetApp, or one of its dependencies, was not
found."

What am I not doing, or doing wrong?
--
Tim Zych
SF, CA

Nov 15 '07 #4
I checked "Register for COM Interop" in the project's Compile properties.
--
Tim Zych
SF, CA

"Michel Posseth [MCP]" <MS**@posseth.comwrote in message
news:%2****************@TK2MSFTNGP06.phx.gbl...
>

Did you register your comclass with Regasm or did you used a installer
module with the com flag on to install your custom com class on the target
machine ?
cause the IDE will do this automaticly for you

HTH

Michel

"Tim Zych" <tzych@NOSp@mE@RTHLINKDOTNETschreef in bericht
news:ex*************@TK2MSFTNGP06.phx.gbl...
>Stumped here.

When I access a ComClass enabled library in Excel on the development
machine, it works fine. When I install the app on another machine, and
try to access it, I get an error:

"File or assembly name DotNetApp, or one of its dependencies, was not
found."

I have a Class Library vb.net solution. It uses ComClass method to make
it accessible from a COM application (Excel). The "register for COM
interop" is checked. It also uses a 3rd party control. After I install
the app, I can see the 3rd party DLLs as well as the DotNetApp.DLL and
DotNetApp.TLB in the destination directory.

An Excel macro instantiates the class and shows a form. When I run this
from the development machine, it works fine.

When I install it onto another machine and try to instantiate the class,
it errors.

Dim c As DotNetApp.ClassName
Set c= New DotNetApp.ClassName ' ERROR
The 2nd line produces an error:

"File or assembly name DotNetApp, or one of its dependencies, was not
found."

What am I not doing, or doing wrong?
--
Tim Zych
SF, CA


Nov 15 '07 #5
That really doesn't answer the question. When you copy to the other machine,
you need to run a command in a dos window (regsvr32 mycode.dll) or use an
installer system which does this. Did you do either of these steps?

"Tim Zych" wrote:
I checked "Register for COM Interop" in the project's Compile properties.
--
Tim Zych
SF, CA

"Michel Posseth [MCP]" <MS**@posseth.comwrote in message
news:%2****************@TK2MSFTNGP06.phx.gbl...


Did you register your comclass with Regasm or did you used a installer
module with the com flag on to install your custom com class on the target
machine ?
cause the IDE will do this automaticly for you

HTH

Michel

"Tim Zych" <tzych@NOSp@mE@RTHLINKDOTNETschreef in bericht
news:ex*************@TK2MSFTNGP06.phx.gbl...
Stumped here.

When I access a ComClass enabled library in Excel on the development
machine, it works fine. When I install the app on another machine, and
try to access it, I get an error:

"File or assembly name DotNetApp, or one of its dependencies, was not
found."

I have a Class Library vb.net solution. It uses ComClass method to make
it accessible from a COM application (Excel). The "register for COM
interop" is checked. It also uses a 3rd party control. After I install
the app, I can see the 3rd party DLLs as well as the DotNetApp.DLL and
DotNetApp.TLB in the destination directory.

An Excel macro instantiates the class and shows a form. When I run this
from the development machine, it works fine.

When I install it onto another machine and try to instantiate the class,
it errors.

Dim c As DotNetApp.ClassName
Set c= New DotNetApp.ClassName ' ERROR
The 2nd line produces an error:

"File or assembly name DotNetApp, or one of its dependencies, was not
found."

What am I not doing, or doing wrong?
--
Tim Zych
SF, CA


Nov 15 '07 #6
Sorry, that should have said regasm, not regsvr32...

"Family Tree Mike" wrote:
That really doesn't answer the question. When you copy to the other machine,
you need to run a command in a dos window (regsvr32 mycode.dll) or use an
installer system which does this. Did you do either of these steps?

"Tim Zych" wrote:
I checked "Register for COM Interop" in the project's Compile properties.
--
Tim Zych
SF, CA

"Michel Posseth [MCP]" <MS**@posseth.comwrote in message
news:%2****************@TK2MSFTNGP06.phx.gbl...
>
>
Did you register your comclass with Regasm or did you used a installer
module with the com flag on to install your custom com class on the target
machine ?
cause the IDE will do this automaticly for you
>
HTH
>
Michel
>
"Tim Zych" <tzych@NOSp@mE@RTHLINKDOTNETschreef in bericht
news:ex*************@TK2MSFTNGP06.phx.gbl...
>Stumped here.
>>
>When I access a ComClass enabled library in Excel on the development
>machine, it works fine. When I install the app on another machine, and
>try to access it, I get an error:
>>
>"File or assembly name DotNetApp, or one of its dependencies, was not
>found."
>>
>I have a Class Library vb.net solution. It uses ComClass method to make
>it accessible from a COM application (Excel). The "register for COM
>interop" is checked. It also uses a 3rd party control. After I install
>the app, I can see the 3rd party DLLs as well as the DotNetApp.DLL and
>DotNetApp.TLB in the destination directory.
>>
>An Excel macro instantiates the class and shows a form. When I run this
>from the development machine, it works fine.
>>
>When I install it onto another machine and try to instantiate the class,
>it errors.
>>
>Dim c As DotNetApp.ClassName
>Set c= New DotNetApp.ClassName ' ERROR
>The 2nd line produces an error:
>>
>"File or assembly name DotNetApp, or one of its dependencies, was not
>found."
>>
>What am I not doing, or doing wrong?
>>
>>
>--
>Tim Zych
>SF, CA
>>
>
>
Nov 15 '07 #7
I used a setup program, which created an MSI file.
--
Tim Zych
SF, CA

"Family Tree Mike" <Fa************@discussions.microsoft.comwrote in
message news:DF**********************************@microsof t.com...
That really doesn't answer the question. When you copy to the other
machine,
you need to run a command in a dos window (regsvr32 mycode.dll) or use an
installer system which does this. Did you do either of these steps?

"Tim Zych" wrote:
>I checked "Register for COM Interop" in the project's Compile properties.
--
Tim Zych
SF, CA

"Michel Posseth [MCP]" <MS**@posseth.comwrote in message
news:%2****************@TK2MSFTNGP06.phx.gbl...
>

Did you register your comclass with Regasm or did you used a installer
module with the com flag on to install your custom com class on the
target
machine ?
cause the IDE will do this automaticly for you

HTH

Michel

"Tim Zych" <tzych@NOSp@mE@RTHLINKDOTNETschreef in bericht
news:ex*************@TK2MSFTNGP06.phx.gbl...
Stumped here.

When I access a ComClass enabled library in Excel on the development
machine, it works fine. When I install the app on another machine, and
try to access it, I get an error:

"File or assembly name DotNetApp, or one of its dependencies, was not
found."

I have a Class Library vb.net solution. It uses ComClass method to
make
it accessible from a COM application (Excel). The "register for COM
interop" is checked. It also uses a 3rd party control. After I install
the app, I can see the 3rd party DLLs as well as the DotNetApp.DLL and
DotNetApp.TLB in the destination directory.

An Excel macro instantiates the class and shows a form. When I run
this
from the development machine, it works fine.

When I install it onto another machine and try to instantiate the
class,
it errors.

Dim c As DotNetApp.ClassName
Set c= New DotNetApp.ClassName ' ERROR
The 2nd line produces an error:

"File or assembly name DotNetApp, or one of its dependencies, was not
found."

What am I not doing, or doing wrong?
--
Tim Zych
SF, CA



Nov 16 '07 #8

well it might be an idea to try it while manually registring the COM class
with Regasm.exe
http://msdn2.microsoft.com/en-us/lib...w6(VS.71).aspx

Maybe it shows an error that it can`t register on the target systems for
whatever reasson

also note the following :

A COM creatable class must have a public sub new with no parameters even if
you do not need initializers in that case provide an empty method

Public sub New()
'--- For COM
End sub

Michel

"Tim Zych" <tzych@NOSp@mE@RTHLINKDOTNETschreef in bericht
news:Or****************@TK2MSFTNGP04.phx.gbl...
>I used a setup program, which created an MSI file.
--
Tim Zych
SF, CA

"Family Tree Mike" <Fa************@discussions.microsoft.comwrote in
message news:DF**********************************@microsof t.com...
>That really doesn't answer the question. When you copy to the other
machine,
you need to run a command in a dos window (regsvr32 mycode.dll) or use an
installer system which does this. Did you do either of these steps?

"Tim Zych" wrote:
>>I checked "Register for COM Interop" in the project's Compile
properties.
--
Tim Zych
SF, CA

"Michel Posseth [MCP]" <MS**@posseth.comwrote in message
news:%2****************@TK2MSFTNGP06.phx.gbl.. .
Did you register your comclass with Regasm or did you used a installer
module with the com flag on to install your custom com class on the
target
machine ?
cause the IDE will do this automaticly for you

HTH

Michel

"Tim Zych" <tzych@NOSp@mE@RTHLINKDOTNETschreef in bericht
news:ex*************@TK2MSFTNGP06.phx.gbl...
Stumped here.

When I access a ComClass enabled library in Excel on the development
machine, it works fine. When I install the app on another machine,
and
try to access it, I get an error:

"File or assembly name DotNetApp, or one of its dependencies, was not
found."

I have a Class Library vb.net solution. It uses ComClass method to
make
it accessible from a COM application (Excel). The "register for COM
interop" is checked. It also uses a 3rd party control. After I
install
the app, I can see the 3rd party DLLs as well as the DotNetApp.DLL
and
DotNetApp.TLB in the destination directory.

An Excel macro instantiates the class and shows a form. When I run
this
from the development machine, it works fine.

When I install it onto another machine and try to instantiate the
class,
it errors.

Dim c As DotNetApp.ClassName
Set c= New DotNetApp.ClassName ' ERROR
The 2nd line produces an error:

"File or assembly name DotNetApp, or one of its dependencies, was not
found."

What am I not doing, or doing wrong?
--
Tim Zych
SF, CA



Nov 16 '07 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Kent P. Iler | last post by:
Hi, I've been using Visual Studio (not .Net) for many years (6+). I'm just now switching to VS.NET 2003. I am building my first project. In the past, I tend to work on my local machine...
18
by: JKop | last post by:
Here's what I know so far: You have a C++ project. You have source files in it. When you go to compile it, first thing the preprocessor sticks the header files into each source file. So now...
3
by: David N | last post by:
I got a solution that contains about 30 projects, three of which cannot be open. When I open the project, I always receive the error message "Unable to get the project file from the Web Server" ...
2
by: Ken Stealth | last post by:
I spend more time tweaking this stupid computer than I do programming!!!! Although I love working in .NET when I finally get the chance - I absolutley hate its fragile nature. What a mess.... ...
1
by: Vladimír Kolesnik | last post by:
Hi, there we need help concerning setting project under source control. We want to have a project on the server, and developers in the local network working on this project. We decided to use...
3
by: Johnny | last post by:
Hi, I have created an ASP.NET application (let's call it FooBar) with VS.NET on my local machine, residing in http://localhost/FooBar. Deploying it to another folder on my machine works well...
7
by: Mantorok | last post by:
Hi all We have an ASP.Net project (and the Solution) under source-control. Here is the example - I create the Solution, I create an ASP.Net project and then check it all in to source control,...
2
by: fig000 | last post by:
Hi everyone, I recently wrote a vb.net app which includes some crystal reports. The user has very little money in their budget and have been without a working application for quite a while. This...
1
by: Cramer | last post by:
I'm running XP Pro/SP2 + patches and updates, with Visual Studio Professional 2008 (and no prior installation of Visual Studio ever installed). When attempting to open an ASP.NET Web application...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.