I have a business requirement to generate a report every X hours. The report should be in Excel and populated from data in a SQL Database. This report would then be emailed to a receipient.
I am not a programmer and I am looking for the best business solution. Any help advice would be appreciated.
I would start by looking at Get External Data and setting the Connection Properties to refresh every 120 minutes for 2 hours or whatever time interval you want.
To automate this further to include emailing you will need some code so use the macro recorder to generate it.
I don't think you will record email code,but there's plenty of code already posted.
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
I have tried to build a versatile SQL tool that works inside Excel. The name is SQL*XL and it will give you full database access from within Excel. Perhaps you want to give it a try!
SQL*XL homepage
www.oraxcel.com/projects/sqlxl
Best regards,
Gerrit-Jan Linker
Developer of SQL*XL
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks