WOW!!
Thanks Strongm, you're the best :)
------------------------------------
[yinyang] Over 35 years of programming, and still learning every day! [yinyang]
Unfortunately, I'm not finding any way in VBA to work with the clipboard like VB6 can.... Hoping someone here has that expertise :)
------------------------------------
[yinyang] Over 35 years of programming, and still learning every day! [yinyang]
strongm, you prompted me to dig out my old notes on the process... you're right, that wasn't the method... I used this:
Microsoft Windows Image Acquisition Library v2.0 (wiaaut.dll)
FPATH = "C:\test.bmp"
Dim picfile As New WIA.ImageFile
Dim picprocess As New WIA.ImageProcess
Set picfile = New...
I've done this before in VB6, but is there a way in Excel VBA to screencapture the userform (already know how to do this), then save the image in the clipboard to a JPG file?
I recall that in VB6 if was a simple as sending the image to a picturebox control from the clipboard, then saving the...
I have looked at the event viewer, but nothing was logged. The first reference to anything amiss was the log notation about the unexpected shutdown, and it just said when it happened, but no details
------------------------------------
[yinyang] Over 35 years of programming, and still learning...
Being a bit of a novice at building PCs, I'm wondering of I can get some advice... I have a custom built PC that is powering down at random times, then won't power back on until being unplugged the plugged back in. Is there a diagnostic tool that anyone could recommend that logs activity...
THAT DID THE TRICK WONDERFULLY!!!!!!!!!
Working like a charm now, fully tested and good to go [medal] [medal] [medal] [medal] [medal]
Thanks a ton Strongm!
------------------------------------
[yinyang] Over 35 years of programming, and still learning every day! [yinyang]
Thanks Strongm, I will give it a try when I get back to work tomorrow! This evening it's a fine cigar and a smattering of scotch for this old cat.
And you mentioned not having VB6 on your Win10 machine...I recently stumbled upon this article about installing our beloved editor in the new OS,in...
Strongm, your code example worked like a charm in Win10!!! Thank you!
Well.... hold on... after experimentation I learn that even though it appears to be working, there's problems...
I set up a test script to monitor the function every 5 seconds to see if the screen was locked or not, write a...
Good suggestion, however the program minimizes to the taskbar onLoad and stays out of the users way. I really wanted it to be as unobtrusive as possible. So, it would rarely, if ever, get a mouseover event. Again, good thought tho!
Strongm, your code example worked like a charm in Win10...
It's a sign in/out program to help operators know when folks are in their office and out. If they leave their desk, they either log off/restart or lock their screens. My program is good at catching the Unload event and logging the person as OUT, but if they lock their screens, then there IS no...
Ok, I found a snippet of code that works in Windows 7 when the screen is locked..... but it won't work in Windows 10. Any suggestions?
Option Explicit
Public Const DESKTOP_CREATEMENU = &H4&
Public Const DESKTOP_CREATEWINDOW = &H2&
Public Const...
Thanks for the reply Strongm! Sorry, I didn't see this until just now. The unload event was perfect... now one more good one... IS there a way to detect when users lock their session? As opposed to logging off or restarting/shutting down, we have some that just lock their screens, so my program...
thread222-1243704
Could someone give me a code example of this? Needing my exe to log when a user logged off / shut windows down at XX date/time, but not sure how to code the event trigger....
Thanks :)
------------------------------------
[yinyang] Over 35 years of programming, and still...
Oh, I agree dgillz..... however, I have NO control over our networking, so I'm trying to find a way for my software to compensate. I suspect there's traps and catches that I could be using in the code that would make my program a little more dependable in a bad environment...
Ok, first of all, I'm a self-taught programmer, so if I'm asking questions that make some of you go "DUH!", please forgive an old man. Evidently I know some, but just not enough to overcome some issues, and am hoping y'all can help.
Here's the situation. I've got a simple logging application...
DISREGARD THIS ISSUE!
Found what was happening, and it was just an old programmer having cranial flatulence. My error trap was calling a separate sub that did a screen capture. I had recently also added a bug catcher in THAT sub, so one On Error was cancelling the values captured by the source...
I've NEVER encountered this issue before in all the years that I've been programming VB6, but all of a sudden, all my error handlers are giving up nadda information on error reporting.
Typically, Err.Description provides just that, the descriptive text of the error encountered. Erl returns the...
Strongm, you are mah hero (insert southern accent and a big smacker!)
That worked like a charm. I tweaked the code using your suggestions, and was even able to get the Word dialog spellcheck to pop up, while the word window minimized ;)
'Create a new instance of word Application
Set...
Just to clarify, this project is a Visual Studios 6 project, not a Word VBA script, so yes, I have to create a word object to copy text to to invoke the word spellcheck function.
Unless there's another method for spellchecking textbox contents, I'm stuck with utilizing a word.application...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.