Modernize Excel VBA Compatibility

@leelakalidas32

Hello Sir, I understand the existing VBA workflow, the macro output spreadsheets, and the cross-platform compatibility issues. I can refactor the macros to run natively on Excel 2021 and 2024 for macOS while preserving the current functionality and output exactly as required.

@schoudhary1553

Hi, I have reviewed your requirements and can deliver a high-quality, accurate solution within the agreed timeline. With 15+ years of experience in automation, data analysis, Excel, Python, Power BI, and software development, I focus on delivering reliable results with clear communication and complete client satisfaction. I’m ready to start immediately and look forward to working with you.

@utrathore3

As an expert in Excel and Excel macros, I am confident I can solve the current challenge you're facing with your outdated VBA code. Being proficient in Excel across multiple platforms, specifically from Windows to Mac, I know how to ensure compatibility without missing references or Windows-only calls. I've successfully completed similar projects in the past and can ensure that your macros will run smoothly on Excel 2021 and 2024 for macOS, leaving no room for deprecated Windows-only libraries. Moreover, working with Work-Nix Solutions means you're partnering with a team that excels (no pun intended) at creating transformative business solutions. Our tailored approach is designed to streamline operations and optimize performance - factors your project explicitly requires. Besides, our services extend beyond Excel macros; we offer a wide-ranging variety of skills relevant to this project like data analysis, automation among others. Explore my impressive profile here: https://www.freelancer.pk/u/utrathore3 . Note: "Delivering success is our commitment. To achieve this, we carefully assess your project's scope, and then provide customized costs and timelines that meet your unique needs." Thanks and Best Regards, Usman Tariq Rathore Work-Nix Solutions

@sareheshak

Certified VBA Programmer(Excel Macro) 10+ years Advanced Excel experience, Certified VBA Programmer, MBA. I have experience converting Windows-only VBA projects to work on macOS. I can refactor your macros for Excel 2021/2024 (Mac), remove unsupported Windows references, preserve the existing output and sorting logic, and ensure the hide/show functions work reliably across both platforms.

@CanguruWorkana

This work will be done and delivered in 3 business days and will be perfectly functional, but it requires patience. I have the full knowledge to do this conversion, but the real test will be done on your own macOS computer.

@ShaikhAneesa

Hi there, I have reviewed your project requirements for modernizing Excel VBA compatibility, specifically focusing on rewriting or refactoring existing VBA code to ensure seamless functionality on Excel 2021 and 2024 for macOS. Let's chat and discuss it further. To handle your project, I will start with analyzing the existing VBA code and identifying any Windows-specific calls or missing references. I will then refactor the code to make it compatible with Excel 2021 and 2024 for macOS, ensuring that macros execute without errors and all functionalities remain intact. The deliverables of this project include a fully functional VBA code that runs smoothly on Excel 2021 & 2024 for Mac, custom multi-level sort functionality, toggleable column hiding/showing, and removal of any deprecated Windows-only libraries. Before signing-off my bid, I would like to ask a question, i.e., have you made any specific changes to the existing Excel files that may impact the VBA code functionality? Warm Regards, Aneesa.

@TeraByte26

I will refactor the VBA macros to run natively in Excel 2021 and 2024 for macOS, ensuring no errors, consistent sort results, and proper column toggling, within the 30-250 USD budget, delivering the updated spreadsheets within a few days. Waiting for your response in chat! Best Regards.

@EightVeer

Hi there, We understand the need to modernize the existing Excel VBA so it runs cleanly on Excel 2021 and 2024 for macOS, including the multi-level sort and the hide/show column controls. We have worked with cross-platform workbook logic, legacy macros, and output validation, so we can review the attached spreadsheets and identify the Windows-only dependencies that need to be refactored. Our initial assumption is that the export structure can be adjusted without breaking the downstream macro workflow, but we will confirm that after reviewing the current code and workbook relationships. The platform bid covers an initial phase focused on Audit the attached workbooks, map the existing VBA dependencies and Windows-only references, identify Mac compatibility gaps, and deliver a concise refactor plan plus the first corrected macro path for the export/sort/hi; wider implementation would be separately scoped on Freelancer. Best Regards, 8veer

@tnowsolutions

Hello, I have reviewed the attached Orders, Views, Sorted Orders, and Class Assignment workbooks, so I understand the current input structure and expected outputs. I can refactor the VBA for native compatibility with Excel 2021 and 2024 on macOS, remove Windows-only references, make the multi-level sorting fully repeatable, and rebuild the hide/show column controls without ActiveX or deprecated libraries. I can also make the import logic header-based, so your planned column reordering will not break the macros. One important question: could you please provide the original macro-enabled .xlsm files or exported .bas modules? The attached .xlsx files contain the data and expected results, but they do not include the VBA source code that needs to be refactored. Regards,

@sabaehsan

Greetings, I see that you're looking to modernize your existing Excel VBA macros to ensure they run smoothly on macOS, specifically for Excel 2021 and 2024. This is a common challenge when transitioning from Windows to Mac due to the differences in how VBA operates on these platforms. My approach would involve carefully reviewing your current macros and identifying any Windows-specific calls or libraries that need to be updated or removed. I will focus on ensuring that the custom multi-level sort works consistently, and that the designated columns can be hidden and shown as required. My experience with Excel VBA across platforms positions me well to tackle this task effectively. I look forward to helping you streamline your spreadsheets for Mac usage. Best regards, Saba Ehsan

@codefusion53

Hi I understand you are looking for a hands-on refactor of your existing Excel VBA so the Windows-era macros run cleanly on Excel 2021 and 2024 for macOS, with no missing references or Windows-only calls, while preserving the exact output behavior from your sample runs on Orders.xlsx. I’ll work directly from your current spreadsheets and outputs, focusing on identifying what’s breaking on macOS (reference/library usage, object model differences, path/filename assumptions, and any Windows-only API calls). Then I’ll rewrite those parts to use Mac-compatible VBA patterns so your automation remains stable and repeatable. For delivery, I’ll first audit the VBA modules and the column/data assumptions used by the flows that produce the result sets. Next I’ll refactor the macros to be natively compatible, then verify the two key behaviors: your custom multi-level sort consistency and the hide/show toggle for the designated columns. I’ll finish by removing any deprecated Windows-only libraries and leaving you with a Mac-executable working setup. Best, Justin

@MZITSERVICES

Hi there, I am A.R.M. MASUD, with a strong data science background. I specialize in creating customized Excel-based solutions that streamline business processes, enhance data management, and enable insightful analysis. Whether it’s developing advanced macros, automating workflows, or integrating Excel with other Microsoft applications, I deliver robust, efficient solutions tailored to your specific needs. My expertise includes AR/AP Management, Financial Statement Preparation, Expense Tracking, Budgeting and Forecasting, Cash Flow Management, and APR Calculation via the Sales Force Formula. I design and develop advanced Excel workbooks with tailored features such as formulas, macros, pivot tables, Power Query, mail merge, email via Outlook and Gmail, add-ins, customized macros, and automated repetitive tasks using Excel VBA. I also create interactive dashboards for real-time data visualization, providing fully functional and customized Excel workbooks, automated workflows, and macros for efficient task management and data integration between Excel and other business systems. https://www.freelancer.com.bd/projects/excel/Advanced-Data-Processing-Chart/reviews Thank you for considering your Microsoft Excel development project. I am confident that my expertise and commitment to excellence will add significant value to your business operations. Thanks A.R.M MASUD

@Georgeoustar

Hi, there! I can help refactor your existing Excel VBA macros so they run reliably on Excel 2021 and 2024 for macOS. I have experience with Excel automation, VBA debugging, macro migration, and removing Windows-specific dependencies to create cross-platform compatible solutions. I’ll review the current code and output spreadsheets, identify compatibility issues, replace unsupported references, and ensure sorting, column hiding/toggling, and all existing workflows produce the same results on Mac. I understand the importance of preserving the current logic while making the automation stable for future use. Best regards, George

@durgesh8527

As a versatile full-stack developer with vast experience in cross-platform automations, I'm well-equipped to tackle your project. I have a deep understanding of the complexities involved in migrating spreadsheets and their VBA macros between different versions and operating systems, such as what you need to modernize this Excel 2016 for Windows VBA project to run natively on Excel 2021 & 2024 for macOS. My core competences lie in web, mobile, and enterprise solutions, but my knack for adaptability has allowed me to excel in various other domains as well including automation and data tasks—precisely like what you're looking for. Not only am I intimately familiar with the tools at our disposal around Excel (VBA), whether it be Data Integrations, Business Analytics or leveraging databases like MySQL, MongoDB, PostgreSQL etc., but I'm also deeply committed or delivering clean and reliable solutions within the given time frame. With a focus on performance and maintainability, you can trust me to refactor or rewrite your VBA code effectively- ensuring no missing references or deprecated Windows-only libraries are crippling it. Let's get started right away with this task—I’m eagerly waiting to hear your clarifications if any!

@qualityxenter

Affordable, Early Delivery. ★★★★★★★★★★★★★★I hold a Masters degree which gives me the requisite background to handle writing from various subjects. I am a highly committed person towards my work. You can rely on QualityXenter for quality and consistency in writing. We never violate copyright rules. I have vast amount of experience in this industry since I am working from 2015 as a professional writer. I provide many modifications till to get your satisfactions. I have access to enough journals to use in your research project. I always produce quality work at VERY LOW RATES so, don't worry if you have a low budget for your work, I will be very happy to make a new client like you. I am producing quality work for my clients including ARTICLE WRITING, REPORT WRITING, ESSAY WRITING, RESEARCH PAPERS, BUSINESS PLAN, TECHNICAL WRITING, MATLAB, THESIS, ACCOUNTING & FINANCE work ETC. Go through my profile link https://www.freelancer.com/u/qualityxenter

@jamesdavidclarke

Hello I have rich experience developing cross-platform Excel VBA solutions and refactoring Windows-based macros to run natively on Excel for macOS. I'll review your existing VBA code, understand the current workflow and output spreadsheets, remove Windows-specific dependencies, and ensure the macros run correctly on Excel 2021 and 2024 for Mac while preserving the existing functionality and output. I can start immediately and provide clean, well-documented VBA with thorough testing. James.

@smzaman01

Hello, I understand the requirement: review the existing Windows VBA and output workbooks, then refactor the code for native Excel 2021/2024 compatibility on macOS. I can replace Windows-only calls, remove broken references, preserve the existing multi-level sorting results, and ensure the hide/show column controls work reliably. I will first study the attached files and current outputs before changing any code.

@Specgi

As a seasoned expert in Excel and Excel VBA, I am confident that I can modernize your Windows-era spreadsheets for seamless compatibility with both Excel 2021 and 2024 (Mac). Having worked extensively with cross-platform Excel automation, I'm well-acquainted with the unique challenges of streamlining macros for different operating systems. With a keen eye for deprecated Windows-only libraries and proficiency in refactoring VBA code, I'll ensure that your macros run smoothly without any missing references or platform-specific errors. In addition to my expertise in Excel, I boast a diverse skill set ranging from Google Cloud Vision to data analytics, further buttressed by my long-standing experience in the tech industry. This has honed my problem-solving abilities, an essential skill for tackling intricate coding issues like yours. My meticulous approach to tasks will be reflected in the outcome - macros that not only execute flawlessly but also yield consistent results across multiple runs thanks to custom multi-level sort and comprehensive column hiding features.

@Vsion2

Hi there, I am Alema, I am a highly skilled Advanced Microsoft Excel expert with 15 years of experience and have been providing services as a Freelancer seller since March 2020. My areas of specialization include: VBA Macro Database Systems: Inventory Management Systems Payroll Database Systems HR KPI Management Systems Advanced Excel Solutions: Complex Excel Formulas Data Analysis for various reports Conditional Formatting for automated data visualization Data Validation to ensure data accuracy Financial and Costing Reports to support decision-making Pivot Tables and Charts for insightful data summaries Data Sorting I have completed 350+ projects with a 100% Positive Rating. If you are looking for Quality work, look no further. Also, we are a team of professional workers, and we are always available 24/7 to help employers without limitations, and delivery is guaranteed on time. Your faithfully. Eng. Alema Akter