| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stock control spreadsheet | Excel Worksheet Functions | |||
| Odd spreadsheet control | Excel Discussion (Misc queries) | |||
| Using control to clear spreadsheet | Excel Discussion (Misc queries) | |||
| Spreadsheet 9.0 Control | Excel Programming | |||
| stock control spreadsheet | Excel Worksheet Functions | |||
Linear Mode
