PDA

View Full Version : Solved: Spreadsheet control 2007



georgiboy
07-08-2009, 08:11 AM
Is it true that there is no spreadsheet control in Excel 2007?

I would like to display a range of data in a userform and retain its formatting if possible.

Thanks for looking

Marcster
07-08-2009, 10:33 AM
Believe the spreadsheet control is part of OWC (Office Web Components) and yep, Microsoft has dropped it from Excel 2007.
You'll need to download the OWC 2003 to use it.

More info on changes made in 2007:
http://technet.microsoft.com/en-us/library/cc178954.aspx

georgiboy
07-10-2009, 10:13 AM
Thanks for that Marcster :)