Rob,
For a workaround you can use OWC10 and OWC11. These versions of the
SpreadSheet
control can contain multiple sheets, and the sheets within one instance of
the control can be
linked to each other using standard Excel link formulas.
Stephen Culhane
(e-mail address removed)
Microsoft Developer Support
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
| Content-Class: urn:content-classes:message
| From: "Dan Ricker" <
[email protected]>
| Sender: "Dan Ricker" <
[email protected]>
| References: <
[email protected]>
<
[email protected]>
| Subject: RE: Binding web page controls to Spreadsheet component doesn't
work
| Date: Mon, 21 Jul 2003 09:40:33 -0700
| Lines: 77
| Message-ID: <
[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcNPps4gOTdhRfTOR5qG1rbxr1FZrQ==
| Newsgroups: microsoft.public.office.developer.web.components
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl
microsoft.public.office.developer.web.components:6098
| NNTP-Posting-Host: TK2MSFTNGXA09 10.40.1.161
| X-Tomcat-NG: microsoft.public.office.developer.web.components
|
| There was a security patch for OWC that "fixed" this.
| The "Document()" statement no longer works after the patch.
|
| Thx
| Dan
|
| >-----Original Message-----
| >Rob,
| > Do you have the exact name of the example, or the KB
| Article
| >number. This will help me reproduce the problem, and
| find a solution.
| >
| >
| >Thanks in Advance
| >
| >
| >Stephen Culhane
| >
[email protected]
| >Microsoft Developer Support
| >
| >This posting is provided "AS IS" with no warranties, and
| confers no rights.
| >
| >
| >
| >--------------------
| >| From: "\"Rob Hetlam\"" <.>
| >| Subject: Binding web page controls to Spreadsheet
| component doesn't work
| >| Date: Sun, 20 Jul 2003 10:02:27 -0400
| >| Lines: 14
| >| X-Priority: 3
| >| X-MSMail-Priority: Normal
| >| X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
| >| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
| >| Message-ID: <
[email protected]>
| >| Newsgroups:
| microsoft.public.office.developer.web.components
| >| NNTP-Posting-Host: d150-83-130.home.cgocable.net
| 24.150.83.130
| >| Path: cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!
| TK2MSFTNGP10.phx.gbl
| >| Xref: cpmsftngxa06.phx.gbl
| >microsoft.public.office.developer.web.components:6090
| >| X-Tomcat-NG:
| microsoft.public.office.developer.web.components
| >|
| >| I am trying the MS Office 2000 Web Components sample
| that simulates cell
| >| links between SpreadSheet Components. This VB
| script.....
| >|
| >| SpreadSheet2.Range("B1").Formula
| = "=document.script.LinkToSheet1(""B5"")"
| >|
| >| .....doesn't work on my Win2000 Advanced Server machine
| with IE6. The
| >| function never gets called. In fact,
| evan "=document.title" doesn't work.
| >It
| >| produces #NAME? However, "=document" produces [object].
| It doesn't seam to
| >| like the period (.). The literature states to bind a
| html control to a
| >cell
| >| you use the form "=document.control.value". This
| doesn't work on my
| >machine.
| >|
| >| Thanks
| >|
| >|
| >|
| >
| >.
| >
|
