Alternatively - would it be possible to define what the Excel document is picking up in the form of an Excel Web Query? If so then you might could create your excel document with a web query and place it in a shared drive once and it would update itself when you opened the document. [I say that without ever having worked with web queries however so I don't know their limitations] james c. -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Joshua Olson Sent: Monday, March 06, 2006 9:26 AM To: thelist at lists.evolt.org Subject: Re: [thelist] DTS Task > -----Original Message----- > From: Rob Smith > Sent: Monday, March 06, 2006 9:16 AM > > I can set the time frame of the query to look at the past seven days. > It would be ideal to tell DTS to go to a web page and capture the > output into an excel document, then put that on the shared drive. All > I'd have to do is retrieve the document. > > > > Can this be done? And how?