Solidworks vba macros jobs
I'm looking to hire someone who can create an Excel VBA workbook to seamlessly integrate with my Zoho Desk setup. This workbook should be specifically engineered to perform the following: - Retrieve the required information from Zoho Desk tickets upon pressing a button inside Excel. Specifically, I need someone skilled in Excel VBA programming and API integration work to: - Design a user-friendly interface in the workbook where one can press a button to initiate the retrieval of ticket information. You should be able to retrieve the latest ticket, and then have two more buttons to go to next & previous tickets. - Implement secure API connections to Zoho Desk to enable the retrieval of ticket information usuing oauth. The fields I need are: Subject Account Name: C...
take existing models, convert to Solidworks. Analyse trolley and pulley wheels etc for strength (x2 design factor). provide screenshots of results. change components if needed and show as different colours the new parts. - no drawings required
I am looking for a skilled solidworks designer to draw a simple file .. in one hour
...create a professional gaming mouse with specific features and ergonomics in mind. Key project details and requirements: - The mouse should be primarily designed for professional gaming. - Customizable buttons are a key feature I'd like to incorporate into the design. Ideal Skills and Experience: - Previous experience in designing gaming peripherals would be highly beneficial. - Proficiency in Solidworks CAD software and a good understanding of mechanical engineering. - An understanding of ergonomics and the ability to design for user comfort and ease of use. Your task will be to develop a concept based on the provided requirements and deliver a detailed design ready for manufacturing. Strong communication skills and a proactive approach to problem-solving are highly valu...
I'm seeking a proficient Excel VBA coder to create a system that automates data entry from Excel files. The task involves: - Creating a VBA function that can input data automatically into my current system. - Implementing a data sorting feature as part of the data entry process to ensure that all data is easily read and interpreted. The ideal freelancer should have the following skills and experience: - Proficiency in Excel VBA - Experience with automated data entry - A solid understanding of data sorting techniques. This project requires precision and attention to detail. It should not only meet the needs listed above but also enhance data accuracy and save time.
I'm seeking an experienced Excel VBA expert to help me automate some basic, repetitive data entry and formatting tasks. Key Requirements: - Automate basic data entry and formatting tasks in Excel - Develop VBA script to ensure automation runs smoothly Ideal Skills and Experience: - Proven experience in developing VBA scripts for Excel - Strong understanding of Excel functions and data formatting - Ability to create automation systems that run seamlessly without user interaction Please note, no user interaction is required for this project. The VBA program should be designed to run automatically once set up. This task is relatively simple but needs to be executed precisely and efficiently. Looking forward to working with a professional who can deliver ...
I'm in need of a SolidWorks expert who is well-versed in sheet metal design. The project involves both creating sheet metal parts from scratch and making intermediate modifications to existing designs. Key Responsibilities: - Designing sheet metal parts from scratch - Making intermediate modifications to existing designs, such as changing folds, adding cutouts, modifying bend radius, revising hole placement, adjusting dimensions, and potentially other specific changes You should have: - Proficiency in SolidWorks, with a strong focus on sheet metal design - Experience in creating sheet metal parts from scratch - A solid understanding of bending, cutting, and folding principles - Prior experience in modifying existing sheet metal designs, preferably intermediate modific...
I'm seeking an expert in Excel and VBA who can work on an an existing financial model. The primary tasks will involve optimizing formulas, macros, and implementing data validation. I am looking for an hourly regular working engagement where the person will sit with me from time to time online and solve for things one at a time. I cant share workbooks as I have some IP related restrictions so person will have to work on my system, remotely. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs
...automating the transfer of information between those departments: linking the data, defining "trigger" events, and processing data from various inputs into "smart" trackers. I have a clear outline of what I want to accomplish - what data I need, who I need it from, and how I want the tracking of the inputs to function. My "coding" ability is a limited working-knowledge of JavaScript PDF and Excel VBA. I need someone to provide council and advise on what is possible, what tools or platform would be best for the end product I want to develop, and to advise on any alternatives. Basically, I am in the early stages of a long development process and I need an expert coder to review my outline and provide advise for the best way to accomplish what I want. ...
I'm hiring for a product design project that requires an experienced SolidWorks designer. Aligning with the course of creating a detailed layout with dimensions, this task calls for a diligent professional who can bring depth and precision to the final design. Ideal skills and experience: - Expertise in SolidWorks - Prior experience in product design - Demonstrated capacity to develop detailed layouts with precise dimensions Expectations: - Deliver a detailed product design - Accuracy in dimensions is paramount - Quality work in a timely manner Bottom line, if your mastery lies in crafting detailed product designs using SolidWorks, then look no further, we've got a perfect match here.
I require a VBA Developer well-versed in automating repetitive tasks in Microsoft Excel. Your primary task is to automate my existing work functions to increase efficiency. Key Responsibilities: * Understand the current Excel operations and identify scope for improvement. * Develop VBA codes to automate basic standard operations. * Test the robustness and accuracy of the automation. * Combining 2 files into 1 pdf. 1st file is pdf and 2nd is excel(with selected sheets, and selected columns within sheets) Desired Skills & Experience: * Proficient in VBA, specifically for Microsoft Excel. * Experience in automating repetitive tasks. * Sharp problem-solving and debugging skills.
Seeking a proficient Excel VBA developer to aid in the centralization and automation of tasks in Excel 2010. Project requirements include: - Expertise in Excel latest version - Strong understanding of EXCEL VBA for automation purposes. Please note, specific tasks and functions to be automated in VBA have yet to be defined. Flexibility and broad knowledge in different Excel functions will be considered an asset.
I am seeking a skilled professional with expertise in Solidworks to design a part intended for manufacturing. Key Requirements: - The part will be primarily used in room temperature environments. - Precision and accuracy are crucial requirements for this project, as the part must meet exact specifications for manufacturing processes. Ideal Skills: - Solidworks - CAD/CAM Design - Mechanical Engineering The ideal candidate should have substantial experience creating high-precision Solidworks parts for manufacturing. Accuracy and attention to detail will be paramount in this job.
...essential to be an expert. Anyone with generic database experience (with different databases) can also apply. Skills already acquired from previously doing this work: - Understand database schema - understand database structures - create database tables based on bespoke requirements (training included) - Working with relatively large sets of data - has exporting skills into SQL - Excel and VBA, - Has experience in different querying languages - Proficient in Microsoft SQL Server Management Studio - Familiarity with Windows OS - Experience in handling multiple databases with SQL - Strong troubleshooting skills I currently manage over 11 databases via Microsoft SQL Server Management Studio, and my system operates on Windows. You would be working an 8hr paid day in the Austr...
I'm seeking an expert in Excel and VBA who can work on an an existing financial model. The primary tasks will involve optimizing formulas, macros, and implementing data validation. I am looking for an hourly regular working engagement where the person will sit with me from time to time online and solve for things one at a time. I cant share workbooks as I have some IP related restrictions so person will have to work on my system, remotely. For Faridabad, Haryana based freelancers, we can do it in physical mode too. Key areas of focus will be: - Refining Formulas and Calculations. - Improving Data Organization and Management - Managing , improving the existing VBAs
...item availability. 4. Delivery Tracking - Allowing customers to check their food order status. 5. Nutrition Coaching Reservation - Capability for customers to reserve sessions with a dietitian. 6. Customized Ordering - Feature that facilitates personalized orders based on customer needs of calories and macronutrients (the system will customize the meals according to user inputs of calories and macros). 7. Blog Integration - To serve engaging, relevant, and up-to-date content to our users. 8. Calculators for calories and macronutrients. 9. using geolocation to locate the customer's location. 10. multilanguage (arabic, english, kurdish) 11. PWA app of the website. 12. User Authentication: A secure logging system for users. 13. Payment Integration: A stable and secure mechanism...
...(app), emails using AWS (transmail) email automation, Zendesk and MailerLite Log-in: Site, Google & Facebook Domain name: Ionos (SSL) **THIRD PARTY APPS** These have been integrated: -Contabo or AWS server -AWS email -Braintree -PayPal -AWS email automation (all membership emails, notifications, requested reminders etc) -Zendesk (set up by Zendesk specialist in conjunction with web developer; API, macros, articles) -MailerLite (API syncing members for company newsletter) -Admin panel (custom) -Google Developer -Apple Developer -Facebook Developer -Userway (ADA) plug in -A few plug-ins text formatting etc. You will be required to sign an NDA. Chosen developer company will sign a monthly Service Agreement. This project is for hire. Completed project is our intellectual prope...
I need a knowledgeable Excel VBA specialist, with a background in data manipulation and analysis, to create a custom macro for my spreadsheet. - The macro's primary function is to automate the creation of new rows based on certain numeric values, namely the ones found in columns E to L on a specific sheet in the workbook. - Upon row creation, data from columns A to D should be copied over to the corresponding new row on another sheet. - Additionally, the macro should automate the assignment of values in cells from L to Q based on the count of numbers in rows created. The assignment of values is to be done using a simple addition or subtraction formula. The ideal freelancer should have solid experience in creating advanced Excel VBA macros, and a strong unders...
...experienced MS Access developer to assist with my form development tasks. The ideal candidate is proficient in VBA (Visual Basic for Applications) coding and has the ability to design and implement forms based on my specifications. Key Responsibilities: - Designing and developing database structures based on my project requirements - Implementing VBA code for basic functionalities such as form submissions and data entry automation - Creating forms in MS Access based on a specific design I have in mind - Ensuring the database and forms meet quality standards and are user-friendly Ideal Skills and Experience: - Proven experience in database design and development using MS Access - Proficiency in VBA coding, particularly for basic functionalities - Previous experienc...
I am interested in creating an Excel VBA macro that will allow me to import PDF invoices into line items and parse them. The objective of this project is to streamline the process of invoice data entry by automating the extraction of key information from incoming PDF invoices, namely Invoice number, Vendor name, Pricelist, and Detail. The successful freelancer for this project should have: - Demonstrated experience in creating VBA macros for Excel - A strong understanding of PDF parsing and data importation - Knowledge of accounting principles is a plus The imported data should ideally be formatted in Excel as: - Each PDF invoice should be translated into a single row - The extracted information should be available in separate columns for each piece of information.
...NEED I'm in need of a VBA developer who can help in creating a small code for scraping contact details from a specific website. The task involves creating a button in an Excel file that triggers the scraping process and saves the extracted data back into the same Excel file. Note : Project budget is only 6k because it will take max 2-3 hour for experience developer Key Requirements: - Scrape contact details from - Specifically, scrape Owner Name & Address - Implement a function where a user clicking a button triggers the scraping process - Save the extracted data back into the same Excel file Ideal Skills & Experience: - Proficient in VBA programming - Experience with web scraping - Familiarity with Excel macros and buttons - Ability
We require a specialist Excel developer capable of designing an ERP worksheet that can facilitate efficient inventory management. Notably, this will be identified through its ability to: - Track product movements (Received from Dock, Moved to Location, Picked, RTS) - Forecast demand accurately - Calculate reorder points precisely (Flag Products that are low in stock) - Distr...Sequens is Location, Part, QTY) - Ensure daily inventory updates are possible (Inventory has to be LIVE) - Add a dashboard for visual view of KPI's and results The ideal candidate will have proven experience in ERP Excel design, particularly within the field of inventory management. Expertise in IR Scanning layout will be strongly favored. Knowledge needed. - Excel Formula Mastery - Pivots Tables - VBA...
I'm in need of an intermediate level automated meeting minutes solution on Excel 2016. This project requires expertise in Excel and VBA and knowledge of data categorization. Key requirements include: - **Template Generation**: The tool should be able to generate a meeting minutes template automatically. - **Categorization**: Information in the meeting minutes should be categorized by attendee. Date Task owners Points discussed New Ideas generation' related System Process People Technology others Ideal skill set for this project includes: - Proficiency in Excel, particularly Excel 2016 - Experience in VBA/Macros for Excel - Previous work with data categorization and template generation Looking for someone who can deliver a robust, user-friendly solution...
I am seeking a proficient specialist in Excel 2010, with extensive experience in the creation of VBA Macros, designing data entry sheets, automating tasks, and generating reports. Key responsibilities include: - Design and develop efficient VBA Macros - Design accessible and streamlined data entry sheets - Automate various Excel tasks for increased productivity - Generate comprehensive and insightful reports Ideally, you have advanced knowledge of Excel and VBA Macro programming, demonstrating a proven track record in dealing with complex Excel projects. A strong understanding of spreadsheet automation and report generation is fundamental to execute this project successfully.
take existing PDF drawing, convert them to models, load analyse x 2 and add material if not strong enough, do a drawing set.
I'm in need of assistance in creating engineering drawings specifically in mechanical assembly drawings using SolidWorks. If you are proficient in creating and manipulating 3D models, this might be the project for you. Skills and Experience Required: - SolidWorks proficiency - Expert in mechanical assembly drawings - Strong grasp on engineering principles - Attention to detail for creating detailed drawings Looking forward to working with an expert having a deep understanding of SolidWorks for mechanical engineering drawing needs.
I'm in need of high-quality CAD drawings for specific heavy haul trailers. The following trailers require detailed representation with dimensions in meters expressed: - Lowboy trailer - Specialized heavy haul trailers and equipment All drawings should be formatted in a way that they can be exported to either DWG or PDF. A proficiency in AutoCAD, SolidWorks, or Fusion 360—or any other equivalent software that can satisfy this requirement—is preferred. The primary use of these drawings will be for permitting and training visualizations. Expertise in design visualization is thus essential. Do ensure that your drawings are clear, accurate, and suitable for these purposes. Thank you. Examples of the drawings I need to emulate, but with different units and loads
I'm looking for an Ex...from the NSE options chain. - Educational Focus: The content presented should be geared towards explaining the basic concepts of options trading in a clear and easy-to-understand manner. - Excel Proficiency: The ideal candidate should have a strong command over Excel and be able to integrate real-time data sources effectively. Ideal Skills and Experience: - Advanced Excel Skills: Proficiency in VBA and data connections is a must. - NSE Data Integration: Prior experience working with NSE data feeds would be advantageous. - Educational Content Creation: Experience in simplifying complex financial concepts into easily digestible content would be a plus. Looking forward to working with a professional who can deliver a top-notch, educational Excel NSE opt...
I'm in need of an Excel expert who can help me automate data entry and formatting tasks. I also need assistance in creating a macro to generate daily status reports. Key Tasks: - Automate data entry tasks - Automate formatting tasks - Create a daily status report macro Requirements: - Proficiency in Excel and VBA macro creation - Experience in automating data entry and formatting - Previous history of generating reports using VBA - Strong communication skills and ability to understand and translate my requirements efficiently.
I need a skilled Excel VBA Macro expert to develop a VBA macro that can automate reports, specifically with numerical data. Your task will revolve mainly around creating a function that streamlines the reporting process, making it efficient and error-free. Ideal Skills: - Extensive knowledge in Excel VBA - Strong background in automated reporting using Excel - Familiarity with handling numerical data Experience required: - Prior experience developing Excel VBA macros - Proven track record in creating automated reports .
I'm searching for a proficient SolidWorks modeler to assist in the development of an experimental setup primarily used for research purposes. Key components to be incorporated include: • Sensors This project necessitates a deep understanding of how sensors function, especially with regards to normal setup. Your role will largely involve integrating these sensors into the model to ensure maximum functionality and efficiency. Ideal Skills and Experience: • Proficiency in SolidWorks is a must • Deep understanding of sensor integration • Background in research-oriented projects • Familiarity with normal setup sensor functionality Your input and expertise will contribute to the success of this integral research tool. I'm looking forward to ...
I need a Windows-compatible MS Word editor that has robust document formatting tools and advanced editing features. It should be a basic editor, without the need for advanced functionality such as macros and scripting capabilities. Ideal Skills and Experience: - Proficient with MS Word on Windows - Strong understanding of document formatting tools - Skilled in advanced editing features Please provide me a list of your previous projects and an example of your work if possible.
I am seeking a seasoned Excel expert to manage a complex data entry project. Your focus will be the development and implementation of advanced macros to ensure efficient, effective data management. Key Responsibilities: - Executing Excel data entry tasks - Developing and applying advanced macros Preferred Skills & Experience: - Proficiency in Excel - In-depth understanding of advanced macro development - Proven experience in similar data management projects The ideal freelancer will be detail-oriented, possess strong problem-solving skills, and have a track record of improving efficiency and accuracy in data entry tasks via macro automation.
...UI, which has a settings dialog for the rules: - add/delete/update/display (CRUD) operations on rules - user can choose a regex pattern to detect specific phone numbers (from) - user can choose the destination(s) (a list of destinations) with whatsapp, telegram, sms, e-mail - implementation in this MS on the UI only for e-mail (but user can select all the named options) - user can choose to use macros like: - sender phone (smsSenderPhonenumber) - sender name (smsSenderDisplayName) - senders text (smsBody) - senders datetime (smsDatetime) MS3: help to publish on playstore and appstore MS4: implement the telegram integration (forwarding destination) MS5: implement the telegram integration (receiving telegram msgs and forward) MS6: implement sms sending (e.g. to forw...
I'm looking for an Excel and VBA expert to help streamline my workflow and boost productivity. You'll be responsible for: - Automating repetitive tasks: I need you to develop efficient scripts that will handle routine operations in the spreadsheets, eliminating the need for manual intervention and enhancing the overall efficiency. - Crafting custom functions: The custom functions I require are complex and involve external data sources. Your role will involve creating these functions effectively, ensuring they are accurate and function seamlessly within the Excel environment. The ideal candidate will have extensive experience in Excel, VBA, and creating complex custom functions. Solid understanding of data analysis and automation is crucial for this role. Your mai...
I'm in need of a Solidworks expert to assist me in creating a variety of escape room props. Ideal Skills: - Proficiency in Solidworks - Experience with 3D modeling for physical objects - Creative problem-solving abilities - Attention to detail Requirements: - Creating both Puzzle, Decorative, and Interactive props - The Puzzle props should be of Intermediate complexity - The Decorative props should follow a Historical theme Please let me know if you have any relevant experience in this field and if you're up for this creative challenge. Thanks!
I'm urgently in need of a VBA expert to help tune an existing Word VBA that's not performing as expected. Even though it runs, it's not accomplishing the task it was meant for. Key objectives for this project are: - Identification and resolution of current issues with the VBA to align with its original purpose - Modification of the VBA to extract Word OLEs, while entirely bypassing PDF files (skipping them). The ideal freelancer for this task will have: - Extensive experience in VBA coding and troubleshooting - Experience with OLE extraction from Word - Proven track record in meeting deadlines. The timeline for this project is within a month. If you think you're the right fit for this project, I'd like to hear how you can hel...
I'm seeking an expert who can assist with developing a comprehensive data analysis and automation solution within SMART sheet and Excel. Key Responsibilities: - Develop custom...developing a comprehensive data analysis and automation solution within SMART sheet and Excel. Key Responsibilities: - Develop custom dashboards for financial analysis within Excel. - Automate data management processes within both SMART sheet and Excel. - Integrate the dashboards into SMART sheet for seamless use. Ideal Skills & Experience: - Strong expertise in SMART sheet and Excel, including VBA. - Proven track record of developing dashboards for financial analysis. - Ability to automate data management processes. - Excellent communication skills. Please provide examples of similar project...
I require assistance with the creation of SolidWorks assemblies for manufacturing purposes. This includes a simple complexity level project, with the end output being stepfiles for documentation. Approximately 108 required they will be similar to attached examples Ideal Skills and Experiences: - Strong proficiency in SolidWorks - Understanding of manufacturing processes and designs - Experience in creating assemblies and stepfiles - Detail-oriented to ensure no detail is overlooked The freelancer will be required to: - Complete the SolidWorks assembly based on the specifications provided - Create stepfiles for documentation - Communicate effectively and promptly respond to queries or alterations to the project.
I am in need of a proficient data analyst who can provide a comprehensive solution to our manufacturing workflow. The scope includes: - Developing an advanced order planning & costing mechanism specifically for our production unit. The system should be based on Excel and leverage the power of scripts and macros. - Certain features are a must-have: inventory management, production scheduling, cost optimization, and sales order management. - Following this, the mechanism will then be utilized to create a management dashboard on PowerBI. Core KPIs to be highlighted on the dashboard include production efficiency, inventory turnover rate, cost per unit produced. In addition, it should also provide a detailed overview of sales and profitability. The perfect candidate for this pro...
...a business owner, I'm in need of a talented 3D designer to create a medium-sized product design. This design will serve as a prototype for future production, so keen attention to detail and production feasibility is necessary. The task requires: - Expertise in 3D industrial design: You should be able to create intricate, realistic designs. - Proficiency with software such as AutoCAD and SolidWorks: These are commonly utilized tools in the creation of 3D product designs and prototypes. - Strong understanding of materials: Since the design is destined for real-world application, knowledge of different materials will be beneficial in the creation process. While I didn't specify a particular prototype purpose, as the designer, you should keep in mind the potential v...
I'm in need of a VBA Excel expert to assist with generating weekly financial reports. Key Requirements: - Weekly Reporting: The expert should be able to create efficient and accurate VBA scripts that will automate the generation of excel charts based on our csv files reports downloaded from our service management software on a weekly basis. The chart is basically to display the Technician's daily sales of labour and material sold (shown in separate charts. - Financial Data: These reports will be based on our financial sales data, so the expert should be comfortable working with and manipulating this type of information. Ideal Skills: - Proficient in VBA for Excel: The ideal freelancer should have a deep understanding of VBA and Excel and be able to l...
...needs and fitness goals, automatically generate shopping lists, and estimate costs. Key Features: Personalized Meal Plans: Automatically generate weekly meal plans that align with user-entered health metrics and goals. User can also enter specialized suggestions such as vegan, high protein, no dairy. Nutritional Information: Each recipe comes with detailed nutritional facts, helping users track macros, calories, and other dietary needs. Grocery List Generation: Compile grocery lists based on the week’s recipes, optimizing for cost, and minimizing food waste. Cost Estimation: Provide an estimated cost for the weekly groceries based on prices from local stores or average costs. Technologies: Frontend: Vue.js or React for a dynamic and responsive user interface. Backend: Pyth...
I am in crucial need of a highly skilled MS Excel professional who can deliver moderate complexity tasks within a tight deadline of 10 days. The project consists of 72 individual tasks involving: - Data visualization - Spreadsheet formulation - Creation and implementation of advanced formulas and macros I am looking for someone who works efficiently, pays attention to detail and is highly skilled in all aspects of MS Excel. A proficient understanding of data analysis and visual representation is definitely a plus. The job demands the combined ability to work rapidly without compromising on quality. The ideal candidate should be ready to start as quickly as possible, adhering to the constraint of a strict timescale for completing all the subtasks. Speed and proficiency in Excel...
...and performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process automation. - VBA & Macro Skills: Proficiency in VBA programming and creating Macros in Excel is essential. - Template Modification: Experience in modifying existing Excel templates or creating new ones....
...and performing advanced data analysis within Excel is a must. - Process Automation: I'm looking to automate several manual processes using Excel. This would involve creating macros, custom formulas, and potentially VBA coding. - Template Creation & Modification: You should be able to both create new Excel templates and modify existing ones for the specific purposes of data analysis and automation. Skills and Experience: - Proficient in Excel: You should be well-versed with Excel's data analysis features and have experience in process automation. - VBA & Macro Skills: Proficiency in VBA programming and creating Macros in Excel is essential. - Template Modification: Experience in modifying existing Excel templates or creating new ones....
...- The work needs to "live" in only two places - the reference table worksheet, and the worksheet doing the calculations. Because of how I'm structuring multiple sheets, I can't have a "scratch pad" sheet with intermediate lists. - The lookup will live in many different rows, performing lookups/calculations in each row based on selections - Because of the above, I believe it needs to be done via VBA, possibly by storing arrays and setting variables for row references. Ideal skills for the job: - Advanced Excel skills, particularly in lookup functions. - Experience in data analysis in Excel. - Proficiency in creating Excel functions for basic arithmetic operations. - Visual Basic I've attached the reference table, which will likely grow over ti...
