Cange final file position

Please Login or Register  to view this content.

CURRENTLY I AM USING THE ABOVE CODE WHICH CREATS THE FINAL.TXT FILE IN FOLDER DEPUTY IN C DRIVE

BUT NOW I WANT TO CHANGE MY CODE SO THAT IN THE SAME FOLDER,WHEREVER I HAVE MY EXCEL FILE THE FINAL.TXT FILE SHOULD BE CREATED

WHEN EVER I RUN THE MACRO OLD FINAL.TXT FILE SHOULD BE REPLACE BY NEW FINAL.TXT WITH A MSG THAT YOUR FINAL FILE HAS BEEN CREATED IN THE SAME FOLDER.

PLZ HELP I WILL BE GREATFUL.

Hi Roshan,

Check out below:

Please Login or Register  to view this content.

And what about msg

Very nice working..one more help on this issue

can in place of final.txt

a file name can also be customize

like i want to have it like


code_etds_new_date (in the file name only the code and date will change)

in the above when i run the above macro of saving file it should ask me your br code after entering br code it should ask date

an when we enter date in dd/mm/yyyy
fomat it sholud should give a file like in the above format...

For ex if i gave it br code as 4534 and date as 12/03/2103

the file which need to be save with the name 4534_etds_new_12mar13

plz help me in this sir ..

I will be highly obliged...

Its a tiny job for you sir.but will be a great help for me...

Is it possible sir..

OH I AM SORRY FOR THAT BUT SEE MY ANXITY AND CURIOUSNESS AND UNDERSTAND SIR...

YOUR CODE IS HELPFUL BUT AND THE END AFTER ENTERING CODE AND DATE ERROR MSG COMES

TYPE MISSMATCH AND HIGHLIGHTS THE LINE strSave = UCase(ThisWorkbook.Path & "\" & strInputCode & "_etds_new_" & Format(DateValue(strInputDate), "ddmmmyy"))

IN THE CODE

PLZ SEE AND HELP SIR

Oh wow no problem its done sir

my fault i have put the date in wrong format

got that mistake

many many many thanks to you for this help