When I Run This Macro Then Prompt A ("Workbook Name") Option Box

DEAR RESPECTED SIR need ur help

When I Run This Macro I Want To Prompt A MsgBox or Option Box Who Asked For Choose The File Name ( workbook name ) Option
and then copy data range from active worksheet to workbook name
in this code source workbook name is ("5.3.14") and destination workbook name is ("6.3.14")
i want always prompt a box who asked for destination workbook name and then copy data to new workbook name

Please Login or Register  to view this content.

check such proposition:

Please Login or Register  to view this content.

hey thanx for reply Kaper

i m getting this error :
Capture.JPG

i m using ms office 2013 with .xlsm

and where i want to paste data the sheet name is "Entry"

Change here:

Please Login or Register  to view this content.

or attach a sample (not real data of course) workbooks to test with.

PS. Note my message - especially about editing CapsLocked title look into your http://www.excelforum.com/private.php?folderid=0