Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default How have text on clipboard reformatted as a cell would be put there?

If I select a cell, and copy, it goes to the clipboard differently than if I
select the text from the formula bar. (I know, formatting gets included).
My problem is, I have an external application that can not paste unless it is
in the format of a copied cell !!!

So, how can I convert a text only entry on the clipboard to one that looks like
it was copied as a cell?

I'd like to do this in VB.


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default How have text on clipboard reformatted as a cell would be put there?

You can't unless you put it in a cell and copy it.

--
Regards,
Tom Ogilvy

"RandyDtg1" wrote in message
...
If I select a cell, and copy, it goes to the clipboard differently than if

I
select the text from the formula bar. (I know, formatting gets included).
My problem is, I have an external application that can not paste unless it

is
in the format of a copied cell !!!

So, how can I convert a text only entry on the clipboard to one that looks

like
it was copied as a cell?

I'd like to do this in VB.




  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default How have text on clipboard reformatted as a cell would be put there?

Is there a way to manipulate the clipboard to do this?

I want to make text that was copied, look like a cell copied to the clipboard.
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default How have text on clipboard reformatted as a cell would be put there?

Sorry I wasn't clear. No, you can not do this.

--
Regards,
Tom Ogilvy

"RandyDtg1" wrote in message
...
Is there a way to manipulate the clipboard to do this?

I want to make text that was copied, look like a cell copied to the

clipboard.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Clipboard empty but still get waring that clipboard is full Steve Excel Discussion (Misc queries) 0 June 17th 08 09:05 PM
Excel data reformatted in Word mailmerge [email protected] Links and Linking in Excel 2 August 16th 06 11:18 PM
Pasting from clipboard-how to control text-to-columns delimiting stebro Excel Discussion (Misc queries) 1 June 15th 05 05:31 PM
How can I format text pased directly from clipboard to appear in correct cells pbase[_2_] Excel Programming 1 October 4th 03 11:57 PM
Copying the text from a text box to the clipboard TonyJeffs Excel Programming 1 August 31st 03 07:48 PM


All times are GMT +1. The time now is 10:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"