Hi All,
I need to be able to save an excel spreadsheet with a name that exists in a cell - for example A1.
My excel VBA knowledge isnt too hot, but I can assign a macro to a button that raises a file-save-as dialogue box, but it doesnt save the file.
Anyone know how to do this?
TIA
My test code:
fileSaveName = Application.GetSaveAsFilename(Workbooks("Book1").Sheets("Sheet1").Range("A1"))