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

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

spreadsheet control
 

Nick,

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

Eli
"NickHK" wrote:

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

spreadsheet control
 

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

"???" wrote in message
...
Nick,

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

Eli
"NickHK" wrote:

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

spreadsheet control
 

Thanks a lot

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

"NickHK" wrote:

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

"???" wrote in message
...
Nick,

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

Eli
"NickHK" wrote:

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

spreadsheet control
 

Post back if you still have trouble, giving details.

NickHK

"???" wrote in message
...
Thanks a lot

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

"NickHK" wrote:

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

"???" wrote in message
...
Nick,

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

Eli
"NickHK" wrote:

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