
Đã hoàn thành
Đã đăng vào
Thanh toán khi bàn giao
I need VBA script to execute stored procedure that I have in oracle SQL with some parameter input from excel
Mã dự án: 40278293
49 đề xuất
Dự án từ xa
Hoạt động 1 tháng trước
Thiết lập ngân sách và thời gian
Nhận thanh toán cho công việc
Phác thảo đề xuất của bạn
Miễn phí đăng ký và cháo giá cho công việc
49 freelancer chào giá trung bình $21 USD cho công việc này

I can create a VBA macro in Excel to execute your Oracle stored procedure using parameters from input cells, returning results or status to the sheet. 10+ years Advanced Excel experience, Certified VBA Programmer, MBA.
$30 USD trong 1 ngày
6,5
6,5

Hello, Greetings of the day! I have a vast experience of working in Advanced Excel and I have completed many projects based on Advanced Excel. I have read your requirements and I can complete your project within time frame with proper and efficient work. I am a full time Freelancer and available to start your project immediately. I have an experience of below skills • Changing Raw Data into Presentable Data which can be easily under stood. • Use of Advanced Excel Formula • Data, Power Query, Tables & Formatting • Conditional Formatting • Advanced Charting • Pivot Tables & Pivot Reporting • VBA & Macros • Data Analysis • Anova analysis in Excel • Statistic & Modeling using Excel • Forecasting & Trend Analysis & many more …. I am ready to work on a Sample file also if required. Please initiate the chat so that we can discuss more about project and start the project. Thanks & Regards Sneh
$25 USD trong 1 ngày
6,2
6,2

Hello, I can help you create a reliable VBA script that connects Excel to your Oracle database and executes your existing stored procedure using parameters taken directly from Excel cells. With strong experience in VBA, Oracle SQL, and database connectivity (ODBC/ADO), I will ensure the script runs smoothly, securely passes the required parameters, and returns results to Excel if needed. The solution will be clean, well-structured, and easy for you to reuse or modify in the future. I can start immediately and deliver a tested, efficient script with clear instructions for use. Regards, Zafar
$30 USD trong 1 ngày
6,3
6,3

Hi, I can create a VBA script that connects Excel to your Oracle database and executes the stored procedure using parameters from Excel cells. The macro will handle the database connection, pass the required inputs, and run the procedure smoothly. I will also include clear and reusable code with basic error handling. Please share the stored procedure name, parameters, and the Excel cells containing the inputs so I can implement it correctly. Best Regards, Virendra
$30 USD trong 3 ngày
6,2
6,2

Hi, there, I have extensive experience in Excel VBA, SQL, data processing, and automation. With a deep understanding of Oracle and VBA, I can efficiently automate your Excel report using VBA to execute stored procedures in Oracle SQL with parameter inputs from Excel. ✅ I will first analyze the stored procedure and parameter requirements to design a robust VBA script. ✅ Leveraging my expertise in Excel Macros, I will implement the script to automate the report generation process seamlessly. ✅ Utilizing my data analysis skills, I will ensure accurate data processing and integration. ✅ Testing the automation thoroughly to guarantee flawless execution. ✅ I will provide clear documentation for future reference. I look forward to working with you. Best Regards. Brayan
$30 USD trong 1 ngày
5,3
5,3

Excel VBA developer, certified Oracle DBA ready to do the required VBA scripts that takes parameter input fom Excel, connects to Oracle server, execute a stored procedure and return the result dataset to Excel.
$30 USD trong 1 ngày
5,5
5,5

As an experienced developer with a specific focus on data processing, I am confident in my ability to automate your Excel reporting using VBA. With over two decades of work under my belt, I have honed my skills to be able to deliver top-notch code output accompanied by clear explanations, which makes me the perfect fit for this project. The quality of my workmanship and conscientiousness towards documentation ensures that you'll receive an efficient solution that is comprehensible and maintainable long-term. My background extends beyond VBA to encompass a variety of different technologies. While this project focuses on VBA script, I bring additional expertise in PHP, MySQL - relevant tools for comprehensive database management in conjunction with automation processes. My broad expertise also includes understanding of cryptocurrency and blockchain development which can be a plus depending on how your business is structured. Apart from offering my technical skills, it's important for me to highlight my commitment to open communication and trust as integral components of our collaboration. Ensuring your vision is fully understood and consistently providing satisfying results are top priorities for me. With a strong dedication to serving clients' best interests, I look forward to forging a potentially long-term business relationship with you. Let's get started!
$20 USD trong 7 ngày
5,2
5,2

Hi, I’m confident I can help you automate your Excel report using VBA to execute your Oracle SQL stored procedure with dynamic parameters. With strong experience in VBA, Excel automation, and Oracle database integration, I’ll make the process seamless and reliable. I will start by creating a VBA script that connects securely to your Oracle database. Next, I will configure it to pass parameters from Excel cells to your stored procedure and execute it. Finally, I will ensure the results are returned directly into your worksheet, formatted for easy analysis. You’ll receive a fully functional, ready-to-use VBA solution with clear instructions so you can run the procedure from Excel anytime without manual SQL intervention. Looking forward to collaborating,
$20 USD trong 1 ngày
3,5
3,5

Hello, I can create a VBA script that connects Excel to Oracle and executes your stored procedure with parameters pulled directly from worksheet cells. The macro will: Open an Oracle connection (via ADODB or OLE DB) Pass input parameters from specified Excel cells Execute the stored procedure Handle errors and optionally return output parameters or result sets back into Excel Include clear comments so you can modify connection strings or parameters later I have experience integrating Excel VBA with Oracle databases and working with parameterized stored procedures securely and efficiently. Share your procedure signature and parameter types, and I can tailor the exact VBA code for you. Regards, Bakhtawar
$10 USD trong 1 ngày
3,2
3,2

Hi, I’ve read your request and can deliver a VBA solution that runs your Oracle stored procedure from Excel using parameter input cells. I’ll implement an ADODB connection (or ODBC as needed), build parameterized calls to the stored procedure, capture result sets into worksheets, and add clear error handling and logging. I’ll also provide a simple UI (buttons and input cells) and documented code so you can reuse or extend it. I have broad experience in data automation, Excel VBA, Oracle SQL and deployment of robust ETL scripts; I also work with LLMs, Transformers, chatbots, classification and vector search so I understand full data-to-deployment pipelines. I can deliver a tested macro and short usage notes within the timeline. Do you have the Oracle connection details (TNS/connection string, username) and a sample set of the parameter values and expected output format? Best regards, Cindy Viorina
$10 USD trong 5 ngày
1,8
1,8

I am Oracle Certified DBA and worked on various versions of Oracle starting from 8i. I have worked on RAC, Data Guard, Standalone database on Linux and Windows. I am sure i will be able to do your Oracle Task. Please give us the details and we will be able to finish your task quickly and even we will give report as well. I am heading IT Services company, and we have a full team of Front-end, Back-end, UI/UX experts, Payment Experts and DBA. We have created Web Applications, Mobile Application and Websites for several of our clients. We have expertise for Python, Laravel and MERN , deployed web applications for our clients. We have created mobile apps using React-Native. We have deployed Mobile Apps in Android and iOS Platform. In all our applications, we have done Role Based controls, dashboards, notifications and social media integrations. We have experts with 30+ years of IT Industry experience, who has payment card interface and all the compliances
$20 USD trong 7 ngày
0,6
0,6

Hello, As a full-stack developer with a strong background in automation, I believe I have the perfect set of skills to help you achieve your project goals. Over the last 11 years, I've developed proficiencies in multiple programming languages including VBA. I'm highly experienced in leveraging VBA to automate processes and integrate Excel with external data sources like Oracle SQL - which aligns perfectly with what you need. Additionally, my deep understanding of database management (including Oracle SQL) and backend development will be instrumental in building a seamless and efficient system that executes your stored procedure using the parameter inputs from Excel. By leveraging my proficiency in RESTful APIs and database design, I guarantee the script's reliability and quick response time that saves you valuable time. Choosing me for this project opens up a world of possibilities as we can not only create this solution but explore potential enhancements that can revolutionize your data reporting system. I am committed to delivering high-performance, quality products - just what you're looking for! Let's work together on this project and transform your reporting process with efficiency and excellence! Thanks!
$10 USD trong 3 ngày
0,0
0,0

Hello, As an experienced AI developer, I specialize in crafting solutions that automate workflows and streamline operations. I have over five years of experience optimizing business processes through intelligent automation. While my key strength lies in building highly sophisticated chatbots, I also understand the need for automating tasks outside the realm of conversations. This solidifies my suitability for your project where you need to automate an Excel report using VBA script and Oracle SQL procedures. Combining my expertise in VBA, Oracle SQL, and automation strategies, I can help you design a robust script to execute your stored procedures with ease, eliminating manual input completely while keeping it flexible enough to accommodate parameter inputs from Excel. Working with me, means you get a professional who excels at every aspect of project management; from requirement gathering to final deployment. My solution will be stable in the long-run as I adhere to the best industry practices. My commitment is always towards creating value for you; improving efficiency and productivity while making your life easier through automation. Let's make this happen together! Thanks!
$25 USD trong 5 ngày
0,0
0,0

Hello, As an experienced and versatile developer, I offer valuable skills that extend well beyond your needs for Excel automation with VBA. Over the course of my proficient 11-year career, I have successfully executed diverse projects cutting across web, mobile app, and game development parexcploy much demanded such as using APIs using RESTful API and GraphQL. Specific to your Oracle SQL task, I bring solid understanding and adeptness in back-end skills like Node.js and PHP integrated with MySQL, PostgreSQL. These skills position me well to create a seamless and efficient VBA script that will execute your stored procedure with proper parameter input from Excel. Project delivery is as important as project execution. And here's where I truly excel - not just in the execution alone, but planning, testing, and deployment too. With me on board you can be confident in receiving a reliable solution that specifically addresses your current requirement while maintaining scalability for future enhancements or maintenance tasks. Let's connect and maximize your operational efficiency together! Thanks!
$10 USD trong 3 ngày
0,0
0,0

Hello, Knowing that achieving automated processes can save substantial time and resources, I am the perfect fit for your project. As a proficient Full-stack Developer with more than 11 years of expertise, I have a wealth of skills in mobile app (Flutter, React Native, IONIC), backend (Node.js, Php , Laravel) and also automation. I've successfully executed automation solutions in various projects across different sectors. Having completed numerous projects involving VBA scripting for Oracle SQL as per your requirement, I exactly understand how to execute stored procedures and extract data based on input parameters from Excel spreadsheets efficiently. I'm comfortable working in cross-platform environments, ensuring that my solution will work seamlessly for both Windows and Mac systems. My proficiency extends to frontend and backend development using various languages (e.g PHP, JavaScript, Dart), databases (MySQL, PostgreSQL, MongoDB), Restful APIs and version control tools such as Git. Also, as a bonus - I have successfully worked on projects requiring similar automated report generation tasks using VBA scripts driven by SQL queries. Let's automate your task together! Thanks!
$30 USD trong 4 ngày
0,0
0,0

Hello, I can create a VBA script that connects Excel to your Oracle database and executes the stored procedure using parameters taken directly from your worksheet. The macro will establish the database connection, pass the input parameters from specified Excel cells, execute the procedure, and optionally return any results back into the sheet if needed. The solution will use a stable connection method such as ADODB or Oracle ODBC, with clear configuration so you can easily update parameters or reuse the script for other procedures later. I will also include comments in the code so it is easy to maintain and modify. Once completed, you will be able to run the macro from Excel to execute your Oracle stored procedure automatically. Best Regards, Shabahat Habib.
$20 USD trong 7 ngày
0,0
0,0

As an experienced marketer and content creator, I understand the value of automation in maximizing efficiency and results-driven performance. My proficiency lies in crafting comprehensive campaigns that ensure every element, from visuals to execution, is optimized for success, and this extends to my skills with Excel, Macros, and VBA. I appreciate the complex data management that Excel requires and have spent considerable time honing my VBA abilities to provide effective solutions for intricate tasks like yours. By automating your Excel reports through VBA with execution of stored procedure from Oracle SQL with parameter inputs just as you've described will streamline your processes, save time, and reduce errors. Choosing me means you're getting a creative problem-solver who understands the bigger picture of your project while meticulously catering to the nuances it involves. Trust me to deliver a highly-efficient automated experience while staying true to your project's objectives. Let's optimize your report generation together!
$10 USD trong 1 ngày
0,0
0,0

Hi, I’m a Full-Stack Backend Developer specializing in database automation and Excel integrations with 4+ years of experience. I carefully read your requirements and understand that you need a VBA script that executes an Oracle stored procedure using parameters taken from Excel. Working with VBA, Oracle databases, SQL procedures, and Excel-based automation is part of my core skill set. I’ve previously built similar solutions where Excel triggers Oracle stored procedures, passes dynamic parameters, and retrieves results reliably using ADODB connections. My approach would be to create a clean VBA module that connects to your Oracle database, reads the parameter values directly from Excel cells, executes the stored procedure, and handles responses or errors properly so the process runs smoothly from Excel. Let's connect to discuss in more detail via chat. Thanks
$20 USD trong 1 ngày
0,0
0,0

You’re looking to automate an Excel report by running an Oracle SQL stored procedure with parameters passed from Excel via VBA. I understand you need a VBA script that can seamlessly connect to your Oracle database and execute the stored procedure using input values from your spreadsheet. I have over 15 years of experience delivering automation solutions involving Excel VBA, Oracle databases, and SQL scripting, having completed more than 200 projects focused on data processing and report automation. My expertise lies in writing clean, efficient VBA macros that interact with external databases for data retrieval and manipulation. For your project, I will develop a VBA script that establishes a secure connection to your Oracle database, prompts or reads the required parameters from your Excel sheet, and executes the stored procedure accordingly. The results will be captured and integrated back into your Excel report. This can be done within a day or two, ensuring your report runs smoothly with minimal manual effort. Let’s discuss your specific parameters and any additional details to get started on this automation.
$11 USD trong 7 ngày
0,0
0,0

Hello, I understand you want an automated Excel report that runs an Oracle stored procedure with parameters pulled from Excel, returning results cleanly into your workbook. My Plan: - Map specific Excel cells to the stored procedure’s input parameters and validate data types before execution. - Implement a VBA routine that connects to Oracle (via a reliable driver such as Oracle ODBC/OLE DB), with secure credential handling and a lightweight connection pool. - Use ADO to call the stored procedure, properly binding input parameters and capturing the result set or output parameters. - Write results into the target worksheet, refresh dependent charts/pivots, and log each run for audit and retry purposes. - Add robust error handling, meaningful messages, and a simple UI button to trigger the process from Excel. In a closely related project, I automated a financial reporting workbook that executed an Oracle stored procedure with dynamic parameters. The solution reduced manual steps by 70% and cut report generation time significantly while improving data integrity and error visibility.
$20 USD trong 1 ngày
0,0
0,0

Indonesia, Indonesia
Phương thức thanh toán đã xác thực
Thành viên từ thg 6 16, 2013
$10-30 USD
$100-110 USD
$2-8 USD/ giờ
$10-30 USD
$10-30 USD
₹12500-37500 INR
₹600-1500 INR
₹600-1500 INR
₹12500-37500 INR
$30-250 USD
$10-30 USD
₹601-700 INR
₹1500-12500 INR
€12-18 EUR/ giờ
₹1500-12500 INR
$10-30 USD
$10-30 USD
£20-250 GBP
$10-30 USD
$10-30 USD
$15-25 USD/ giờ
₹150000-250000 INR
₹600-1500 INR
$10-30 USD
$10-30 USD