Re: Does anyone read unanswered threads?

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Jezebel (warcrimes_at_whitehouse.gov)
Date: 02/28/05 

Date: Tue, 1 Mar 2005 09:31:12 +1100

Create a UserForm. Add an Inet control. Give the control the web address,
then read back the content of the page as text. Then there's the fun part:
parsing the page text to extract the information you want (bearing in mind
that the page is HTML encoded, and may contain any amount of peripheral
stuff).

"Steve" <swrtree@hotmail.com> wrote in message
news:42239a57$1@dnews.tpgi.com.au...
> Helmut, Jonathjon, Doug
> Thanks for the responses. I understand the answers are given by
> volunteers. On and off I've been answering questions myself in other
> groups over the past eight years or so (certainly not to MVP standard).
> Answering other peoples questions is the best method I know to reinforce
> learning. As you might expect of a self-taught amateur with a narrow field
> of application, there are a lot of questions I simply cannot answer or am
> not comfortable answering. Sometimes I try to help someone and wind up on
> my limit when the questioner comes back with "that works well except...".
>
> While I can solve most of the problems I need to in Access and Excel, I am
> yet to become familiar with Word and interaction with the web. My sole
> experience in Word is to create a .dot that either locates a file name
> based on a date or creates a new document with some verbiage and a couple
> of tables. I've had zilch interaction with the web. As much as anything
> else, I want to come to grips with Word VBA doing something slightly
> practical that also expands my broader knowledge of VBA.
>
> My questions said I did not want a lazy answer. All I expected in return
> was something like:
>
> Use this to open a web page
> You may have problems reading the right frame ...
> To write the result to a document ...
>
> Perhaps if I'd attacked it in three question? <bg>
>
> Thanks anyway. I do appreciate that you guys exist. I'll copy the 70+
> pages manually and start on something else.
>
> Steve
>
>
>
> "Helmut Weber" <HelmutWeber@discussions.microsoft.com> wrote in message
> news:F26D9AA1-8D5D-4FBE-9EC2-B94C3E514602@microsoft.com...
>> Hi Steve,
>>
>> I think, some questions may stay without reply,
>> as a good helpful answer would be too complex or too long,
>> or there is no such answer,
>> and as most people here don't like to give short simple answers
>> which in the end don't help, they stay silent.
>>
>> You may open a web-page directly in Word,
>> which may work or may not work,
>> and save it as Word-document.
>> Documents.Open FileName:="http://mvp.support.microsoft.com/"
>>
>> But I wonder, why do you want to use VBA for this,
>> as one mouseclick in the favorites list would be enough.
>> Once you got to the page, there are a million ways to extract
>> information, but opposite to navigating to the page by VBA,
>> which is simple, but useless, extracting the information
>> you want, automatically, seems close to impossible.
>> Except you can think of a way, to define what is of interest to you.
>> So what stays, is doing it by hand.
>>
>> For my part, as I couldn't think of a more useful answer,
>> I didn't answer at all.
>>
>> Maybe there are more detailed problems left,
>> in which case it might be easier to help.
>>
>> Greetings from Bavaria, Germany
>> Helmut Weber, MVP
>> "red.sys" & chr(64) & "t-online.de"
>> Word 2002, Windows 2000
>>
>>
>>
>>
>>
>>
>
>

Relevant Pages

  • Re: Does anyone read unanswered threads?
    ... I've had zilch interaction with the web. ... I want to come to grips with Word VBA doing something slightly practical ... > Hi Steve, ... > Once you got to the page, there are a million ways to extract ...
    (microsoft.public.word.vba.beginners)
  • RE: Does anyone read unanswered threads?
    ... Once you got to the page, there are a million ways to extract ... information, but opposite to navigating to the page by VBA, ... which is simple, but useless, extracting the information ...
    (microsoft.public.word.vba.beginners)
  • VBA to extract data from 2 excels
    ... I am completely new to excel vba and still learning. ... I have 2 excels and I want to extract data using VBA based on match ... Once the match is found, I want to extract these data: ProductCode, ... ProductName & TransactionDate and output to a 3rd excel, ...
    (microsoft.public.word.vba.general)
  • Re: Right most word from a string
    ... you can then use it from a worksheet as if it were a standard function. ... By using VBA, though, you are able to do things that ... Chip Pearson has a few comments on UDFs here: ... as Excel tells me Extract isn't a function. ...
    (microsoft.public.excel)
  • Re: VBA & Web Pages
    ... using the Inet control; but I don't know if that ... control works on VBA forms... ... > PAntojee ... Prev by Date: ...
    (microsoft.public.word.vba.beginners)