98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Macro's
Macro's
Resolved · Urgent Priority · Version 2003
Chris has attended:
Excel Advanced course
Macro's
can you run macros's on a timer to access web sites and run through a login proceedure before importing data from a table
RE: macro's
Hi Chris
Thank you for your question
It might be possible to set up a macro to run based on the timer object in visual basic. It is difficult to be precise here as there are a variety of variiables and it depends on the context in which you working.
It is certainly possible to run a macro when a certain event occures (e.g. when you one a workbook). this simply requires you to set the macro in the on open event of the workbook in question.
This however requires a good knowledge of VBA
Regards
Stephen
Mon 23 Mar 2009: Automatically marked as resolved.
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:Adding up rows or columns without seeing formulasHighlight a column or row and click the Autosum button. This gives you your answer without showing the formula. |