Need some help/advice... "Woad" <owner[ at ]threeravensconsulting.com> 13.12.2005 17:55:32 My VBA skills are a bit rusty, so I am not sure how to go about this. What I want to do is create an .iqy file that will load a multipage spreadsheet from several different pages. The first page is a summary with a listing of the students and a few other data items. The student's names are links to individual worksheets that contain items specific to them. Is there any way to do this using the web query model in excel and programattically driving the individual pages. Currently, these reports are using the ecel object via asp and this is dogging our server down, so we want to push some of the processing out to the client. I plan on doing this via ColdFusion pages pumping out he data from queries into tables for the web queries. Any help is greatly appreciated. Thaks in advance. Eric