I need to know how to open a new workbook and then rename the workbook?
P pokdbz Dec 26, 2007 #3 Sorry was trying to write VBA code for this. I have Workbooks.Add but I cannot figure out how to rename the open Workbook.
Sorry was trying to write VBA code for this. I have Workbooks.Add but I cannot figure out how to rename the open Workbook.
D Dave Peterson Dec 26, 2007 #4 Workbooks are "renamed" by saving them. So you'll have to use something like: dim NewWkbk as workbook set newwkbk = workbooks.add newwkbk.saveas filename:="C:\whateveryouwanthere.xls", _ fileformat:=xlworkbooknormal
Workbooks are "renamed" by saving them. So you'll have to use something like: dim NewWkbk as workbook set newwkbk = workbooks.add newwkbk.saveas filename:="C:\whateveryouwanthere.xls", _ fileformat:=xlworkbooknormal
