Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

macros

ResolvedVersion 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.

Excel tip:

Brighten up your Excel 2010 Spreadsheet by changing the colours of the gridlines

Excel 2010 allows you to change the colour of grid lines instead of keeping them in boring black.

Select the File tab on the Ribbon, click Options, click Advanced, scroll down to ''Display options for this worksheet.'' Next to ''Gridline colour,'' choose your favourite colour, then once you've done this, click OK. Easy!

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.