Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails
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
|Populate data based on a criteria||2||17|
|Use cell value to specify decimal places in Excel||9||14|
|VBA copy certain excel sheets & paste them as values in different new workbooks in .xls version||12||22|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
12 Experts available now in Live!