View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
William[_2_] William[_2_] is offline
external usenet poster
 
Posts: 227
Default Program workbook title as the filename

Hi Guy

ActiveWorkbook.Title = ActiveWorkbook.Name

--
XL2002
Regards

William



"Guy Pelletier" wrote in message
...
| Howdy,
| I would like to know how to program the workbook title as the saved
filename. I am using the title in SharePoint 2003, and would like it to
reflect the saved filename of the spreadsheet.
|
| Thanks
|
| Guy Pelletier