View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
James Cox[_2_] James Cox[_2_] is offline
external usenet poster
 
Posts: 39
Default PublishObjects To A String?

We're using PublishObject to generate a htm file from an Excel, that we are
then opening and converting that htm file to a text string to be used as the
..bodyHTML of an Outlook note.

Has anyone figured out a way to specify that the .Filename property of
PublishObjects should somehow be directed to a in-memory object that can
contain the html text string so the write / read of the html file can be
avoided?

Thanks for any insights on this!

James Cox