I searched quite a bit, but can't find the answer to my problem. I want to copy all the files from a folder to memory or clipboard and paste it manually wherever I like to paste it.

the codes that I have found, all have a destination folder. How can i achieve this?

thanks 

Sub CopyFile()

    Dim fso As Object

    Set fso = CreateObject("Scripting.FileSystemObject")

    fso.CopyFile "S:\PDF_Jobs\" & ComboBox1 & "\" & ComboBox2 & "\" & ComboBox3 & "\", DESTINATION FOLDER

    Set fso = Nothing

End Sub