Create Toolbar to Save As cell A1 1

[scottie1]

I'm trying to save a spreadsheet with the same name as cell A1. The macro needs to be attached to a toolbar though as constantly using new workbooks.

 

[Loomah]

Hi Scottie1
Not sure what you're after so if this isn't it you may need to post some more info

This will save the active workbook to a set directory, giving it the name of any text that is in cell A1

ChDir "C:/temp" 'set save path
ActiveWorkbook.SaveAs Worksheets(1).Range("A1").Text

As I say, if this isn't what you need post back with a little more detail.

;-)

If a man says something and there are no women there to hear him, is he still wrong?
The faqs ma'am, just the faqs. Get the best from these forums : faq222-2244

 

[scottie1]

Thats exactly what I wanted

Thanks very much I will now look like a miracle worker.