insert a spreadsheet control at design time

11 Sep 2006 3:34 PM

mpg

using vb express 2005
trying to insert a spreadsheet control onto a form.
i have added the reference for excel object 11.0
i cant figure out where to FIND the object to paste the control on my form
at design-time.

hope someone can help (it's easy in access-vba, but i cant figure it out
here)
mike g

11 Sep 2006 3:54 PM

Nate

Try this:

Display the main form in your project.
In the Toolbox, right-click on the Components header (any of the
categories will do, this just makes it easier to find). Select
Add/Remove items.
In the box that appears, select the COM Components tab.
Check the box next to "Microsoft Office Spreadsheet 11.0" and click OK.
That will produce an Excel control that you can drag to your form.

Hope that helps!
Nate

11 Sep 2006 4:53 PM

mpg

oh yah..!!!

thanks a bunch for that.
i was about to write my own spreadsheet control with draw functions. yikes.

Show quoteHide quote

"Nate" <howlsatfullmo***@gmail.com> wrote in message
news:1157990096.824967.13710@p79g2000cwp.googlegroups.com...
> Try this:
>
> Display the main form in your project.
> In the Toolbox, right-click on the Components header (any of the
> categories will do, this just makes it easier to find). Select
> Add/Remove items.
> In the box that appears, select the COM Components tab.
> Check the box next to "Microsoft Office Spreadsheet 11.0" and click OK.
> That will produce an Excel control that you can drag to your form.
>
> Hope that helps!
> Nate
>

11 Sep 2006 6:37 PM

Nate

You're welcome! If you can help it, don't reinvent the wheel... :-)