Command button to save workbook with filename data from 2 cells??

Your problem is quite simple.

Excel reads "15/02/2016" as Folder 15, Sub folder 02, Sub Sub folder 2016.

So try:-

With Sheets("Sheet1").
ActiveWorkbook.SaveAs Filename:="\\defthw9000osto.ww002.net\WTS-redirect$\FlexSm\.WW002\Desktop\Daily Work\" &.Range("A1").Value & " " & Format(.Range("B1"), "hh:mm") & " " & Range("A1").Value = Replace(Format(.Range("B1"), "dd/mm/yyyy"), "/", "-")

'I need to use Sheets("Sheet1).  followed by a cell reference three times, so instead a declare that everything starting with a "." is preceeded by Sheets("Sheet1")

With Sheets("Sheet1").

'other wise this:
ActiveWorkbook.SaveAs Filename:="\\defthw9000osto.ww002.net\WTS-redirect$\FlexSm\.WW002\Desktop\Daily Work\" &.Range("A1").Value & " " & Format(.Range("B1"), "hh:mm") & " " & Range("A1").Value = Replace(Format(.Range("B1"), "dd/mm/yyyy"), "/", "-")

'Would be:-

ActiveWorkbook.SaveAs Filename:="\\defthw9000osto.ww002.net\WTS-redirect$\FlexSm\.WW002\Desktop\Daily Work\" & Sheets("Sheet1").Range("A1").Value & " " & Format(Sheets("Sheet1").Range("B1"), "hh:mm") & " " & Range("A1").Value = Replace(Format(Sheets("Sheet1").Range("B1"), "dd/mm/yyyy"), "/", "-")

' I separate the time from B1 and format it using Format(Sheets("Sheet1").Range("B1"), "hh:mm")

'I separate the Date from B1 and format it using Format(Sheets("Sheet1").Range("B1"), "dd/mm/yyyy")

'I  then change the two "/"s in the date with "-" using Replace(Format(Sheets("Sheet1").Range("B1"), "dd/mm/yyyy"), "/", "-")

Hi mehmetcik,

Thanks for your help so far but I think we have crossed wires?

What I was originally trying to achieve was to save a workbook with the file name "Status Sheet" but also need to identify it with the time & date (Time in A1 cell & date in B1 cell) I need to save this file twice a day the first time it will be called - Status Sheet 0500 16022016 and the next time I update cell A1 with the time 1530 and resave it hopefully as - Status Sheet 1530 16022016

I originally wanted to save this file on a network drive but think I would be better off saving it to the current location it is in! If this is possible?

Thanks