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

  • Thread starter Thread starter alsameer
  • Start date Start date
A

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
 
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
Click to expand...
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
 
Back
Top