View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default spreadsheet control

I have it listed as "Microsft Office Spreadsheet 10.0" which is apparently
supplied by:
C:\Program Files\Common Files\Microsoft Shared\Web Components\10\OWC10.DLL
- the Office Web components dll.

IIRC:
As I have Office 9 and 10 installed, I also have an entry for "Microsoft
Office Spreadsheet 9.0", but this seems invalid and errors upon
instantiation.
The earlier versions were a single worksheet, although later version are
more like a full workbook.
The Office Web components are an optional install. Run you Office
installation again, changing this feature to install.

Curiously, according to:
http://msdn2.microsoft.com/en-US/lib...ffice.10).aspx

Microsoft Office XP Developer
Understanding the Spreadsheet Control
......
More rows and columns: The Spreadsheet component now supports 262,144 rows
by 18,278 columns (ZZZ).

Which is more than the version of Excel/Office that provides this component.

NickHK

"???" wrote in message
...
Hi

I tried to add a spreadsheet control to a userform but somehow it is not
installed in my VBE (at Tools - additional controls).
I will be happy if someone can give me the link to download the relevant

file.

Thanks in advance

Eli