Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
My Type Library is not complete
Dear friends
I used ' Office12\EXCEL.EXE ' as type library fo connecting to the excel automation . But this type library dose not support properties and methodes which belong just to Excel2007. How can I do? Best Regards. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
My Type Library is not complete
You most likely also need the OFFICE typelib, typically located at
C:\Program Files\Common Files\Microsoft Shared\OFFICE12\MSO.DLL. Can you provide an example of something that in not in the Excel typelib? -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) wrote in message ... Dear friends I used ' Office12\EXCEL.EXE ' as type library fo connecting to the excel automation . But this type library dose not support properties and methodes which belong just to Excel2007. How can I do? Best Regards. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
My Type Library is not complete
On Nov 17, 2:28 pm, "Chip Pearson" wrote:
You most likely also need the OFFICE typelib, typically located at C:\Program Files\Common Files\Microsoft Shared\OFFICE12\MSO.DLL. Can you provide an example of something that in not in the Excel typelib? -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consultingwww.cpearson.com (email on the web site) wrote in message ... Dear friends I used ' Office12\EXCEL.EXE ' as type library fo connecting to the excel automation . But this type library dose not support properties and methodes which belong just to Excel2007. How can I do? Best Regards.- Hide quoted text - - Show quoted text - Dear Chip Person Thanks for your attention I used programattic identifier and vnt1 as a variant for connecting to Excel automation: Vnt1:= CreateOLEObject('Excel.Application'); in the code below the TintandShade property didn't support by my excel server ' Office12\EXCEL.EXE '. With Sheet1.Range['B2','D4'].Borders.Item[xlEdgeTop] do begin LineStyle:= xlContinuous; ColorIndex:= 0; // TintAndShade:= 0; Weight:= xlThin; end; also I had some items like this which I couldn't access properties belong particulary to Excel2007. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
My Type Library is not complete
On Nov 27, 8:01 pm, wrote:
On Nov 17, 2:28 pm, "Chip Pearson" wrote: You most likely also need the OFFICE typelib, typically located at C:\Program Files\Common Files\Microsoft Shared\OFFICE12\MSO.DLL. Can you provide an example of something that in not in the Excel typelib? -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consultingwww.cpearson.com (email on the web site) wrote in message ... Dear friends I used ' Office12\EXCEL.EXE ' as type library fo connecting to the excel automation . But this type library dose not support properties and methodes which belong just to Excel2007. How can I do? Best Regards.- Hide quoted text - - Show quoted text - Dear Chip Person Thanks for your attention I used programattic identifier and vnt1 as a variant for connecting to Excel automation: Vnt1:= CreateOLEObject('Excel.Application'); in the code below the TintandShade property didn't support by my excel server ' Office12\EXCEL.EXE '. With Sheet1.Range['B2','D4'].Borders.Item[xlEdgeTop] do begin LineStyle:= xlContinuous; ColorIndex:= 0; // TintAndShade:= 0; Weight:= xlThin; end; also I had some items like this which I couldn't access properties belong particulary to Excel2007.- Hide quoted text - - Show quoted text - Dear Chip Person I looked for OFFICE12\MSO.DLL but I couldn't find it. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
My Type Library is not complete
I looked for OFFICE12\MSO.DLL but I couldn't find it. With any workbook open in Excel 2007, go to the VBA editor, press CTRL G to display the Immediate window, and enter the following and press ENTER: ?ThisWorkbook.VBProject.References("OFFICE").FullP ath This will display the full path name of the typelib for Office. On my Vista box, it is C:\Program Files\Common Files\Microsoft Shared\OFFICE12\MSO.DLL -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) wrote in message ... On Nov 27, 8:01 pm, wrote: On Nov 17, 2:28 pm, "Chip Pearson" wrote: You most likely also need the OFFICE typelib, typically located at C:\Program Files\Common Files\Microsoft Shared\OFFICE12\MSO.DLL. Can you provide an example of something that in not in the Excel typelib? -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consultingwww.cpearson.com (email on the web site) wrote in message ... Dear friends I used ' Office12\EXCEL.EXE ' as type library fo connecting to the excel automation . But this type library dose not support properties and methodes which belong just to Excel2007. How can I do? Best Regards.- Hide quoted text - - Show quoted text - Dear Chip Person Thanks for your attention I used programattic identifier and vnt1 as a variant for connecting to Excel automation: Vnt1:= CreateOLEObject('Excel.Application'); in the code below the TintandShade property didn't support by my excel server ' Office12\EXCEL.EXE '. With Sheet1.Range['B2','D4'].Borders.Item[xlEdgeTop] do begin LineStyle:= xlContinuous; ColorIndex:= 0; // TintAndShade:= 0; Weight:= xlThin; end; also I had some items like this which I couldn't access properties belong particulary to Excel2007.- Hide quoted text - - Show quoted text - Dear Chip Person I looked for OFFICE12\MSO.DLL but I couldn't find it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date type library | Excel Programming | |||
Missing Type Library | Excel Programming | |||
Type Library Reference | Excel Programming | |||
TYPE Library issues. | Excel Programming | |||
Set a Reference to a Type Library | Excel Programming |