spreadsheet control

[×לי]

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

 

[NickHK]

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/library/aa141361(office.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

 

[×לי]

Nick,

Probably I dont have this file, and I am wondering where I can find it.

Eli

 

[NickHK]

Did you read my reply ?
"The Office Web components are an optional install. Run you Office
installation again, changing this feature to install."

Which version of Excel do you have ?

NickHK

 

[×לי]

Thanks a lot

I didn't noticed the word optional......

 

[NickHK]

Post back if you still have trouble, giving details.

NickHK