Hi
I have been coding an excel sheet which will simplify the management and data entry for a wiki site.
The front page contains various sections of 8 items which i plan to change on a semi-regular basis.
Things like a random list of 8 pages, easily coded.
Newest entries, same again.
And such forth.
I have also got a list which is for the 8 most visited pages, of which the only way I have been able to find the information is on the bottom of each page itself, which states:-
This page has been accessed **** times.
Now.. I have set up a sheet which calculates the URL based on the name of the worksheet it is looking for, runs a web query for that URL, imports the data to the front page management sheet, searches for the line which states "this page....." etc (which is in a different position on each page, depending on what information is on the page), extracts the number, and inserts it into the appropriate cell.
In other words, it works.
However, I only have maybe 50 pages in my wiki right now, and with time this will stretch into the 1000's and up, so obviously, this method is a little slow right now, with having to do 50 separate web queries just to find one piece of information (takes maybe 5 mins - which right now as I only plan on updating once a week), but once I am into the 1000's of web queries this will take a long time, so I was wondering if anyone could help with any suggestions, tips, or useful tidbits of information to pre-empt my future hassles.
The coding I use thus far is as follows:
Thanks
Bookmarks