ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Problem with using VS2008 to develop vb.net Excel application (https://www.excelbanter.com/excel-programming/418952-problem-using-vs2008-develop-vbulletin-net-excel-application.html)

JBRC Chorus

Problem with using VS2008 to develop vb.net Excel application
 
I am not sure if this is the right discussion group for this question - if
not, maybe someone could please point me in the right direction.
I have used the Excel application teamplate in VS2008 to develop some vb.net
code to automate an existing Excel spreadsheet. Everything works fine in the
VS environment and when I use Build to Debug or Release, the appropriate Bin
folders are created.
The "Publish" option under the build menu is disabled, so I assumed that if
I open the spreadsheet itself in the release or debug folder, it would link
to the underlying vb add-ins. However, when I do this the addin does not seem
to work - I have put buttons on some worksheets and these are dead, nothing
happens on click.
Can someone advise me how to activate the vb.net code that I have developed.
Is there some deployment utility or registratio step that i have to go
through?
Thanks for your help.

JP[_4_]

Problem with using VS2008 to develop vb.net Excel application
 
Just a guess but you probably want:

microsoft.public.dotnet.framework.interop

--JP


On Oct 23, 12:04*pm, JBRC Chorus
wrote:
I am not sure if this is the right discussion group for this question - if
not, maybe someone could please point me in the right direction.
I have used the Excel application teamplate in VS2008 to develop some vb.net
code to automate an existing Excel spreadsheet. Everything works fine in the
VS environment and when I use Build to Debug or Release, the appropriate Bin
folders are created.
The "Publish" option under the build menu is disabled, so I assumed that if
I open the spreadsheet itself in the release or debug folder, it would link
to the underlying vb add-ins. However, when I do this the addin does not seem
to work - I have put buttons on some worksheets and these are dead, nothing
happens on click.
Can someone advise me how to activate the vb.net code that I have developed.
Is there some deployment utility or registratio step that i have to go
through?
Thanks for your help.




All times are GMT +1. The time now is 02:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com