opening/saving workbooks/specific paths/naming worksheets

[Lino]

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.

 

[Guest]

File Opening:
Workbooks.Open Filename:= c:foldersubfolderLino.xls

Renaming:
Sheets("SHEET1").Name = "LINO"