Auto fill filename in “Save As” box

[akulka58]

HI All,

I have master workbook which contain two sheet “DATA” & “File format”.

I need to add new work & paste “DATA” sheet in new workbook. Delete all other blank sheets from new book.

In my master book, “File format” sheet have value in D7. D7 value should be my new workbook file name.

I want to open the 'save as' box, and have it fill in the filename based on the value in 'D7' but I DON'T want it to save (it can't save to the location where it’s opened from so it has to be saved elsewhere.)

File name should prefill in “Save As” box after that code will allow user to save file where he/she want to save the file.

Please help me in this.

[LokeshKumar]

Hey,

If you upload your sample file with the sample data....I will give you the code.....

[akulka58]

Hi,

Thanks for your reply. As requested please see attached data.

[LokeshKumar]

Hey

Here goes your code:-

Please Login or Register  to view this content.

I have inserted the code in the attached workbook..
Akulka58.xlsm

[akulka58]

Thanks Lokesh. Its works perfectly.