Can't Copy and Paste generated password, to encrypt Workbook

[ViniTaylor]

Thanks for taking the time to read this thread, I am new to the site and although I have searched on here, I can't find an answer to my question.

I have a 'Formula Generator' in excel that generates a 14 digit Password in a cell. I want to be able to copy this directly from Excel and paste in to the Encryption section of Microsoft documents. Unfortunately, this is pasting the formula rather than the result, and I don't want to have to 'Paste Special' in to a separate document and then Copy and Paste in to the Encryption section.

Is there anything that can be done to allow this to be copied and pasted from the original 'Generator'?

Many thanks in advance for all your help, and here's hoping...

 

[RoryA]

Welcome to the forum.

You could use a macro like this assigned to a shortcut key:

Public Sub CopyCellValue()
   Dim objData           As Object
   Set objData = GetObject("New:{1C3B4210-F441-11CE-B9EA-00AA006B1A69}")

   With objData
      .SetText ActiveCell.Value2
      .PutInClipboard
   End With

End Sub

 

[ViniTaylor]

Thanks so much RoryA for your quick response. I have to admit, I've never ventured in to the realm of VBA, but there's no time like the present. I'll give it a go..

Thanks again.