VBA code to save excel sheet

  • Thread starter Thread starter KKurse
  • Start date Start date
K

KKurse

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
 
This will work if JamesBond is in cell A1 if not replace A1 with what you need

Sub Test
If Range("A1").Value = "" Then End
ActiveWorkbook.SaveAs Filename: = Range("A1").Value
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Help with copying a sheet from One workbook to another workbook 1
Excel 2003 save as .XLSX 10
Excel VBA 0
Importing any excel files with any sheet name into different tables in MSAccess using code 0
How do I copy some cells(including formatting) and save as image fileusing VBA? 1
VBA to automatically cut, paste entire row based on date input and delete row 0
How do you do the following using VBA macro automatically? 1

Back
Top