Thread: saving a worksheet using a macro
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default saving a worksheet using a macro
Hi

I want to save worksheets using data from a cell

You can change this example
http://www.rondebruin.nl/copy6.htm

replace the save line with this one

Wb.SaveAs FolderName _
& "\" & Wb.Sheets(1).Range("B1").Value & ".xls"


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Sparky AKA_Sparkticus" wrote in message k...
I want to save worksheets using data from a cell

12108(12-06-06) i would like to auto save using macro to select the data
in cell b1 mark(12-06-06) is this possible?

I tried but it used the same data as when i set up the macro each time not
the data that was in the cell at the time.

Sparkyman





Reply With QuoteReply With Quote