Completed

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

Skills: Excel, Visual Basic, Visual Basic for Apps, Data Processing, Software Architecture

About the Client:
( 15 reviews ) Fernley, United States

Project ID: #35377101

Awarded to:

Mohammed8Essam

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 in 1 day
(0 Reviews)
0.0

45 freelancers are bidding on average $25 for this job

schoudhary1553

Top 1% in Freelancer.com 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 More

$70 USD in 2 days
(615 Reviews)
8.5
P0L

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 in 1 day
(503 Reviews)
8.0
PERPETUAL0

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 More

$35 USD in 1 day
(198 Reviews)
6.1
hamidr2020

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 More

$22 USD in 1 day
(74 Reviews)
6.0
ShakeelASESE

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 More

$100 USD in 7 days
(54 Reviews)
5.9
konanhenry1111

⭐⭐⭐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 More

$20 USD in 5 days
(49 Reviews)
5.4
ielucerotrad1

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 More

$15 USD in 1 day
(49 Reviews)
5.5
iamhamzazaki

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 in 1 day
(26 Reviews)
4.7
rahulg5466

--------------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, More

$30 USD in 1 day
(26 Reviews)
4.5
jojimathew571

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 More

$20 USD in 1 day
(30 Reviews)
4.0
umairnoor32

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 More

$25 USD in 1 day
(24 Reviews)
3.4
NANSAMEERA86

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 More

$20 USD in 1 day
(13 Reviews)
3.2
rvlb94

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 days
(7 Reviews)
2.5
egomezl56

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 More

$30 USD in 7 days
(1 Review)
1.7
Nosratabouhamzeh

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 More

$20 USD in 1 day
(3 Reviews)
1.7
upenderverma800

“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 More

$20 USD in 7 days
(0 Reviews)
0.0
ShaakinahNs

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 More

$20 USD in 7 days
(0 Reviews)
0.0
anshuman225

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 More

$26 USD in 5 days
(0 Reviews)
0.0
paulobara

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 More

$22 USD in 2 days
(0 Reviews)
0.0
royallyf

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 days
(0 Reviews)
0.0