Need 'save clipboard' property of 'Open file' function.

[alsameer]

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

 

[Mike NG]

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