I have a list of jobs (jobs schedule) to do... and they are required to be done in a by certain different dates regularly.
I have a specific jobs date for each task held in a colu. Is there anyway i can make it to automatically send an email to remind me or another person a day before it's due??
Another question - I have a basic dashboard when a job is overdue I want the cell to flash RED
Not sure what you mean --- put it on click or on close of a form vs. on open or close of the application vs. scheduled to run as a vb object outside of Access?
lika2know
Whether you run a macro (which you will have to run to make it happen, but you can arrange to have it run every time you open the spreadsheet) or just use VBA, you will nonetheless have to open the spreadsheet in order to call the function - code only executes when it is called, and that can't happen unless the spreadsheet is open.
As for your second question, see this link: http://www.mrexcel.com/tip054.shtml
A VBS script can be used to accomplish this. The workbook will need to be opened by the script in order to read the data but all of this can be done in the background without ever needing to display the hidden workbook.
.. this is doing just what Rollin is talking about. At least the solution I posted there (on the first page) is.
HTH
Status
Not open for further replies.
You have insufficient privileges to reply here.
Related Threads
?
?
?
?
?
Tech Support Guy
9.9M posts
859.7K members
Since 1998
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!