Need help with Excel macro issue

[LordRaiden]

Hi all. Ok, here's what I want. I need to take the values of several labels in a form and export that to the windows clipboard. Problem. Excel apparently won't let me export to the windows clipboard via the macro in any way I can find. Only its own internal clipboards.

I'm needing to know the simplest way to export text data from a variable in my excel macro to the windows clipboard using an excel macro. Thanks.

The data itself is being pulled from several labels in a form and needs to be exported to the clipboard so it can be pasted into an email and several other locations outside of excel. Much apreciated and many thanks for the help.

 

[LordRaiden]

*Bump*

Still looking for an answer to this. Anybody know anything? IF someone knows anyone from MS can you please bug them too so I can possibly get an answer to this? I'm writing the macro using Excel 2000.

 

[NeoV]

post your macro, I'll try to help out...

you can also send email from a macro if that helps...

 

[LordRaiden]

Well all I have left to finish is just a simple copy and paste feature. So the rest of the macro is fine. What I need to do I'm hoping will only take a couple of lines to do.

All I need to do is copy the text from a variable into the windows clipboard. My problem so far is all I have been able to find is options to copy to the excel clipboards. But I'm wanting to copy to the windows clipboard. Thanks again for your help.