View Single Post
  #2 (permalink)  
Old December 29th, 2008, 08:08 PM
dparsons dparsons is offline
Wrox Author
Points: 13,255, Level: 49
Points: 13,255, Level: 49 Points: 13,255, Level: 49 Points: 13,255, Level: 49
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: Oct 2005
Location: Ohio, USA
Posts: 4,104
Thanks: 1
Thanked 64 Times in 64 Posts
Send a message via AIM to dparsons

Hmm. This may turn out to be more trouble then its worth. By saying user control that, to me, means a .ascx file with either a vb or cs code file that provides x functionality / logic.

This is trivial when you are talking about Web forms but the functionality that you are looking for here would be more of an API (Class library). While it might be possible (I have never tried) to emit some sort of UI elements back from the class library, it would most certainly be a cumbersome task.

What I would suggest is to scrap the UI portion via managed code and simply update your VBA application. Then create a new Class library project in VS and provide the functionality that you will need there. As far as the Interop goes it would probably be best if you took a look at this article rather than me trying to spew it forth. ;]

Doug Parsons
Wrox online library: Wrox Books 24 x 7
Did someone here help you? Click on their post!
"Easy is the path to wisdom for those not blinded by themselves."