msvisual.com Forum Index
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister   ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Trying to deploy class written in vb.net for use in VBA addi

 
Post new topic   Reply to topic    msvisual.com Forum Index -> VB Deployment
Author Message
Dave



Joined: 13 Oct 2007
Posts: 1

PostPosted: Fri Oct 12, 2007 4:54 pm    Post subject: Trying to deploy class written in vb.net for use in VBA addi Reply with quote

First: if I am in the wrong group here, please point me to the
appropriate ng.

So far, I have done all of my programming for PowerPoint addins in
VBA. I have created one small class in Perl, which my addin code
accesses through a .dll which is registered using regsvr32.

I would like to take advantage of some of the functionality provided
by vb.net. I downloaded VS 2008 Beta 2 and installed it ok on XP
SP2. Now I am trying to generate and deploy just a small test class,
and I'm totally stuck, puzzled, and frustrated.

I seem to be able to build something ok - I can see a whole bunch of
files gettting generated (mainfests, .dll, etc.) in different
directories (bin, debug, release, etc.) I have no idea what to do
from that point on. For instance, how am I supposed to build those
files soat they are COM-visible? What's all this about no-regsiter
COM - do I have run regasm on some, or all, of these files? Which?
Should I be able to see the test class' library in VBA->References (I
don't).

I found one reference to VBA-.NET developemnt that said I should
generate a .snk file (which I did do - I can see it). But when I try
to add an statement to the generated
AssemblyInfo.vb file, VS gives me a warning.

I'm pretty sure that most of my problems stem from not knowing doodly-
squat about development in the VS Express environment. Can anyone
point me to a step-by-step guide for generating a small class in that
environment which can be accessed from VBA?

Archived from group: microsoft>public>vb>deployment
Back to top
View user's profile Send private message
"Jan Hyde



Joined: 04 Oct 2007
Posts: 466

PostPosted: Fri Oct 12, 2007 6:19 pm    Post subject: Re: Trying to deploy class written in vb.net for use in VBA Reply with quote

Dave 's wild thoughts were released
on Fri, 12 Oct 2007 12:54:02 -0000 bearing the following
fruit:

>First: if I am in the wrong group here, please point me to the
>appropriate ng.

One with 'dotnet' in the name.

J

>So far, I have done all of my programming for PowerPoint addins in
>VBA. I have created one small class in Perl, which my addin code
>accesses through a .dll which is registered using regsvr32.
>
>I would like to take advantage of some of the functionality provided
>by vb.net. I downloaded VS 2008 Beta 2 and installed it ok on XP
>SP2. Now I am trying to generate and deploy just a small test class,
>and I'm totally stuck, puzzled, and frustrated.
>
>I seem to be able to build something ok - I can see a whole bunch of
>files gettting generated (mainfests, .dll, etc.) in different
>directories (bin, debug, release, etc.) I have no idea what to do
>from that point on. For instance, how am I supposed to build those
>files soat they are COM-visible? What's all this about no-regsiter
>COM - do I have run regasm on some, or all, of these files? Which?
>Should I be able to see the test class' library in VBA->References (I
>don't).
>
>I found one reference to VBA-.NET developemnt that said I should
>generate a .snk file (which I did do - I can see it). But when I try
>to add an statement to the generated
>AssemblyInfo.vb file, VS gives me a warning.
>
>I'm pretty sure that most of my problems stem from not knowing doodly-
>squat about development in the VS Express environment. Can anyone
>point me to a step-by-step guide for generating a small class in that
>environment which can be accessed from VBA?

--
Jan Hyde

https://mvp.support.microsoft.com/profile/Jan.Hyde

Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    msvisual.com Forum Index -> VB Deployment All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group