98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel course - Macros
microsoft excel course - Macros
Resolved · Low Priority · Version Standard
Tue 30 Jan 2007, 09:53Delegate Alasdair said...
Alasdair has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Macros
Would I be able to use a macro to create automated reports in Excel from SQL queries already created within a database or even to query directly from the SQL database?
Tue 30 Jan 2007, 11:23Trainer Richard said...
RE: Macros
You can automated practically anything with a macro, provided that you are able to do the manual steps yourself. You can automate pieces of the process that do not change. If you are always importing the same, albeit updated, dataset, then no problems.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Conditional formatting for cells that return text , not picked up by Go to commandIf you have tried to format all cells containing text even those that display text as a result of a formula you may have had difficulty. As Go to command with constant selected does not pick up formulas that result in text. |
