Find Jobs
Hire Freelancers

Excel Macro to Open 2nd Workbook if criteria met

$10-30 USD

Terminado
Publicado hace más de 1 año

$10-30 USD

Pagado a la entrega
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
ID del proyecto: 35377101

Información sobre el proyecto

44 propuestas
Proyecto remoto
Activo hace 1 año

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
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 en 1 día
5,0 (3 comentarios)
2,0
2,0
44 freelancers están ofertando un promedio de $26 USD por este trabajo
Avatar del usuario
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 are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion.. Thank you Sandeep
$70 USD en 2 días
4,9 (620 comentarios)
8,6
8,6
Avatar del usuario
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 en 1 día
5,0 (504 comentarios)
8,0
8,0
Avatar del usuario
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 this finished? I understand how annoying it is and can get this fixed for you quickly! Please see the sample I fixed. I look forward to working on this project with you. Regards
$35 USD en 1 día
4,9 (206 comentarios)
6,2
6,2
Avatar del usuario
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 value of a particular cell. You can check my reviews for quality of work and client satisfaction. Looking forward to working with you. Thanks, Hamid
$22 USD en 1 día
5,0 (78 comentarios)
6,0
6,0
Avatar del usuario
Hi, I can develop Excel VBA Macro as per your requirements. I am experienced Data Analyst and Macro Developer and have done many similar projects. So, can do this job nicely. Ready to start please message me to discuss your project in more details. Thanks, Virendra
$30 USD en 1 día
4,8 (142 comentarios)
6,2
6,2
Avatar del usuario
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 Flow Chart, Excel Cash Flow, Excel Balance Sheet, Excel Waterfall Model, Excel Forecasting Models, Excel Prediction Models, Forecasting, Excel ROI, Excel Financial Ratio analysis, Investment, -> Financial modelling and projections, Cash flow, Balance Sheet, Trial Balance, -> Business valuation, Financial reports, Business analysis, Income Tax, Tax Return -> Economic research & analysis of Big.
$100 USD en 7 días
4,9 (54 comentarios)
5,9
5,9
Avatar del usuario
⭐⭐⭐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 just check my reviews and please have a look on my profile. let us discuss in chat
$20 USD en 5 días
5,0 (62 comentarios)
5,6
5,6
Avatar del usuario
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 including interaction between different software (Word, Excel, Powerpoint, Access, Outlook, MS Project,MS Visio, Autocad, pdf, CorelDraw, PhotoShop, etc.). Also on web scraping, Access DB design, SQL, management Dashboards, stock and financial worksheets, KPI's, proficient coder in VB.Net, VSTO add-in, C#, Python, JavaScript (google sheets), VB6, AI (neural networks, genetic algorithms, optimized search, etc).
$15 USD en 1 día
5,0 (49 comentarios)
5,5
5,5
Avatar del usuario
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 en 1 día
4,9 (28 comentarios)
4,8
4,8
Avatar del usuario
--------------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, pivot tables, charts, v lookup, word, excel database, and Microsoft office at large since that is my area of expertise within your minimal budget and provide quality work within the time required, I can also provide samples of my work. Let's discuss more in the chatbox. Regards Rahul
$30 USD en 1 día
5,0 (30 comentarios)
4,8
4,8
Avatar del usuario
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 forward for an opportunity to work on this project. Please feel free to message me any time. Thanks, Joji
$20 USD en 1 día
5,0 (31 comentarios)
4,0
4,0
Avatar del usuario
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. Regards, UMAIR
$25 USD en 1 día
4,9 (26 comentarios)
3,5
3,5
Avatar del usuario
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 and reports using Excel and Power BI. I have more than 10 years of working experince using Excel VBA and Maros I am looking forward to having further discussions with you and can start working immediately. please see my profile https://www.freelancer.com/u/NANSAMEERA86 Thank you Sameera
$20 USD en 1 día
5,0 (17 comentarios)
3,6
3,6
Avatar del usuario
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 en 7 días
5,0 (7 comentarios)
2,5
2,5
Avatar del usuario
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+ experience as Business Analyst, Project manager More than 20 years of experience as Data entry & crunching, Excel and VBA Business analyst and program management
$30 USD en 7 días
5,0 (1 comentario)
1,8
1,8
Avatar del usuario
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 tanksful if explain to me more and negotiate in chat. With best regards
$20 USD en 1 día
5,0 (3 comentarios)
1,7
1,7
Avatar del usuario
“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 and achieve greatness.
$20 USD en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 you want to discuss more about this project, you can reach me out through message. With that thank you for spending your time here. Regards, Nurul Shakinah
$20 USD en 7 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 are interested in giving me the opportunity to help you Thanks & Regards Anshuman Mohanty
$26 USD en 5 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
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 details.
$22 USD en 2 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Fernley, United States
5,0
18
Forma de pago verificada
Miembro desde jun 15, 2018

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.