K
Keith R
We have a server-side database that includes BLOBs of MS word documents.
Some of those documents have always been available via URL hyperlinks on an
intranet web page. We've asked the administrator to expose a new group of
documents from that database, although the links to those newly exposed
documents won't be built into the existing web interface (they should still
be available via individual intranet URLs).
As the first step in a new project, I'd like to scrape all of those document
URLs. I assume it would be something like a recursive tree search, since
there is a heirarchical order of the documents in the existing web
interface- so for example,
/WPSAC/1-1000/356/356.doc
/WPSAC/1-1000/781/781.doc
/WPSAC/1001-2000/2294/2294.doc
/WPSAC/1001-2000/2770-2790/specials/2776.doc
/WPSAC/Revised/single_entry/B438.doc
etc.
I haven't worked with web stuff at all (although I'm decent with VBA)- any
pointers on where to start, to build a list in Excel where each sequential
cell contains a link to the next word document?
My next step on the project will be to build a user interface so a user can
select a document number and have it automatically load the link, but I need
to get the links themselves first.
Thanks!
Keith
Some of those documents have always been available via URL hyperlinks on an
intranet web page. We've asked the administrator to expose a new group of
documents from that database, although the links to those newly exposed
documents won't be built into the existing web interface (they should still
be available via individual intranet URLs).
As the first step in a new project, I'd like to scrape all of those document
URLs. I assume it would be something like a recursive tree search, since
there is a heirarchical order of the documents in the existing web
interface- so for example,
/WPSAC/1-1000/356/356.doc
/WPSAC/1-1000/781/781.doc
/WPSAC/1001-2000/2294/2294.doc
/WPSAC/1001-2000/2770-2790/specials/2776.doc
/WPSAC/Revised/single_entry/B438.doc
etc.
I haven't worked with web stuff at all (although I'm decent with VBA)- any
pointers on where to start, to build a list in Excel where each sequential
cell contains a link to the next word document?
My next step on the project will be to build a user interface so a user can
select a document number and have it automatically load the link, but I need
to get the links themselves first.
Thanks!
Keith