LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 170
Default Excel 2003 not compatible with Office 2k Web Components -- HELP!


wrote in message
...

The simplest fix is to re-install Office2k, the IS dept

presumably
installed over it but they will work side by side


Hm. This means re-registering the file types manually
after installing the old Excel 2k. Ew. Well If this is a
quick solution, I guess I'll have IT guy try it.



No the Install should re-register them , the different versions
of the product have different names for the object model
dll

They should be looking for the Excel Object library value

in the
registry , the libraries are backward compatible, I have

code written
for Excel 97 that works fine in Office XP


Actually, I'm fairly certain that the OBJECT GUID is for
the OWC "Office Spreadsheet" control, not the GUID
corresponding to the Excel.Application ProgID.


But that is part of the MSOffice Web Components, the
dll is called MSOWC.dll and is installed with Office
and presumably removed when you uninstall it

http://www.microsoft.com/office/ork/...OWCInstall.htm

So I'm not sure that Reinstalling Excel 2k is going to
help. I'm pretty sure that I'll have to install the old
Web Components... however, if they do use the same GUID
(and would therefore be "backwards compatible" as you say
they are), I don't see why the Office 2k3 machines don't
just work...

Here's an example of the code:

<object id=Spreadsheet1 style="LEFT: 0px; TOP: 0px"
height="85%" width="100%" classid=clsid:0002E510-0000-0000-
C000-000000000046 VIEWASTEXT
<param name="HTMLURL" value=""
<param name="DataType" value="CSVDATA"
<param name="CSVData" value="<%=RemoveQuotes
(sdata)%"
<param name="AutoFit" value="-1"
<param name="DisplayColHeaders" value="-1"
<param name="DisplayGridlines" value="-1"
<param name="DisplayHorizontalScrollBar" value="-
1"
<param name="DisplayRowHeaders" value="-1"
<param name="DisplayTitleBar" value="-1"
<param name="DisplayToolbar" value="-1"
<param name="DisplayVerticalScrollBar" value="-1"
<param name="EnableAutoCalculate" value="-1"
<param name="EnableEvents" value="-1"
<param name="MoveAfterReturn" value="-1"
<param name="MoveAfterReturnDirection" value="0"
<param name="RightToLeft" value="0"
<param name="ViewableRange" value="1:65536"
</object

This does not load the Office 2k3 ActiveX object, but
works fine for Office 2k machines.

Any more ideas, or do you still think reinstalling Excel
2k will do the trick?


You should be able to use the Office XP equivalent
it probably just wasnt installed on the machine , it can be
loaded from the CD or even downloaded from Microsoft

http://support.microsoft.com:80/supp...NoWebContent=1
http://www.microsoft.com/downloads/d...f-9024e39f5463
http://www.microsoft.com/downloads/d...9-11f7ea1db726

Keith


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 being backward compatible NickC Excel Discussion (Misc queries) 1 February 4th 08 04:34 PM
problem exporting data from Office PivotTable Components to Excel Hammami Excel Discussion (Misc queries) 0 December 22nd 06 11:16 AM
installing web components into office 12 ( excel) schmintan Excel Discussion (Misc queries) 0 October 10th 06 05:19 PM
Office XP Web Components supported by Office 2003 Chris P Excel Discussion (Misc queries) 0 June 21st 05 11:35 PM
Filterable online inventory w/out Office 2003 Web Components? eric g Excel Discussion (Misc queries) 0 March 13th 05 05:17 PM


All times are GMT +1. The time now is 05:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"