Deployment Help

[Vinay]

Hi,

I am using Excel in my VB.Net project. While deploying my
application on a separate machine, I am getting the
following error:

File or Assembly name Interop.Excel or one of its
dependencies was not found.

I do find Interop.Excel.dll is existing on the target
machine.
On Google - I was pointed out to the following URL, but I
am not able to comprehend what I am supposed to do.

http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/dnoxpta/html/odc_piaissues.asp

Please help.

Regards

Vinay

[Ken Tucker [MVP]]

Hi,

I am not sure if this helps but interop.excel.dll must be in the
same folder as your app.

Ken
----------------------
"Vinay" <cu****@cursor.com> wrote in message
news:09****************************@phx.gbl...

Hi,

I am using Excel in my VB.Net project. While deploying my
application on a separate machine, I am getting the
following error:

File or Assembly name Interop.Excel or one of its
dependencies was not found.

I do find Interop.Excel.dll is existing on the target
machine.
On Google - I was pointed out to the following URL, but I
am not able to comprehend what I am supposed to do.

http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/dnoxpta/html/odc_piaissues.asp

Please help.

Regards

Vinay

[Vinay]

Hi Ken,

Thanks for your reply.

I have checked and found interop.excel.dll is existing in
the Application folder.

I have found one more thing. If I am compiling the
project on my machine under VB.Net environment it is
working; but if I am deploying it on my machine (as it
would be done on other machine using *.msi file), it is
not working.

Regards

Vinay

-----Original Message-----
Hi,

I am not sure if this helps but interop.excel.dll must be in thesame folder as your app.

Ken
----------------------
"Vinay" <cu****@cursor.com> wrote in message
news:09****************************@phx.gbl...

Hi,

I am using Excel in my VB.Net project. While deploying my application on a separate machine, I am getting the
following error:

File or Assembly name Interop.Excel or one of its
dependencies was not found.

I do find Interop.Excel.dll is existing on the target
machine.
On Google - I was pointed out to the following URL, but I am not able to comprehend what I am supposed to do.

http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/dnoxpta/html/odc_piaissues.asp

Please help.

Regards

Vinay

.

[Felix Wang]

Hi Vinary,

Thanks for posting.

It seems that some dependencies of the "Interop.Excel.dll" is not found on
your target machine. Do we have Excel properly installed and COM components
properly registered on it?

To find out what is missing, we can make use of 2 utilities named FileMon
and RegMon:

The use of RegMon:

1. Download RegMon from http://www.sysinternals.com/files/ntregmon.zip

2. Extract the file to a temp folder. Close all other unnecessary programs.

3. Start RegMon. The utility is used to capture registry related
activities. Press CTRL + E to pause the capture. Then press CTRL + X to
clean the log. Press CTRL + L to set the filter. We replace the "*" with
your application (e.g. "WindowsApplication1.exe" here, so that only related
activities are captured.

4. Open your program and get ready to reproduce the error.

5. Switch back to RegMon and press CTRL + E to start the capture.

6. Switch to your application to reproduce the error.

7. Once the error message pops up, go to RegMon immediately and press CTRL
+ E to stop the capture. Press CTRL + S to save the log to a file.

8. Analyze the RegMon log. It is likely that your application is trying to
access a COM component but the class ID for it is not found in your
registry. Let's see whether we have any "NOT FOUND" near the end of the log.

The FileMon is a very similar utility that captures file access related
activities. If any file your application trying to read is missing, FileMon
will reveal it. You may download it from the following link:
http://www.sysinternals.com/files/NTFILMON.ZIP

I hope the information is useful to you.

Regards,

Felix Wang
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

[Vinay]

Hi Felix,

Thanks for giving me more insight. I have tried Regmon utility and I
did find many NOTFOUNDs. Some initial lines of this log is pasted
below.

Can you help me in interpreting this log and point where I am going
wrong now. My application is running and it is only when I try to use
Excel it gives the error "File or Assembly Name Interop.Excel or one
of its dependencies was not found'.

Regards

Vinay

1 136.10604029 explorer.exe:548 OpenKey HKCU\Applications\MyStock.exe NOTFOUND
2 136.10607410 explorer.exe:548 OpenKey HKCR\Applications\MyStock.exe NOTFOUND
3 136.10640626 explorer.exe:548 QueryValue HKCU\Software\Microsoft\Windows\ShellNoRoam\MUICac he\C:\Documents
and Settings\Vinayg\Desktop\MyStock.exe SUCCESS " "
4 136.11276824 explorer.exe:548 OpenKey HKCU\Applications\MyStock.exe NOTFOUND
5 136.11280149 explorer.exe:548 OpenKey HKCR\Applications\MyStock.exe NOTFOUND
6 136.11309678 explorer.exe:548 QueryValue HKCU\Software\Microsoft\Windows\ShellNoRoam\MUICac he\C:\Documents
and Settings\Vinayg\Desktop\MyStock.exe SUCCESS " "
7 136.33999321 explorer.exe:548 OpenKey HKCU\Applications\MyStock.exe NOTFOUND
8 136.34002618 explorer.exe:548 OpenKey HKCR\Applications\MyStock.exe NOTFOUND
9 136.34063324 explorer.exe:548 QueryValue HKCU\Software\Microsoft\Windows\ShellNoRoam\MUICac he\C:\Documents
and Settings\Vinayg\Desktop\MyStock.exe SUCCESS " "
10 136.34091428 explorer.exe:548 OpenKey HKCU\Applications\MyStock.exe NOTFOUND
11 136.34094557 explorer.exe:548 OpenKey HKCR\Applications\MyStock.exe NOTFOUND
12 136.34120510 explorer.exe:548 QueryValue HKCU\Software\Microsoft\Windows\ShellNoRoam\MUICac he\C:\Documents
and Settings\Vinayg\Desktop\MyStock.exe SUCCESS " "
13 136.34141322 explorer.exe:548 OpenKey HKCU\Applications\MyStock.exe NOTFOUND
14 136.34144032 explorer.exe:548 OpenKey HKCR\Applications\MyStock.exe NOTFOUND
15 136.34165515 explorer.exe:548 QueryValue HKCU\Software\Microsoft\Windows\ShellNoRoam\MUICac he\C:\Documents
and Settings\Vinayg\Desktop\MyStock.exe SUCCESS " "
16 136.34184680 explorer.exe:548 OpenKey HKCU\Applications\MyStock.exe NOTFOUND
17 136.34187362 explorer.exe:548 OpenKey HKCR\Applications\MyStock.exe NOTFOUND
18 136.34208258 explorer.exe:548 QueryValue HKCU\Software\Microsoft\Windows\ShellNoRoam\MUICac he\C:\Documents
and Settings\Vinayg\Desktop\MyStock.exe SUCCESS " "
19 140.10235686 MyStock.exe:3572 OpenKey HKLM\Software\Microsoft\Fusion SUCCESS Key:
0xE17F7AC0
20 140.10238257 MyStock.exe:3572 QueryValue HKLM\Software\Microsoft\Fusion\LogPath NOTFOUND
21 140.10243481 MyStock.exe:3572 CloseKey HKLM\Software\Microsoft\Fusion SUCCESS Key:
0xE17F7AC0
22 140.10374000 MyStock.exe:3572 OpenKey HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Ins taller\Managed\S-1-5-21-1547161642-362288127-725345543-1110\Installer\Assemblies\C:|Documents
and Settings|Vinayg|Desktop|MyStock.exe.config NOTFOUND
23 140.10378805 MyStock.exe:3572 OpenKey HKCU\Software\Microsoft\Installer\Assemblies\C:|Do cuments
and Settings|Vinayg|Desktop|MyStock.exe.config NOTFOUND
24 140.10382409 MyStock.exe:3572 OpenKey HKCR\Installer\Assemblies\C:|Documents
and Settings|Vinayg|Desktop|MyStock.exe.config NOTFOUND
25 140.10386292 MyStock.exe:3572 OpenKey HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Ins taller\Managed\S-1-5-21-1547161642-362288127-725345543-1110\Installer\Assemblies\Global NOTFOUND
26 140.10388974 MyStock.exe:3572 OpenKey HKCU\Software\Microsoft\Installer\Assemblies\Globa l NOTFOUND
27 140.10393779 MyStock.exe:3572 OpenKey HKCR\Installer\Assemblies\Global SUCCESS Key:
0xE17F7AC0
28 140.10396936 MyStock.exe:3572 EnumerateValue HKCR\Installer\Assemblies\Global BUFOVRFLOW
29 140.10399171 MyStock.exe:3572 EnumerateValue HKCR\Installer\Assemblies\Global\Regcode,Version=" 1.0.3300.0",PublicKeyToken="b03f5f7f11d50a3a",Cult ure="neutral" SUCCESS "S~~&==b}09U,)k&Hq]wDFull_Redist>Q~1aV[Oi^9Kf+jNNJE_3"
30 140.10404004 MyStock.exe:3572 EnumerateValue HKCR\Installer\Assemblies\Global BUFOVRFLOW

v-*****@online.microsoft.com (Felix Wang) wrote in message news:<lq*************@cpmsftngxa06.phx.gbl>...

Hi Vinary,

Thanks for posting.

It seems that some dependencies of the "Interop.Excel.dll" is not found on
your target machine. Do we have Excel properly installed and COM components
properly registered on it?

To find out what is missing, we can make use of 2 utilities named FileMon
and RegMon:

The use of RegMon:

1. Download RegMon from http://www.sysinternals.com/files/ntregmon.zip

2. Extract the file to a temp folder. Close all other unnecessary programs.

3. Start RegMon. The utility is used to capture registry related
activities. Press CTRL + E to pause the capture. Then press CTRL + X to
clean the log. Press CTRL + L to set the filter. We replace the "*" with
your application (e.g. "WindowsApplication1.exe" here, so that only related
activities are captured.

4. Open your program and get ready to reproduce the error.

5. Switch back to RegMon and press CTRL + E to start the capture.

6. Switch to your application to reproduce the error.

7. Once the error message pops up, go to RegMon immediately and press CTRL
+ E to stop the capture. Press CTRL + S to save the log to a file.

8. Analyze the RegMon log. It is likely that your application is trying to
access a COM component but the class ID for it is not found in your
registry. Let's see whether we have any "NOT FOUND" near the end of the log.

The FileMon is a very similar utility that captures file access related
activities. If any file your application trying to read is missing, FileMon
will reveal it. You may download it from the following link:
http://www.sysinternals.com/files/NTFILMON.ZIP

I hope the information is useful to you.

Regards,

Felix Wang
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

[Felix Wang]

Hi Vinary,

These "NOT FOUND"s are normal here. They are not sufficient to reveal the
problem. For this issue, probably FileMon will be more helpful.

Apart from the logs, we should also have a "Details" button when the error
message pops up. Could you click the "Details" button of the error dialog
and paste the content of text field here as well?

If the MSI file is not large, do you think it is convenient if you send it
to me to have a look? Please add it to a zip first.

Regards,

Felix Wang
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

[Vinay]

Hi Felix,

Thanks for your prompt response.

FileMon did the trick and I am able to resolve my problem. It pointed
out that Interop.excel was missing from my desktop folder. As Ken
Tucker had pointed out it must be in the same folder as
application.exe, when I manually moved Interop.excel to desktop
folder, application had started working.

The whole confusion started due to existence of application.exe in 2
folders. While packaging this application (Windows Installer), I had
inadvertently created a reference to Primary Output (application.exe)
in the desktop folder. Application.exe and relevant interop.excel were
also existing in Program Files application folder. I was always
finding interop.excel in the same folder as application.exe.

Now I have created a shortcut to application.exe in desktop folder so
avoided the reference to primary out at 2 places.

Thank you once again for your help and letting us know about these 2
wonderful utilities.

Regards

Vinay

v-*****@online.microsoft.com (Felix Wang) wrote in message news:<XC**************@cpmsftngxa06.phx.gbl>...

Hi Vinary,

These "NOT FOUND"s are normal here. They are not sufficient to reveal the
problem. For this issue, probably FileMon will be more helpful.

Apart from the logs, we should also have a "Details" button when the error
message pops up. Could you click the "Details" button of the error dialog
and paste the content of text field here as well?

If the MSI file is not large, do you think it is convenient if you send it
to me to have a look? Please add it to a zip first.

Regards,

Felix Wang
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

[Felix Wang]

Hi Vinary,

Thanks for your feedback. I am glad to be of help.

I hope you enjoy posting here.

Regards,

Felix Wang
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.