SaveAs based of user input.

[kokapelly]

Morning All,

I have this moace that does a great job of creating dated folders and saving reports with names and dates..... If they are run "Daily"..

I am looking to enhance this maco to allow the user to input the date where they would like the file saved. So as an example if i ran todays report the below code works great.. but if i forgot to run yesterdays report and wanted to run it today it would save as todays date and in this case i want the user to be able to input the date in case it is not todays date.

Here is my macro:

Please Login or Register  to view this content.

Also if anyone has suggestion to make this code better i am always up for improvements..

[xlbiznes]

Hi,

Why don't you try changing this line of code :

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[kokapelly]

Hi,

Close the file did save with the correct fileName (EUC560-A-11-01-2013, but went into December's folder.

[xlbiznes]

Hi,

Post the new code and let me have a look as the folder name is being derived from this code of yours :

Please Login or Register  to view this content.

[kokapelly]

Here is the new code:

Please Login or Register  to view this content.

[xlbiznes]

Ok,

Here is your full updated code.

Please Login or Register  to view this content.

[kokapelly]

LOL that worked and darn i was thinking i had to make some changes to the (Now) on stryear