ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Importing Visual Studio form into VBA? (https://www.excelbanter.com/excel-programming/401943-importing-visual-studio-form-into-vba.html)

Mike Reynolds

Importing Visual Studio form into VBA?
 
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

Importing Visual Studio form into VBA?
 
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/sho...81658&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...)


All times are GMT +1. The time now is 03:16 AM.

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