Hi Guys - thanks for all the input. I will certainly have a look at the auto refresh on open of the excel as I believe RS won't be installed...

Jim, James - thanks for your replies.

This is a long standing process - and they have always done the refresh and email out of the refreshed spreadsheet from this section.

Govt...

Hi - I have tried to access the code for this utility but the site doesn't find it - has this been pulled?

If so can anyone suggest where I can...

thanks for your replies - I had already recommended reporting services as the best solution but for political - NOT technical reasons I am forced to try and kluge something...

thanks for your reply.

I didn't want to use the access app anymore and trying to replace it with an SSIS built solution.

Essentially I have a bunch of sql scripts that...