Solved: Spreadsheet control 2007

[georgiboy]

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]

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/l.../cc178954.aspx

[georgiboy]

Thanks for that Marcster