What Reference do I need? 1

[GoDawgs]

Ok, feel a little silly here, but I'm setting up an automatic email for which I've found tons of great code and think I have it all set up...one problem...I need to create a variable and dim it as DataObject, only problem is the libraries that I'm referencing don't have that option, just wondering what library I need to reference...hope that makes sense. Thanks for the help.

Kevin

 

[GoDawgs]

Little more info in case I'm just going about this wrong...basically I have an automatic email set up and working. I have data in Excel that I am copying up to the clipboard, and now I want to paste it into the body of the email...so I'm using a variable to grab that data (since I can't seem to just paste to the body)...and the variable i've seen used elsewhere is dimmed as DataObject, which I cannot do right now. Any help?

 

[rmikesmith]

Kevin,

The DataObject object is part of the Microsoft Forms Object Library. If you are using Excel, this library should be loaded automatically. Keep in mind you need to assign your DataObject variable as well as declare it. Ex:

Dim MyData as DataObject
...
Set MyData = New DataObject

HTH
M. Smith

 

[GoDawgs]

I don't have Microsoft Forms Object Library, that seems to be my problem...I have VBA, Excel, OLE, and Outlook referenced right now, but don't have a reference for that library to choose from...thanks for you help so far.

 

[rmikesmith]

Kevin,

I'm using Microsoft Forms 2.0 Object Library, which is contained in fm20.dll. Here is a link to Microsoft's information regarding installation/distribution:

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q224305

HTH
Mike

 

[GoDawgs]

Thanks a lot Mike, that's all I needed, I had the file, just didn't have it in the list of possible references.

Kevin