Hi all,
I am doing a excel macro which convert big txt file to excel. But each
time it is asking for this confirmation.

<<< There is a large amount of information on clipboard, Do you want to
be able to paste this information into another program later?

So if the macro is running I need to sit with this to press "Yes".
Do any one know any property so that I can give Yes always to this for
pasting it later.

Thanks in advance
Sameer


--
alsameer
------------------------------------------------------------------------
alsameer's Profile: http://www.excelforum.com/member.php...o&userid=24041
View this thread: http://www.excelforum.com/showthread...hreadid=376517

On Sat, 4 Jun 2005 at 05:54:49, alsameer (alsameer
) wrote:

Hi all,
I am doing a excel macro which convert big txt file to excel. But each
time it is asking for this confirmation.

<<< There is a large amount of information on clipboard, Do you want to
be able to paste this information into another program later?

So if the macro is running I need to sit with this to press "Yes".
Do any one know any property so that I can give Yes always to this for
pasting it later.

Thanks in advance
Sameer


Do you need the contents of the clipboard once excel has done its work.
If not, you could always clear it with something like

Copy2Clip ""

Sub Copy2Clip(psString As String)

Dim goClipboard As DataObject


Set goClipboard = New DataObject
goClipboard.SetText psString
goClipboard.PutInClipboard

End Sub
--
Mike