Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / November 2005

Tip: Looking for answers? Try searching our database.

Append range to document

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Merijn Vandenabeele - 15 Nov 2005 14:13 GMT
Hi,

I want to append the content of a range to a document, including all
formatting. The problem is I can't use the clipboard for this. Can this be
done and how?

Merijn
Jonathan West - 15 Nov 2005 15:49 GMT
> Hi,
>
[quoted text clipped - 3 lines]
>
> Merijn

Hi Merijn,

Yes, look up the FormattedText property in the VBA Help. There are code
samples there for what you need to do.

Signature

Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org

Tony Jollans - 15 Nov 2005 16:02 GMT
It ought to be _possible_ but it wouldn't be easy - I think  you would need
to check for all possible formats and apply them individually to the pasted
range. Why can't you use the clipboard?

What might be possible (depending on exactly what your situation is) with
Word 2000 (though AFAIK not with later versions as the Task Pane seems off
limits to normal VBA) would be some manipulation of the Office clipboard as
a temporary holding area for what's on the Windows clipboard.

--
Enjoy,
Tony

> Hi,
>
[quoted text clipped - 3 lines]
>
> Merijn
Merijn Vandenabeele - 16 Nov 2005 06:58 GMT
Thanks Jonathan and Tony,

seems like FormattedText was the way to go.

Best regards,
Merijn

> It ought to be _possible_ but it wouldn't be easy - I think  you would
> need
[quoted text clipped - 20 lines]
>>
>> Merijn

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.