Copy / Paste special in to a VB app to get real-time numbers updated from Web
OfficeXP has this feature built into it -- smart tags. Just copy, paste,
and click a couple times and everything is setup automatically.
In VB you will want to either get the information from the web and parse
through the HTML until you find the information you want, or grab the
information from that excel file.
--------------------
| Newsgroups:
comp.lang.basic.visual.misc,microsoft.public.vb.com,microsoft.public.vb.cont
rols.internet,microsoft.public.vb.general.discussion,microsoft.public.vb.ole
| Subject: Copy / Paste special in to a VB app to get real-time numbers
updated from Web
| Lines: 16
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
| Date: Tue, 27 Mar 2001 15:53:30 +0100
| NNTP-Posting-Host: 212.135.233.93
| X-Trace: monolith.news.easynet.net 985704766 212.135.233.93 (Tue, 27 Mar
2001 15:52:46 BST)
| NNTP-Posting-Date: Tue, 27 Mar 2001 15:52:46 BST
| Organization: posted via Easynet
| Path:
cppssbbsa01.microsoft.com!news-out.cwix.com!newsfeed.cwix.com!newsfeed.icl.n
et!news.tele.dk!195.158.233.21!news1.ebone.net!news.ebone.net!easynet-monga!
easynet.net!easynet-post2!monolith.news.easynet.net!not-for-mail
| Xref: cppssbbsa01.microsoft.com microsoft.public.vb.com:13139
microsoft.public.vb.controls.internet:30848
microsoft.public.vb.general.discussion:244015 microsoft.public.vb.ole:16181
| X-Tomcat-NG: microsoft.public.vb.com
|
| In Excel I can copy a cell, and "Paste Special" and "Paste Link" in
another
| spread sheet, so when the source changes,so does the target.
|
| Can I do this with a web page (ie www.cnn.com), so when something changes
| (ie the DOW Jones index), I can automatically get an update in Excel.
|
| What I also want, is to get the update in my VB application, probably as a
| DDE Link.
|
| Any ideas please.
|
| Garry
|
|
|
|
|
