Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.
Sub ActivateWB() Dim UseDate As Date Select Case Weekday(Now) Case 1, 4, 5, 6, 7 UseDate = Date - 2 Case Else UseDate = Date - 4 End Select Windows("UnmatchedReport_GL_8455_56_57_" & Format(UseDate, "yyyymmdd") & _ "_TLM2.xls.xls").Activate End Sub
|Don't Convert Time to Time-of-Day in Mail Merge||2||22|
|populate Excel dropdown via ADO and VBA||6||15|
|VBA – How to copy a cell from one page and enter it into a new line on another page while selecting where the new line is added?||7||19|
|Unhide very hidden sheets with password||22||41|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
11 Experts available now in Live!