Problem - Conflicts with simple Excel VBA code for pasting object

[wideeyedguy]

With CHS running in the background - when I try to run a simple VBA code to paste an object into an Excel worksheet, I get an error message pointing to one line of code - ActiveSheet.Paste.



This macro has been working perfectly for several months now, but after installing CHS, it now fails. After I Quit CHS from running the macro will execute just fine as before.

I've been experimenting with CHS to see how I can incorporate in to my work flow, but this will be the killer for me being able to use this utility.

Can you help?

weg

[mouser]

I think i remember this coming up beore.. doesn't anyone remember if we figured out what the problem was caused by and any workaround?

If you tell CHS to ignore capturing from exce (Capture Options tab), does that fix it?

[wideeyedguy]

If you tell CHS to ignore capturing from exce (Capture Options tab), does that fix it?

-mouser (November 02, 2011, 08:42 AM)

That appears to allow the paste action (macro) to work in Excel. But, of course, now CHS will not
capture copy clips from within Excel. Not good since I use Excel 80% of my work time.

Thoughts?

weg

[mouser]

i wonder if CHS is stopping further clipboard processing when it shouldn't..

anyone have experience with other clipboard tools -- does excel freak out with all of them?

[mouser]

See if you can find some option in excel to disable some "Office Clipboard" functionality or something similar.  It's so typical that *microsoft* does non-standard things that break their software from working properly with other programs.

[rgdot]

Some versions of office have 'Paste Special' (Edit--->Paste Special). Might be worth a look at its options.

[Ampa]

For me it is FARR (with KlipKeeper) that freaks out Excel.

I frequently get "The Clipboard cannot be emptied. Another program might be using the Clipboard".

I hit OK and the copy paste (or drag and drop) usually seems to work anyway... but it is a frustration none the less!