ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Program workbook title as the filename (https://www.excelbanter.com/excel-programming/300253-re-program-workbook-title-filename.html)

William[_2_]
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


All times are GMT +1. The time now is 10:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com