ATTENTION: You are viewing a page formatted for mobile devices; to view the full web page, click HERE.

DonationCoder.com Software > Clipboard Help+Spell

Problem - Conflicts with simple Excel VBA code for pasting object

(1/2) > >>

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)
--- End quote ---
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.

Navigation

[0] Message Index

[#] Next page

Go to full version