In this sequence where would I put the directory/path
Workbooks.Open Filename:=Lino
I am guessing saving to a specific path will be the same.
Next question:
Once I add a workbook
Workbooks.Add
I would like to name sheet 1 "Lino"
how would I do that ?
Thanks for the help.
File Opening:
Workbooks.Open Filename:= c:foldersubfolderLino.xls
Renaming:
Sheets("SHEET1").Name = "LINO"
Like this thread? Share it with others