Does anyone read unanswered threads?

[Steve]

I posted the following on the 26th and have been trying to elicit a response
using the same thread with a new title. I'm getting frustrated waiting for a
reaction. Have I done something wrong?

Hi

I read a blog that provides a lot of useful information for programming. I'd
like to get it all into a word document so I can summarise and outline some
of the tips and remove the information of low interest.

I'm a newbie to Word VBA but have good experience in Excel and Access VBA. I
have no idea how to navigate to a web page and copy the content of the page
using VBA but the rest should not present too much of a challenge. Your
guidance would be appreciated but, I'd rather not have a lazy solution.

Steve

 

[Jonathan West]

I posted the following on the 26th and have been trying to elicit a
response using the same thread with a new title. I'm getting frustrated
waiting for a reaction. Have I done something wrong?

No, you have just been trying to get a response over a weekend. The MVPs and
others who answer here are all unpaid volunteers. Sometimes it takes a
while, and sometimes we just don't know the answer.

Hi

I read a blog that provides a lot of useful information for programming.
I'd
like to get it all into a word document so I can summarise and outline
some
of the tips and remove the information of low interest.

I'm a newbie to Word VBA but have good experience in Excel and Access VBA.
I
have no idea how to navigate to a web page and copy the content of the
page
using VBA but the rest should not present too much of a challenge. Your
guidance would be appreciated but, I'd rather not have a lazy solution.

I'm not sure why you would want to use VBA to copy the content of the page.
Copy & paste the text into a Word document using the clipboard in the
ordinary way, and then for any code snippets you want to experiment with,
press Alt-F11 to open the VBA editor, and paste into a module.

 

[Doug Robbins]

What's wrong with just manually copying and pasting?

--
Please respond to the Newsgroup for the benefit of others who may be
interested. Questions sent directly to me will only be answered on a paid
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

 

[Helmut Weber]

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

 

[Steve]

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

 

[Jezebel]

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]

Hi Jezebel,
If I'm reading you correctly, you saying its not just a simple matter of
copy/paste. I'd need to work out what is text and what references there are
to any bitmaps, table, etc. and locate these and work out how to include
them in the document.

Thanks to a VB code library, I can now write the HTML from a web page to a
document. The first page currently has 1507 lines and includes numerous
bjects and links. I see what you mean about the fun starting!! I'm not I can
stand that much fun just yet <g>.

Steve

 

[Greg]

I don't know, but there are few number of threads that I have answered
but didn't read ;-)