Importing Visual Studio form into VBA?

[Mike Reynolds]

VBA form controls do not include a date-picker. VS2005 does. This is a
critical matter for me. Is there a way to import a VS2005 form in Excel VBA?

(I am trying to create better reports than Crystal, that will take data from
a database, based on user selections in a form, and then populate cells in a
spreadsheet with the data. Crystal will do two or more levels of groupings,
but I want to also break-up the data by week, month or quarter, in ways that
are too complex for Crystal Reports. Then, I want double clicking on a cell
to bring up a another report in a new worksheet that displays the detail
records for the grouping field that was clicked on. Crystal XI also has a
very nice date-picker control.)

 

[Mike Reynolds]

Hey, I just found an example that adds VSTO add-in customization without
forcing the creation of a new project. (At least I think that is what this
is.) I was able to just cut and paste the code to the database code and form
in VS2005 that I already have. So I can do it all in VS2005 without having to
revert to VBA.

Here is the thread,
http://forums.microsoft.com/MSDN/showpost.aspx?postid=2481658&siteid=1. The
link to the example is in one of the posts.

(BTW, the formatting of messages in this forum is schitzo, sticking the last
word of each line on a separate line by itself, doubling the length of your
message...)