Hi,
I am trying to process the contents of the clipboard with a macro, but I run the default macro and it just returns "before text......after text" and hasn't seen the contents of the clipboard.

If I run Clipview, by Peter Buettner, then it shows the clipboard as having only one format of type "50347: CxCellData" with the content that I want (see attached screenshot). Using Clipview I can also paste in new clipboard data into that format and paste back into the application if I get the structure absolutely correct. The data is essentially ASCII but includes a lot of ESC CHAR(@27) characters, and from my testing it is very sensitive to trailing CRLFs (it throws an error, or locks up the application completely if I paste in data that's not quite right)

I am looking for an application where I can script changes to the clipboard contents, and have tried Java's clipboard access methods but they fail to find the data in a format that it can return (I have even put it into Debug mode and stepped through the Java internal libraries, but the OS interface seems to simply discard this data as it doesn't understand the format).

I believe that the application I am trying to interact with is written in VB.

Is it possible to use ClipboardFusion to read and write data into the format "50347: CxCellData" ?

Or do you have any pointers as to how I could go about this?

Thanks

Unfortunately you won't be able to test the app itself, but you can simulate it under Windows using ClipView (see URL below).

In ClipView, in the Content window just type some characters (for example, "abc") then in the box next to "Push in Clip" type "CxCellData", and then click on "Push in Clip". The clipboard will then contain data that is similar to this application.

Once you have done this, you can run any macro in ClipboardFusion, but it sees the clipboard as being empty.

Note that I will also need to write back to the clipboard in format CxCellData for this to work.

ClipView can be found at http://www.peterbuettner.de/develop/tools/clipview/

Yes, that works. The macro grabs the application's data and puts it into the clipboard as text.

Is there any way to write data back to the clipboard in the same format? Is there a Clipboard.PutDataObject(data, format) that I could use to write back the modified data?

Also, is there any documentation on these function calls? I was unable to find GetDataObject() on your website.

Thanks

That didn't quite work.

It doesn't insert it into the clipboard with type "CxCellData", instead it puts it in as "49161: DataObject" and "49171: Ole Private Data"

I have tried the unmodified macro and all I get in the clipboard is "49161: DataObject" and "49171: Ole Private Data"

I have just downloaded ClipboardFusion again from your website and reinstalled, just to make sure I am using the latest version, and the behaviour is the same.

FYI, I am running Windows 7 64 bit, and a quick check through "Programs and Features" shows Microsoft .NET Framework 4 is installed.

1) I copy "abc" into the clipboard before I run the macro.

2) I use "ClipView" to check the clipboard, it shows formats 1, 7 and 13 - each containing "abc", and format 16 with other data.

3) I run the macro you provided, unmodified, using a hot-key. ClipboardFusion reports "Macro run successfully"

4) ClipView then shows two formats
49161: DataObject. - Raw data size 8 Bytes
49171: Ole Private Data. - Raw data size 18 Bytes
ClipView doesn't show anything when I try to look at the contents of these formats. I don't understand why.

I was expecting ClipView to show a format CxCellData, as it does when I copy the data from the original application.