MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Help part 2 - (thanks Dank)

Posted by Kevin Rowe on November 15, 2001 6:59 AM

what you told me earlier was close to what i needede - but that renames the current workbook - what i need is to create a new one so that i can then rename that new workbook

The variable method didnt seem to work - it did open a new file but it kept naming it .xls for some reason.

Thanks Guys

Kevin Rowe

Posted by Dank on November 15, 2001 7:39 AM

Kevin - try this. It will create a new workbook and rename it to the value in cell A1.

ActiveWorkbook.SaveAs Filename:="U:\95krowe\" & ValueInA1