File Save as and pasting from clipboard in VBA macro

[sshishirkumar]

Hi
I have the following code which is pasting the same hard coded value every time (Test File.doc) instead of pasting from clipboard, Please help me change the code to pate from clipboard while renaming the file using save as.

ChangeFileOpenDirectory "C:\Documents and Settings\ssankees\Desktop\"
ActiveDocument.SaveAs2 FileName:= _
"Test File.doc", FileFormat:= _
wdFormatDocument, LockComments:=False, Password:="", AddToRecentFiles:= _
True, WritePassword:="", ReadOnlyRecommended:=False, EmbedTrueTypeFonts:= _
False, SaveNativePictureFormat:=False, SaveFormsData:=False, _
SaveAsAOCELetter:=False, CompatibilityMode:=0

[ragulduy]

I don't believe it is possible (or it is difficult) to get the data that is stored in the clipboard from VBA. Therefore you would need to paste it into a cell and then use that, for example:

Please Login or Register  to view this content.

[sshishirkumar]

Sorry, I din't mention, I am using the Macro in MS word.