View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
ward376 ward376 is offline
external usenet poster
 
Posts: 360
Default Save as saves selected worksheet instead of whole workbook


You told it

With ActiveWorkbook.Worksheets("sheet1")
uname = .Range("B2").Value & " " & _
.Range("B3").Value
End With
ThisWorkbook.SaveAs ThisWorkbook.Name _
& " " & " " & uname & ".xls"
ActiveWorkbook.Close True
End Sub

?

Just save it as "Personal.xls"

In your XLStart folder

"C:\Documents and Settings\YourName\Application
Data\Microsoft\Excel\XLSTART\PERSONAL.XLS"