Macro Autorun in the open excel file

[DomelAAA]

Hi All

i am looking for code which allow to run continuously every 5 minutes on the file, which is always open.

What have is:

Please Login or Register  to view this content.

What should be added/ changed to make it run all the time, without opening/ closing the file.

Thx

[Greg M]

Hi there,

See if the following code does what you need:

Please Login or Register  to view this content.

The highlighted values may be altered to suit your requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M

[DomelAAA]

Hi

i just checked your code, but unfortunetly this code not allow to do macro in a loop - continiously, every determine time ( ex. 30 sec )

[Greg M]

Hi again,

If you add the highlighted line to the code posted previously, you will find that the time is printed to the VBE Immediate Window each time the routine is executed - for testing purposes I used a msTIME_INTERVAL value of "00:00:02" to have the time printed every two seconds until the StopProcess routine is executed manually.

Please Login or Register  to view this content.

Hope this helps,

Greg M

[DomelAAA]

Hi

thank You , its working great!

one question, this will run all time or it will be stopped after "x" times?

[Greg M]

Hi again,

The process will run until either you exit from the Excel application or you manually run the "StopProcess" routine.

Regards,

Greg M

[KOKOSEK]

to avoid autoreopening I suggest to add:

Please Login or Register  to view this content.