|
PureBytes Links
Trading Reference Links
|
<x-html><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 5.50.3825.1300" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT size=2>
<DIV><FONT size=2><FONT size=2><FONT color=#0000ff><FONT size=2><FONT
size=2><FONT size=2>
<DIV><FONT size=2><FONT color=#000000><STRONG>OLE between MSK+Excel
(+v.v.) - FAQ's </STRONG>{where linking a Table(object)
meets (=same as) opening it in more than one(1)
applications}</FONT></FONT></DIV>
<DIV><FONT color=#000000
size=2>-----------------------------------------------------------------</FONT></FONT></FONT></FONT></FONT></FONT></FONT><FONT
size=2><FONT size=2><FONT
color=#0000ff><STRONG></DIV></DIV></STRONG></FONT></FONT></FONT>
<DIV><FONT size=2><FONT size=2><FONT
color=#0000ff><STRONG></STRONG></FONT></FONT></FONT> </DIV>
<DIV><FONT size=2><FONT size=2><FONT
color=#0000ff><STRONG>Q11. </STRONG></FONT></FONT></FONT></FONT><FONT
size=2>How to <STRONG>double link </STRONG><EM>data </EM>between <EM>two
</EM>applications, f.e. between Word and Excel, so that you can change
either one and the change</FONT></DIV>
<DIV><FONT size=2> is (automaticaly)
reflected in the other?</FONT></DIV>
<DIV><FONT size=2><BR>This is just what <STRONG>OLE</STRONG>,
eg <STRONG>Object Embedding </STRONG>does.</FONT></DIV>
<DIV><FONT size=2>For example, here's how to make a <STRONG>Table </STRONG>that
will be the same in both:<BR></FONT></DIV>
<DIV><FONT size=2><STRONG>Open Excel</STRONG></FONT></DIV>
<DIV><FONT size=2>1. Create the Table in Excel {see Excel's Help for further
info on the available variants in creating Tables}.<BR>2. Select the
Table.</FONT></DIV>
<DIV><FONT size=2>3. Click Edit + Copy.</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2><STRONG>Open Word</STRONG><BR>4. Switch to the Word
window.</FONT></DIV>
<DIV><FONT size=2>5. Click the mousepointer where you want the table to
appear.<BR>6. Click Edit + Paste Special.<BR>7. In the Paste Special dialog
box</FONT></DIV>
<DIV><FONT size=2> -Choose from the list to
Paste this as a "Microsoft Excel Worksheet Object".</FONT></DIV>
<DIV><FONT size=2> -Click the
Paste Link radio button (to make this a Paste Link operation).<BR>8.
Click OK.</FONT></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2><STRONG>In General</STRONG></FONT></DIV>
<DIV><FONT size=2>9. W</FONT><FONT size=2>hen you Click on the Table to
Edit it in Word, the Excel program will "pop up" as the place to actually make
the changes.</DIV></FONT>
<DIV><FONT size=2>10. <STRONG>Right Click </STRONG>the Windows Clock that's
situated on the right-end of the TaskBar (=the System
Tray).</FONT></DIV>
<DIV><FONT size=2>11. In the Small Context Menu</FONT></DIV>
<DIV><FONT size=2> -Click <STRONG>Tile
Windows Horizontaly</STRONG></FONT></DIV>
<DIV><FONT size=2>
or</FONT></DIV>
<DIV><FONT size=2> -Click
<STRONG>Stack Windows Verticaly</STRONG></FONT></DIV>
<DIV><FONT size=2>12. A</FONT><FONT size=2>ny time you have the sheet's Table
open in Excel and <EM>make changes</EM>, they will <EM>automatically
</EM>appear in the Word document.</FONT></DIV></DIV>
<DIV><FONT size=2></FONT><BR><FONT size=2>Regards,<BR>Ton Maas<BR></FONT><A
href="mailto:ms-irb@xxxxxxxxxxxxxxxx";><FONT
size=2>ms-irb@xxxxxxxxxxxxxxxx</FONT></A><BR><FONT size=2>Dismiss the ".nospam"
bit (including the dot) when replying.<BR>Homepage </FONT><A
href="http://home.planet.nl/~anthmaas";><FONT
size=2>http://home.planet.nl/~anthmaas</FONT></A></DIV></BODY></HTML>
</x-html>From ???@??? Sat Apr 15 17:19:16 2000
Return-Path: <majordom@xxxxxxxxxxxxxxxxxx>
Received: from listserv.equis.com (listserv.equis.com [204.246.137.2])
by purebytes.com (8.9.3/8.9.3) with ESMTP id SAA23531
for <neal@xxxxxxxxxxxxx>; Fri, 14 Apr 2000 18:04:40 -0700
Received: (from majordom@xxxxxxxxx)
by listserv.equis.com (8.8.7/8.8.7) id SAA01509
for metastock-outgoing; Fri, 14 Apr 2000 18:21:20 -0600
X-Authentication-Warning: listserv.equis.com: majordom set sender to owner-metastock@xxxxxxxxxxxxx using -f
Received: from freeze.metastock.com (freeze.metastock.com [204.246.137.5])
by listserv.equis.com (8.8.7/8.8.7) with ESMTP id SAA01500
for <metastock@xxxxxxxxxxxxxxxxxx>; Fri, 14 Apr 2000 18:21:11 -0600
Received: from smtp02.wxs.nl (smtp02.wxs.nl [195.121.6.60])
by freeze.metastock.com (8.8.5/8.8.5) with ESMTP id SAA05845
for <metastock@xxxxxxxxxxxxx>; Fri, 14 Apr 2000 18:33:10 -0600 (MDT)
Received: from escom ([195.121.219.88]) by smtp02.wxs.nl
(Netscape Messaging Server 3.61) with SMTP id AABDE8
for <metastock@xxxxxxxxxxxxx>; Sat, 15 Apr 2000 02:16:34 +0200
Message-ID: <024801bfa670$4b4c41e0$70da79c3@xxxxx>
From: "A.J. Maas" <anthmaas@xxxxxxxxx>
To: "Metastock-List" <metastock@xxxxxxxxxxxxx>
Subject: IE5x - tips
Date: Sat, 15 Apr 2000 01:24:30 +0200
Organization: Ms-IRB
MIME-Version: 1.0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.50.3825.400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.3825.400
Sender: owner-metastock@xxxxxxxxxxxxx
Precedence: bulk
Reply-To: metastock@xxxxxxxxxxxxx
Status:
Internet Explorer tip:
Auto Address (Internet Explorer 5.x)
You can type a word in the Address bar and press Ctrl-Enter to
automatically add "http://www"; and ".com" on both sides of the word.
Get more Internet Explorer 5.x how-tos and tips:
http://2.digital.cnet.com/cgi-bin2/flo?x=dAAhuhoBYEwgmBEuY
Regards,
Ton Maas
ms-irb@xxxxxxxxxxxxxxxx
Dismiss the ".nospam" bit (including the dot) when replying.
Homepage http://home.planet.nl/~anthmaas
|