View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
papou
 
Posts: n/a
Default Saving files with a list of values

Hello Sergio
This is possible using VBA.
Here is a sample code to achieve this :
With Worksheets("Sheet1")'***
For i = 1 to .Range("A65536").End(xlup).row '***
Thisworkbook.SaveAs .Cells(i,1) '***
Next i
End With

(***please amend accordingly)
HTH
Cordially
Pascal