Hi AlexeyY,
Welcome to the Forum!
I put them all in the same folder as the calling routine - hope that works
Sub AlexeyY(): Dim r As Long, N As String
For r = 1 To Rows.Find("*", , , , xlByRows, xlPrevious).Row
If Cells(r, 1) <> "" Then
N = Cells(r, 1): Workbooks.Add
ActiveWorkbook.SaveAs ThisWorkbook.path & "\" & N
ActiveWorkbook.Close: End If
Next r: End Sub
If you haven't used macros before you'll need to go to:
File- options - trust center -trust center settings - macro settings ,
the second option down (disable all macros with notification)
Then - Copy the code to the clipboard
Open your Workbook
Press ALT + F11 to open the Visual Basic Editor.
Select "Module" from the Insert menu
Type "Option Explicit" then paste the code under it
With the cursor between Sub and End Sub press F5 (F8 to Single Step)
OR
Press ALT + Q to close the code window.
Press ALT + F8 then double click on the macro name
*Be sure to save the book with the code as Macro-Enabled
Bookmarks