Excel Macro to Open 2nd Workbook if criteria met

Job Description:

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 = [login to view URL]()

End If

End Sub

Habilidades: Excel, Visual Basic, Visual Basic para Apps, Processamento de dados, Arquitetura de software

Sobre o Cliente:
( 15 comentários ) Fernley, United States

ID do Projeto: #35377101

Concedido a:


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.

$10 USD em 1 dia
(0 Comentários)

45 freelancers estão ofertando em média $25 nesse trabalho


Top 1% in Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 850 + Projects. I have 6 + years of the experience in same kind of projects. If you Mais

$70 USD in 2 dias
(615 Comentários)

Hello, I am an Excel expert and I would like to help you with your macro. Please check my profile and contact me to discuss further details. Regards.

$30 USD em 1 dia
(503 Comentários)

Hello there Iam excel EXPERT level with top rating done projects before I can done this within short time also i can provide previous samples for make you understanding better about me and my skills. When do you need t Mais

$35 USD em 1 dia
(198 Comentários)

Hello, I am an Excel and VBA/Macro expert. I have read the requirements, scenario and macro you tried to create. I offer my services to help create a macro that automatically opens up another workbook based on the valu Mais

$22 USD em 1 dia
(74 Comentários)

I am an expert in Excel Formula, Advance Excel, Excel VBA, Excel Power Query, Excel Integration, Excel Macro, Excel Data Entry, Excel Data Scrapping, Excel Dashboard and API Integration, Excel financial models, Excel F Mais

$100 USD in 7 dias
(54 Comentários)

⭐⭐⭐I can start now and I am confident that I can do it ⭐⭐⭐ I have 10 years of experience in this field and I have these skills (Visual Basic for Apps, Excel, Software Architecture, Data Processingand Visual Basic) so j Mais

$20 USD in 5 dias
(49 Comentários)

I can do the job right away! my bid is 15usd (10 for me and 5usd is what freelancer takes). About me: I'm an engineer with advanced working knowledge and experience (over 15 years) in Microsoft Excel and VBA includin Mais

$15 USD em 1 dia
(49 Comentários)

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.

$50 USD em 1 dia
(26 Comentários)

--------------I CAN DO IT RIGHT AWAY--------------- ⭐⭐EXPERT IN EXCEL⭐⭐ Dear client, I can help you with your project of data entry in excel, VBA, EXCEL MACROS, VBA Scripting, building an excel file, excel dashboard, Mais

$30 USD em 1 dia
(26 Comentários)

Hi there, I have gone through the project guidelines and got a fair idea of the concept you are looking to implement. I believe I can provide you with the best quality of work and also complete the job quickly. I look Mais

$20 USD em 1 dia
(30 Comentários)

Hello Sir, I have read your instructions and I can do it efficiently. Please give me this project. i will never disappoint you regarding your work and I will give you unlimited revisions with 100% quality work. Thanks Mais

$25 USD em 1 dia
(24 Comentários)

Hi Sir. I read your requiemrent and I can do this project. I am a professional Excel VBA developer, writing advance Excel formulas, Creating customized templates to automate repetitive tasks, developing dashboard Mais

$20 USD em 1 dia
(13 Comentários)

Hi there, I´m IT professional with good knowledge and experience in excel, macros and VBA. I can help you with your project

$20 USD in 7 dias
(7 Comentários)

Hi, I have a lot of experience with data gathering,scrapping & VBA programming and Analysis. I can help you fixed this macro I am very detailed oriented with extensive data & QA skills. I also have more than 10+ expe Mais

$30 USD in 7 dias
(1 Comentário)

Hi sir/madam, I'm very active and interested to work with you. My time is up to you. You could award your project to me and enjoy it. also, I can start part of your job free of charge for example. It makes me tanksf Mais

$20 USD em 1 dia
(3 Comentários)

“I am ambitious and driven. I thrive on challenge and constantly set goals for myself, so I have something to strive towards. I am not comfortable with settling, and I am always looking for an opportunity to do better Mais

$20 USD in 7 dias
(0 Comentários)

Hello Sir, Madam, Miss My name is Nurul Shakinah. This is 3 words to describe me, punctual, creative and responsibility. I am pretty sure that I can deliver your work in time and you will like my work definitely. If Mais

$20 USD in 7 dias
(0 Comentários)

Hi , I came across your post on freelancer and I think with my working experience with VBA macro of 5 years in the past I will definitely be able to assist you with this task. Please feel free to contact me if you ar Mais

$26 USD in 5 dias
(0 Comentários)

Fairly easy and straight forward macro I will be happy to help you. We need to change your code as there is no reference on the open dialog function. The event "Worksheet change" seem ok though. let's talk in det Mais

$22 USD in 2 dias
(0 Comentários)

i, i will be able to search event and will be able to add them to your given website. if you want message to me so we can discuss more.

$20 USD in 7 dias
(0 Comentários)