Thanks for your help! After some tweaking, I finally got it to work.
Don
>Don,
>The best available technique for the exporting memo fields (at least that I've found) is the code in
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q241424 - "HOWTO: Export Memo Fields with Other Field Types to a Text File (Q241424)". You could then have Excel import the text file.
>
>Rick
>
>>Is there any way to "export to/copy to" the contents of Memo fields to type XL5? or any other available format?
>>
>>If so, please show me how or where I can find out how. I need this ASAP.
>>
>>I would appreciate any help with this.
>>
>>Thanks in advance!
>>
>>Don