Excel Macro to Open 2nd Workbook if criteria met
Budget: $10 – $30 USD
I am using excel2016. I am trying to develop a macro that automatically opens up another workbook based on the value of a particular cell. Imagine we are conducting scenario 1, scores range from t1 through t4. If the assessed party receives t3 to t4, that is a failure and they need to do scenario 2. Immediately another workbook should pop up but the workbook should not contain any of the values the assessors entered
I need help creating a macro that both opens a file using and detects a change in specific cells.
This is what I have so far but it doesn't work.
Private Sub Worksheet_Change(ByVal Target As Range)
If Range("a2").Value = “t3” Or _
If Range("a2").Value = “t4” Then
Sub vba_open_dialog()
Dim strFile As String
strFile = Application.GetOpenFilename()
End If
End Sub
I need help creating a macro that both opens a file using and detects a change in specific cells.
This is what I have so far but it doesn't work.
Private Sub Worksheet_Change(ByVal Target As Range)
If Range("a2").Value = “t3” Or _
If Range("a2").Value = “t4” Then
Sub vba_open_dialog()
Dim strFile As String
strFile = Application.GetOpenFilename()
End If
End Sub