See if under Data menu...Import External Data...New Web Query
Not sure of the particulars but it would get you started.
Originally posted by shadowplayer
I have WebTrends web site traffic analysis running nightly on a SQL DB server. Every month, I must hit over 50 report URLs (pages use frames) to manually caputure 3 numbers into an Excel spreadsheet.
Can anyone provide any pointers how I might go about building a spreadsheet that could caputure/display this data automatically?