I need to get the Lid State of open or closed for a project am working on to let elderly person know to open their laptop to see reminders.
Can anyone point me to code that will check internal laptop Lid state?
Thanks.
I need to get the Lid State of open or closed for a project am working on to let elderly person know to open their laptop to see reminders.
Can anyone point me to code that will check internal laptop Lid state?
Thanks.
Maybe I am missing something here but does the lid not need to be up and the computer switched on with Excel being the current program open with a way to activate a popup to give you a message?
Experience trumps academics every day of the week and twice on Sunday.
@jolivanes, in the "Power options" of Windows under the item "Choose what closing the lid does" you can choose "Do nothing" so Excel could be left running with the lid closed. Excel can produce sounds and if you have an operating external display you can also see what's going on. OP doesn't say if he has an external display so I suppose that he could make Excel beep and hopefully, if elderly don't have hearing problems, have them open the lid to see reminders. He could even have Excel send emails on their smartphones as reminders.
Last edited by rollis13; 01-26-2023 at 03:30 AM.
If you can detect that the lid is closed then you can send a text message. Of course, you can just send a text message anyway whether the lid is open or not. It will still show up in two places.
One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.
A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
I am actually looking for VBA code or an API call to other code that can pass into an existing VBA macro that is running
I need to send text-to-speech to let the person know to "open the laptop lid" if they close it so that they will
see reminders set for them at specific times.
This is a project for elderly in assisted living whos memories are failing.
So It is not about what to do when Lid is closed such as power settings, but code that will be able to do
Text to speech to say open lid.
If you know of code that can do this, I would greatly appreciate it if you could paste in post.
Thank you.
No idea how to test if lid is closed but for the speech you could use something like this:Please Login or Register to view this content.
@ rollis13.
Wow, another example that we're never too old too learn. Thank you very much.
I already have the speech down/
I did find a way however. I found code using AutoHotKey that I can call to do the check. And it works amazingly. So thank you all for trying. Unless you know of VBA code that can do the same, I am good for now.
thanks much.
If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."
If a member helped you solve your problem, consider adding to their reputation by clicking http://www.seiglefamily.com/excel/ad...niconsmall.jpg below their name.
If you solved your own problem, please provide your solution so that somebody seeing this thread in a search for the same problem will see how it was solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks