On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.
Sub SaveFileToWDrive() Dim FName As String ' FName = "W:\Holland\rrw5\Bruce Shortage Report " FName = FName & Format(Date, "ddmmmyy") & ".xlsx" 'ChDir "W:\Holland\rrw5" ActiveWorkbook.SaveAs Filename:= _ FName, FileFormat:= _ xlOpenXMLWorkbook, CreateBackup:=False ActiveWorkbook.Close MsgBox ("File Saved to " & FName) End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Accidentally deleted Outlook data files. I restored from recycly bin, but Outlook can't find the files now.||12||139|
|excel file icon - over last few months weird||2||27|
|How to set correct rule in Outlook 2013/2016||1||28|
|Office 365 Controls||3||23|
Join the community of 500,000 technology professionals and ask your questions.