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
Dim strFile As String
strFile = [login to view URL]()
I think you are trying to create an interactive test of some way. Try adding [login to view URL] (strFile) after GetOpenFilename. Reach out if you need to debug together. I'd love helping you.
45 freelancers are bidding on average $25 for this job
Hello, I'm a former CP (competitive programming) competitor, I'm a master at algorithms and could help you solve your problem quickly with clean, optimized and well-commented code.