Excel Dynamic Workbook Saving As 1

[Adnane]

Hi,

what i'm trying to have is to get the customer's name (entered by the user in a form) ang save the workbook as "FileName_CustomerName.xls" where the FileName doesn't change and it's always saved in the same location.

Regards,

Adnane

Micorosft North Africa

http://www.microsoft.com/northafrica

 

[TonyJollans]

Hi Adnane,

This will prompt the user and save the workbook:

Dim CustomerName As String
CustomerName = InputBox("Enter Customer Name")
ActiveWorkbook.SaveAs "C:\FileName_" & CustomerName & ".xls"

If you already have your Form then you could put the SaveAs in code behind the form or a button on the form or the textbox where the name is entered. Come back if you want something more specific along those lines.

Enjoy,
Tony

 

[Adnane]

Hey Tony, it works perfectly. i don't were my error was!!
Anyways, thanks a lot. it really helps me.

Please accept a star from me.



Adnane

Micorosft North Africa

http://www.microsoft.com/northafrica