Saving
I am looking to have a workbook save using the name on a worksheet called
"title" using cell a:24 as the name. I also would like this to save to the desktop. How would I do this please Greg |
Saving
Activeworkbook.SaveAs "C:\Documents and Settings\user\Desktop\" & Range("A24").Value & ".xls" replace user with your user name or even ALl Users. -- HTH RP (remove nothere from the email address if mailing direct) "Greg B" wrote in message ... I am looking to have a workbook save using the name on a worksheet called "title" using cell a:24 as the name. I also would like this to save to the desktop. How would I do this please Greg |
Saving
Thanks Bob,
All users was the best option. as it may not be used on my p.c. Thanks again\ Greg "Bob Phillips" wrote in message ... Activeworkbook.SaveAs "C:\Documents and Settings\user\Desktop\" & Range("A24").Value & ".xls" replace user with your user name or even ALl Users. -- HTH RP (remove nothere from the email address if mailing direct) "Greg B" wrote in message ... I am looking to have a workbook save using the name on a worksheet called "title" using cell a:24 as the name. I also would like this to save to the desktop. How would I do this please Greg |
All times are GMT +1. The time now is 06:17 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com