PDA

View Full Version : Solved: Auto Export cells to pop message and text file



websailor
06-22-2007, 07:04 AM
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
06-22-2007, 01:20 PM
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
06-22-2007, 11:55 PM
thank you so much

please see attachments

what i can change in the module?

rbrhodes
06-23-2007, 12:16 PM
Hi ws,

Did you forget the atachment?

Cheers,
dr

websailor
06-24-2007, 08:41 AM
please see attachments

rbrhodes
06-24-2007, 05:03 PM
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
06-26-2007, 05:12 PM
Thank U so much rbrhodes

geekgirlau
06-26-2007, 05:38 PM
Welcome to the Board :hi:

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
06-29-2007, 08:23 PM
Done!