Personal_Macro_Workbook_to_Clipboard.vba 302 B

1234567891011
  1. Sub Personal_Macro_Workbook_to_Clipboard()
  2. Dim myData As DataObject
  3. Dim Output As String
  4. Output = Application.StartupPath + "\Personal.xlsb"
  5. Set myData = New DataObject
  6. myData.SetText Output
  7. myData.PutInClipboard
  8. MsgBox Output, vbOKOnly, "Personal Macro Workbook"
  9. End Sub