Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
Lac Lac is offline
external usenet poster
 
Posts: 1
Default Excel solution deployment issue

Hi Everybody,

I wanted to deploy my VSTO 2005 "Hello World" Excel solution. This is a
simple worksheet without any data and the only functionality it has is to
display the hello world message from the ThisWorkbook_Startup event handler.
Difficult, insn't it ? It works fine from my development computer but as soon
as I try to "deploy" it on any other computer it stops working. I know, there
are a rich set of prerequisities on the target computer to run such a
solution, so the followings are met :

-.Net Framework 2 installed
-Office installed (Small Business Edition)
-Office PIA-s installed
-VSTO Runtime installed
-The required .Net Enterprise security policy is created with caspol, this
way :
++++++
caspol -en -q -ag All_Code -url "file://c:\temp\excelworkbook1.dll"
FullTrust -n "ExcelSolution" -d "Description" -levelfinal on
++++++

When I open the workbook on the target computer, the assembly is not loaded
and there is no error message or any trace of what actually was happening.

Regarding the article
(http://msdn2.microsoft.com/en-us/library/zcfbd2sk.aspx) there should be
application and deployment manifests for the solution to work. However, there
are no manifests files created until I publish a solution and I believe there
is no need for the manifests until I do not want automated updating process,
because the solution works on my computer without them.

So what is the truth ? What is the simplest way to get it work on one single
computer apart from the developers own ?

Thanks,
Laszlo



--
-----------------------------
Laszlo, Frank
Technotrade Informatics, Inc.
IT Director
MCSE, CCNA, TCE
-----------------------------
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 415
Default Excel solution deployment issue

Maybe better luck at microsoft.public.excel.sdk or
microsoft.public.dotnet.framework.interop, as this has little to do with
Excel as such and more to do with .Net deployment.

NickHK

"Lac" ...
Hi Everybody,

I wanted to deploy my VSTO 2005 "Hello World" Excel solution. This is a
simple worksheet without any data and the only functionality it has is to
display the hello world message from the ThisWorkbook_Startup event
handler.
Difficult, insn't it ? It works fine from my development computer but as
soon
as I try to "deploy" it on any other computer it stops working. I know,
there
are a rich set of prerequisities on the target computer to run such a
solution, so the followings are met :

-.Net Framework 2 installed
-Office installed (Small Business Edition)
-Office PIA-s installed
-VSTO Runtime installed
-The required .Net Enterprise security policy is created with caspol, this
way :
++++++
caspol -en -q -ag All_Code -url "file://c:\temp\excelworkbook1.dll"
FullTrust -n "ExcelSolution" -d "Description" -levelfinal on
++++++

When I open the workbook on the target computer, the assembly is not
loaded
and there is no error message or any trace of what actually was happening.

Regarding the article
(http://msdn2.microsoft.com/en-us/library/zcfbd2sk.aspx) there should be
application and deployment manifests for the solution to work. However,
there
are no manifests files created until I publish a solution and I believe
there
is no need for the manifests until I do not want automated updating
process,
because the solution works on my computer without them.

So what is the truth ? What is the simplest way to get it work on one
single
computer apart from the developers own ?

Thanks,
Laszlo



--
-----------------------------
Laszlo, Frank
Technotrade Informatics, Inc.
IT Director
MCSE, CCNA, TCE
-----------------------------



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Solution for stdole32.tlb issue with excel and vista sunny Setting up and Configuration of Excel 1 March 5th 09 07:56 PM
VBA Library References - deployment issue [email protected] Excel Programming 3 June 6th 06 10:05 PM
VBA Library References - deployment issue Chris Leroquais Excel Programming 0 June 6th 06 03:04 PM
macro deployment - References DLL issue [email protected] Excel Programming 7 June 2nd 06 10:44 AM
Solution for conditional formatting issue Fleone Excel Programming 2 March 10th 05 11:29 PM


All times are GMT +1. The time now is 01:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"