File Save As

S

sohaibj

Board Regular
Joined
Jan 28, 2004
Messages
158
I ve a file and 10 names are written from A1:A10.
I just want to save this file with the different names written in A1:A10.
Please tell me the VBA procedure to do it.
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
Sort by date Sort by votes
Perhaps like this

Code: 
Sub SaveMe()
For i = 1 To 10
    ActiveWorkbook.SaveAs Filename:=Range("A" & i).Value
Next i
End Sub
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Solved
Place in cell
Replies
4
Views
204
Silverwolph
S
D
  • Solved
Vba excel protection save as and copying
Replies
8
Views
347
Wookiee
Wookiee
T
  • Question Question
Automatically Copying Data To A New Workbook When Closing A Workbook
Replies
4
Views
468
Tmini
T
T
  • Question Question
Save As Dialog Box with File Name Predetermined for Ppt file through Excel
2
Replies
10
Views
213
tbakbradley
T
J
  • Solved
VB help please - Save as pdf in specific folder
Replies
2
Views
186
JV0710
J

Forum statistics

Threads
1,224,600
Messages
6,179,836
Members
452,947
Latest member
Gerry_F

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top