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

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

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