Clear Clipboard Contents

[santosm]

Hi All,
Is there a way to clear the clipboard contents using VBA? I don't want to turn it off, I only want to clear what is currently located there.

Thanks,
Mark

[HansV]

Select Tools | References...
Click Browse...
Type FM20.DLL in the Filename box.
Click OK.

You can now use code like this:

Code: Select all

Sub ClearClipboard()
    Dim objData As New MSForms.DataObject
    objData.SetText ""
    objData.PutInClipboard
    Set objData = Nothing
End Sub

[santosm]

Hi Hans,
So cool! Do you have any handy code that will grab a screen capture of the active window? The code I mentioned earlier is not as reliable as I would like.

Thanks,
Mark

[HansV]

I'm afraid not - the code that you posted is the "standard" way to perform a screen capture in VBA.

[santosm]

Sometimes when I execute the code, I get a RTE 7, out of memory. I am not sure what this is really telling me.

[santosm]

Hi Hans,
Looking at this standard code, is there an option to save as JPEG instead of BMP???

Thanks,
Mark

[santosm]

HI Hans,
Looking at my code, I see why I can't grab the active msgbox window. I click OK before copying to the clipboard, hence the msgbox is closed. I will instead capture the form name, module, etc and store that in a table.

Mark

[BenCasey]

Hi Hans,
Looking at this standard code, is there an option to save as JPEG instead of BMP???

Thanks,
Mark

You may care to look at this http://www.utteraccess.com/forum/lofive ... 48262.html

[santosm]

Thanks Ben,
That code is exactly what I am using and it seems to work OK sometimes, but I am still getting a lot of RTE 7 (out of memory) when the clipboard is first empty and it gets to the line where it wants to save the file. If I run in break mode, it always works.

Thanks,
Mark

[BenCasey]

Thanks Ben,
That code is exactly what I am using and it seems to work OK sometimes, but I am still getting a lot of RTE 7 (out of memory) when the clipboard is first empty and it gets to the line where it wants to save the file. If I run in break mode, it always works.

Thanks,
Mark

You might try loading the clipboard with some stuff when you first start and then see if it still fails when invoked.