Macro not copying to Clipboard

[jomili]

For years I've been using an "indent to clipboard" macro from https://en.wikibooks.org/wiki/Visual..._Code_Indenter

In recent months it's stopped working for me. Or rather, it may be working, because it says it is, but it's not, because when I paste instead of my indented code I get two Ascii symbols.

I had a similar result to putting data in the clipboard on this post: https://www.excelforum.com/excel-pro...ml#post5589918
But I don't know how to alter the "Indent" macro to apply that solution.

[6StringJazzer]

I just tried that code and also got ?? as the result. I will look at it further but it is a s***load of code.

[jomili]

Yep, it's a lot. But I notice, just like in the other post I reference, if I close Windows Explorer the code works right, so it's in the part of the code where it copies to the clipboard.

BTW, heading home now, won't be back until Monday, so I hope A) you practice Thanksgiving and B) You enjoy your Thanksgiving.

[scottiex]

I tried the code and it indented my code nicely (thanks this could be useful).
does it fail for you on any code? even a simple one?

I think I do remember getting "??" (box around the '?' i think) when running some simple code to populate clipboards and that it was working on some computers and not others.
(at the time I just bypassed it by populating a sheet and copying it out again thus filling my clipboard)

*Edit : for what it is worth - my explorer is open both file and internet as well as chrome and Firefox.

[jomili]

yep, any code, as long as Explorer is open. Closed, it works fine.

[scottiex]

is it on any page that it is open?

does ie have programmatic access to your clipboard in the security settings?

[rorya]

It's a long standing bug with the dataobject (started with Win8). Use API calls instead to put the text in the clipboard.

[Artik]

Recently, I came across a cool solution that does not require Win API. Instead it uses the Microsoft HTML Object Library which is fast and ubiquitous.

Please Login or Register  to view this content.

Artik

[rorya]

I'd suggest making the argument a Variant, not String. I've seen issues with that method otherwise - see for example this thread: https://www.excelforum.com/excel-pro...clipboard.html

IMO, the API route is safer.

[Artik]

I'd suggest making the argument a Variant, not String.

Note that the argument is later assigned to the variable of type Variant.

IMO, the API route is safer.

For now, I like the API-free solution. But time will verify that.

Artik

[rorya]

Note that the argument is later assigned to the variable of type Variant.

I confess I overlooked that. Seems like an unnecessary step when you could just make the input a variant?

[Artik]

I am not the author of this function, so I do not know exactly what the author had in mind that the argument was of the String type. From what I can see, the JScriptTypeInfo object clearly expects text. I did a little experiment changing the argument type to Variant. When I passed a number to the function, I got the error: -2147352319 - Method 'setData' of object 'JScriptTypeInfo' failed. And this is probably the main reason the argument is of the String type. However, the Variant type used later is probably supposed to support the 64-bit version of Office.

Artik

[jomili]

Artik,
Thanks for the function, but I need help in figuring out how to plug it into the bigger macro. Can you help?

[achammar]

Just my 2 cents worth... but I have had some trouble with using the clipboard in VBA if my clipboard app in Windows 10 is turned on. It keeps a record of everything that you copy to the clipboard, so if you have that turned on, maybe it's messing up somehow when the code changes what is in the clipboard.

[JEC.]

This is how you put stuff in your clipboard

Please Login or Register  to view this content.

[rorya]

This is how you put stuff in your clipboard

That uses the dataobject which has the bug that started this thread…

[Artik]

Jomili,

Please Login or Register  to view this content.

Artik

[JEC.]

It is but this uses late binding. Should give it a try

[rorya]

The binding context makes no difference to the bug, I'm afraid. It's still the DataObject after all.