Re: Word VBA and Web Pages

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: John (johnnyb_cool_at_hotmail.com)
Date: 01/13/05 

Date: Thu, 13 Jan 2005 08:35:22 -0000

Malcolm

My apologies for my part in that misunderstanding, and thanks for the
pointers
thus far.

Yes, I'd like a few more if you don't mind...

I've got the UserForm now with a WebBrowser control and a TextBox... not so
sure how to link the last two or Navigate to the URL.

-John

"Malcolm Smith" <malcolm.smith@DragAndDrop.com> wrote in message
news:memo.20050111160645.5520H@mksmith.aits-uk.net...
> John
>
> Actually I am no longer actively looking for VBA work these days as I am
> having more fun earning money by other means. What I meant was that if
> you got stuck for a developer then I'd leap into the breach but I am
> trying to limit my VBA consultancy significantly.
>
> You could have a form with the WebBrowser control and use that to get the
> web page and when the DocumentComplete() event is raised then you can get
> hold of the HTML code and then parse that.
>
> Alternatively you could use the INet control to grab the web page and,
> again, you parse the HTML.
>
> If you need any more pointers then let me know and I will add more
> pointers.
>
> - Malc
> www.dragondrop.com
>
>
> In article <#RHPGN$9EHA.1564@TK2MSFTNGP09.phx.gbl>,
> johnnyb_cool@hotmail.com (John) wrote:
>
> > *From:* "John" <johnnyb_cool@hotmail.com>
> > *Date:* Tue, 11 Jan 2005 15:35:46 -0000
> >
> > Hi Malcom
> >
> > Well, thanks for the confirmation that I'm not mad in trying to do it,
> > and
> > that
> > it can be done... but as for paying you to do it, that wouldn't be half
> > as
> > much
> > fun as doing it myself.
> >
> > I appreciate the time though & wish you the best of luck with browsing
> > newsgroups for paying customers. Hope that works out for you.
> >
> > Meantime, if you wouldn't mind, or if anyone else wants to chime in,
> > a high level overview of the steps to be taken would be great!
> >
> > Thanks,
> >
> > -John
> >
> > "Malcolm Smith" <malcolm.smith@DragAndDrop.com> wrote in message
> > news:memo.20050111150941.5520F@mksmith.aits-uk.net...
> > > John
> > >
> > > Yes it can be done. It will need some amount of bespoke VBA
> > > development
> > > and it could take a couple of days to write as you have to parse the
> > > web
> > > page and pull down the stuff that you want.
> > >
> > > Now, bear in mind that the web site could move, change shape or
> > > whatever
> > > so the parser may break.
> > >
> > > If you want someone to do this then find your local and friendly VBA
> > > developer or drop me a mail via my website.
> > >
> > > - Malc
> > > www.dragondrop.com
> > >
> > >
> > > In article <#5vrSa#9EHA.3840@tk2msftngp13.phx.gbl>,
> > > johnnyb_cool@hotmail.com (John) wrote:
> > >
> > > > *From:* "John" <johnnyb_cool@hotmail.com>
> > > > *Date:* Tue, 11 Jan 2005 14:04:51 -0000
> > > >
> > > > Hi,
> > > >
> > > > I have a question I can't even figure out how to approach... any
> > > > ideas
> > > > would
> > > > be helpful.
> > > >
> > > > I've got a letter that I write every week based on the contents of
> > > > several
> > > > web pages.
> > > >
> > > > The letter is in Word.
> > > >
> > > > Is there any way to use VBA to have Word automatically go & get the
> > > > information off the website? I'm not claiming that the information
> > > > is
> > > > mine... in fact I give full credit where credit is due, so there's
> > > > no
> > > > copyright violations... I just want my secretary to be able to push
> > > > a
> > > > button
> > > > & then collect the letter from the printer.
> > > >
> > > > It's just that I can't figure out how to get Word 2000 to get the
> > > > info
> > > > from
> > > > a web page... or even pull the info from a web page into a
> > > > document. I
> > > > know
> > > > if I go to IE and save the web page to a file, I can go from
> > > > there...
> > > > but
> > > > that's too many steps. I'm looking for the one (or maybe two?)
> > > > button(s)
> > > > solution.
> > > >
> > > > Maybe it can't be done... but there's some other way? VB perhaps?
> > > > Some
> > > > third
> > > > party product?
> > > >
> > > > If anyone has any suggestions, that'd be great...
> > > >
> > > > Cheers,
> > > >
> > > > John
> > > >
> > > >
> > > >
> > >
> >
> >
> >
>

Relevant Pages

  • Re: Forget Hardy
    ... I've seen lots and lots of very noob questions. ... seen RTFM answers on this list that were not accompanied with pointers ... initiator of this thread comes to mind.) ... expect to learn the terminology of that subject. ...
    (Ubuntu)
  • Binomial distribution property -- proof needed
    ... I've tried showing that the sum from 0 to n-1 has to be smaller than ... to mind whenever they come to mind. ... any pointers? ... that I can simply include in the references, ...
    (sci.math)
  • Re: REFERENCES REVEALED
    ... > int main ... that the same is not true of pointers. ... address of that object with that label. ... It's good that you have something in mind that gives you a better ...
    (comp.lang.cpp)
  • Re: BASEBALL TALK ONLY!
    ... Thanks Dano and Oceanview for the pointers; ... occasionally reading the drivel OTs. ... A few pointers come to mind though. ...
    (alt.sports.baseball.bos-redsox)
  • How do I cut parts from a text file
    ... I am new to Python and need to parse a text file and cut parts out i.e. say ... Any advice or pointers of where to find more info would be greatly ... RiGGa ...
    (comp.lang.python)