View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Eric Bragas[_2_] Eric Bragas[_2_] is offline
external usenet poster
 
Posts: 9
Default Looking for best method to automate monthly Excel report

Hi Mike,

Your idea was my original idea--just coding the whole thing in an
Excel template. But in fact a better way to do it would be to create
a stored procedure on the SQL Server that takes the parameters and
does the query itself and just passes data back out. I like the Excel
way--it sounds fun, as I am a VB developer but don't have extensive
experience in Excel development--but it unfortunately won't be the
fastest way, and doesn't give the other DBA's an opportunity to
maintain it.

Thanks for your input. You definitely answered my question, and I'll
probably be using your suggested method in the near future on other
projects.

Sincerely,
Eric