Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / November 2007

Tip: Looking for answers? Try searching our database.

Importing Visual Studio form into VBA?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Mike Reynolds - 29 Nov 2007 19:14 GMT
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 - 29 Nov 2007 20:02 GMT
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...)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.