MOSS2007: Create a Hyperlink to SharePoint List Export to Spreadsheet

From http://weblogs.asp.net/wkriebel/archive/2005/08/22/LinkToExportToSpreadsheet.aspx:
How To Create a Hyperlink to SharePoint’s List Export to Spreadsheet
Published Monday, August 22, 2005 1:27 PM
Because you can’t copy the hyperlink on the “Export to spreadsheet” link on SharePoint lists, here is how you can create your own hyperlink.
http://[Server]/[Site]/([Subsite]/)_vti_bin/owssvr.dll?CS=109&Using=_layouts/query.iqy&List=[ListGUID]&View=[ViewGUID]&CacheControl=1
Replace the [Placeholders] with your environment’s information.
A handy way to get the list and view [...]

Read Full Post »