Hi ,

I am using VBA to display a form and let the user enter the data into
excel sheet. I have text box with the customer name. I would like to
save the file using the customer name. So if my customer is James
Bond
I would like the file saved to be as JamesBond.xls

Can anybody help me with this

Appreciate your help


Suhas