Variant or String maximum size

Michel Demers

Hi,

I need to copy the clipboard content to a text file. For this I do something as follow:

Dim paste as String
paste = clipboard.gettext
If paste <> "" Then
Open "\sever\Num\" & UserName$ & "\list.txt" For Output Access Write As #1
Print # 1 , paste
End If

I receive the following error message due to size limit of variable type string, same with variant, except that I do not get an
error but it only takes about half of my clipboard content.
Error 14: "Out of string space" has occurred on line 78.

Any work around to suggest please?

Thanks!