View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
arno arno is offline
external usenet poster
 
Posts: 184
Default Saving a file with a name from a cell value.

Hi,


I need to write a macro that when executed, will save a file with the name

taken from the value of a specific cell in that spreadsheet.

you should have a cell named "myName" to make this line work:

ActiveWorkbook.SaveAs Filename:=Range("myName").Value

bye

arno