Save

Kevin Cooze · Feb 22nd, 2002, 02:36 AM

Is there a procedure to use a cell content as a filename?
eg cell d3 contains 'Kevin' which I'd like saved as an automated filename = kevin.xls

dk · Feb 22nd, 2002, 03:55 AM

Hi,

Here are two examples:-

'Save it in current folder
ActiveWorkbook.SaveAs Sheets("Sheet1").Range("D3").Value

'or save it in a stated folder
ActiveWorkbook.SaveAs "C:temp" & Sheets("Sheet1").Range("D3").Value

HTH,
D

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 22nd, 2002, 02:36 AM	#1
Kevin Cooze New Member Join Date: Feb 2002 Posts: 1	Is there a procedure to use a cell content as a filename? eg cell d3 contains 'Kevin' which I'd like saved as an automated filename = kevin.xls

Feb 22nd, 2002, 03:55 AM	#2
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	Hi, Here are two examples:- 'Save it in current folder ActiveWorkbook.SaveAs Sheets("Sheet1").Range("D3").Value 'or save it in a stated folder ActiveWorkbook.SaveAs "C:temp" & Sheets("Sheet1").Range("D3").Value HTH, D