vba save

Hello, I am trying to get a workbook to save using a command button so I can get a weekly log of what has changed in the spreadsheet. I need the "master" spreadsheet to save AND a separate workbook saving with the filename of the date it was saved...I can't get the first bit to work, so it...

What i ultimatly want to achive is that i save the active workbook under the name of the date today in the path i choose. I wrote a little code for that, that partly helped me. the code is as follows: Sub save() Dim location As String location = ThisWorkbook.Path ChDir location & "\History"...

Hi, I'd like to be able to save all Charts in a sheet with their Chart Title as their name, for some reason this is proving more difficult than expected. I believe it's the Title = part of the code that needs to be changed. Any help would be appreciated. Code: Sub ExportSheetCharts()...

Hi guys I hope you can help as I have been scratching my head a bit! I have code which opens, updates, saves then closes two different work books. I already have used the below snip to stop the screen flicker but i also want to stop the saving file dialog from appearing. This is to prevent...