opening/saving workbooks/specific paths/naming worksheets

Lino · Feb 28th, 2002, 09:40 AM

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.

Mar 1st, 2002, 09:43 AM

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

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

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

Feb 28th, 2002, 09:40 AM	#1
Lino Board Regular Join Date: Feb 2002 Posts: 429	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.

Mar 1st, 2002, 09:43 AM	#2
Guest Posts: n/a	File Opening: Workbooks.Open Filename:= c:foldersubfolderLino.xls Renaming: Sheets("SHEET1").Name = "LINO"