Solved: Auto Export cells to pop message and text file

[websailor]

Hi

I have 22 students
I create 12 cells to show the names of these students who have high degree
how I can auto export the 12 cells to text file and but them in pop message every 30 minutes?



any help...

[rbrhodes]

Hi ws,

This may help get you started. The code is from: http://www.ozgrid.com/Excel/run-macro-on-time.htm

You'll find other examples if you google "VBA ontime"

The code is in the Workbook_Open event and a standard module as explained in the link above. In my example it is set to 30 seconds.

Cheers,

dr



Cheers,

dr

[websailor]

thank you so much

please see attachments

what i can change in the module?

[rbrhodes]

Hi ws,

Did you forget the atachment?

Cheers,
dr

[websailor]

please see attachments

[rbrhodes]

Hi WebSailor,

This has the timer function in it. It displays the list from Sheet1.

There is a worksheet_change macro on sheet2 that fires whenever B1: B22 change. It displays the first 12 rows that match B24. Don't know if it's useful to you or not...

Cheers,

dr

[websailor]

Thank U so much rbrhodes

[geekgirlau]

Welcome to the Board

Don't forget to mark your thread as "Solved" once you have a solution - go to "Thread Tools" at the top of the page.

[websailor]

Done!