Copy file And Rename it Using An Input BOx

[HaroonSid]

hello evryone
i m using this code for 2nd coping my file and rename it automatically......

Please Login or Register  to view this content.

i want when i want another copy always my path should be "C:\test\abc.xlsm"
and
for new file in same path "C:\test\def.xlsm" an input box ask for the name("def.xlsm") "what new name u want for this new file"

and i input the new name for my file and done

thanx plz help

[HaHoBe]

Hi, haroon2015,

this will only accept the name of the new file and not the extension:

Please Login or Register  to view this content.

You would need to alter the code if you want to include the extension as well in order to give the file the proper fileformat (look for the last dot by using InStrRev and using Ifs or a Select Case to get the proper fileformat).

Ciao,
Holger

[HaroonSid]

Excellent : HaHoBe

it's working as i need

thanx a lot
haroon2015

[HaroonSid]

when run this code

Please Login or Register  to view this content.

+ then run this code after above code... i mean merge both code in once macro file...plz need more help from u

Please Login or Register  to view this content.

thanx a lot

[HaroonSid]

Please Login or Register  to view this content.

HaHoBe i combine these two macro and it's working as i need

but its asking for two time
first time inputbox "What new name do you want for the new file?"
second time
Application.GetOpenFilename

if possible then i want inputbox "What new name do you want for the new file?" and done both work in one click
thanx