Skip to content

Instantly share code, notes, and snippets.

@rohinomiya

rohinomiya/SetText.vb

Created December 20, 2012 14:04
Show Gist options
  • Save rohinomiya/4345474 to your computer and use it in GitHub Desktop.
Save rohinomiya/4345474 to your computer and use it in GitHub Desktop.
Download ZIP
Excel VBA から、クリップボードにテキストをセットする ref: http://qiita.com/items/1b719bc90d7497688699
Raw
SetText.vb
Dim CB as Object
Set CB = new DataObject
With CB
.SetText "セットしたい文字列"
.PutInClipboard 'クリップボードに反映する
End With
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment