Connexion acces vba iseries as400 jobs

I'm aiming to augment my current Skyline Chart, hosted on Microsoft Excel, by including filter slicers and a timeline functionality. This will provide interactive filtering options, visualize data over specified periods and enhance overall user experience. I'd prefer a freelancer with a strong handle on VBA and data visualization in Excel. You'll be dealing with contract and procurement data, hence, prior experience in this area would be advantageous. Tasks include: - Incorporating filter slicers into the existing Skyline Chart - Adding a timeline which fits the current design - Ensuring both new elements accurately represent contract and procurement data

I need a VBA macro expert to automate repetitive tasks in Excel. Specifically, the focus is to build a macro that will update data from multiple database systems, pulling all necessary data and accurately updating the Excel file. The requirements include: - Deep knowledge in Excel VBA and macros. - Extensive experience in dealing with database systems. - Attention to detail to ensure valid and accurate data updating. - A solution-oriented approach to identifying potential issues with the automation. The ideal candidate will have a proven track record in creating VBA macros that interact seamlessly with various database systems. They'll bring efficiency and reliability, turning the repetitive updating process into a seamless, automated one.

I am in need of a proficient Excel automation specialist. This job requires updating an existing workbook with new data, automating the creation of rows, columns, and formulas and allowing for an undated workbook to be downloaded without having to re-create all the formulas etc.... - Modify an existing workbook with new information - Automate the import of current workbooks - Automate the creation of rows, columns, and formulas The frequency of these tasks will be dictated by our data download schedule which is done on an as-needed basis per job schedule. Ideal candidates will have a solid background in Excel automation and demonstrate some proficiency in either Python, VBA (Visual Basic for Applications) or C#. Please provide samples of similar Excel automation work that you have ...

preferably a VBA solution, as per file, when click the 'generate' button to have multiple customer's details into one row in next sheet

I am seeking a freelancer possessing a strong command over Excel, VBA, and familiarity with Solver and Holt’s Winter Smoothing. Your task will entail: - Building a sales forecast analysis model using VBA in Excel. Detailed experience with Solver and Holt’s Winter Smoothing is crucial, as these tools will be heavily relied upon for seasonality adjustments and trend forecasting. - Developing a well-documented mini report highlighting the process, results, and interpretations. Effective communication and report writing skills are essential. - Incorporating historical sales data provided by me for analysis. Being able to interpret and manipulate large data sets is a critical component for this job. Previous experience in sales forecast analysis or similar projects w...

Excel VBA Automation- As discussed.

NPV, SIM, Covar and general coding in VBA

Hi! Hi! I have the detailed the flow of the screens in the photo attached in the project. 3 roles(sutdent, teacher and admin). To have acces to that linked spreadsheet screens with the fow that are detailed in the photo (in same style web app that home-10) lINKS with screens and roles: https://docs.google.com/spreadsheets/d/1Sz4KagkU_VcenA4KL6uW1b79Or6wcPsNsn48-Rv7m8o/edit#gid=0 (FLOW ATTACHED IN PHOTO) HOME DEFAULT (the style all thefrontend) Backend in NodeJS

I'm in need of an Excel VBA expert who can write a VBA routine to alter the font of a string. See image attached Sub BookLabel() Select Range StartLabel (H2) Select first x characters of string where x = value in cell F2 Set font =16 Font = Bold Down 1 cell Repeat same Continue to loop until some statement such as “End”, below the last record End Sub

Hello. I need to extract the values from this website in a spreadsheet (CSV or XLSX) in an automated way and every 10 minutes: . Must be with a VBA Macro and no required nothing special, only plain text in rows and columns (see attached). You will notice that it corresponds to a website with information about sports betting. The fields to be extracted are ALL the ones you can see per game. For example: - Sport - Country - Championship - Date and time of the event - Equipment - Type of bet (Home/Away, Over/Under 2.5, Final result, etc.) - Etc. Also note that "surebets" with 2 and 3 results appear, depending on the nature of the bet. If you have any doubt, ask me. Look at next examples of 2 results, but 3 results is seemed, adding more columns at the

I am currently looking to make alterations to an existing VBA Skyline chart. Specifically, I need assistance with: - Adding dates to the Form Labels. The dates in question will be the Plan Date, Actual Date, and Forecast Date. - Adjusting axis labels. - Changing the chart's color scheme. The ideal freelancer for this project should have substantial experience in working with VBA Skyline Charts and data labels modifications. They should also have a keen eye for aesthetic details such as color schemes.

I require an Excel expert with in-depth knowledge in VBA for developing a comprehensive invoicing system. I have my qr scanner when I scan product it's shows products details automatically. I attached 5 list of products. Your Task: * Create VBA macros to automate system functionalities * Design invoice templates that encapsulate professionalism * Implement automation for data entry tasks Purpose: The overarching purpose of the invoicing system is to streamline the tracking of sales and payments, automatically calculate finance-related aspects, and generate professional invoices that accurately represent our company. Required Features: * Ability to generate insightful reports on business financial trends * Functionality to send automated reminders for payments * Integ...

I'm in need of a seasoned AutoCAD VBA coder to help me create a functional module for AutoCAD 2024. The core functionality involves: - Copying drawings from one file to another. - Locating the copied drawings within the new file. It's crucial for the module to guarantee that all original attributes and settings are retained in the new file. Ideal candidates should have considerable experience with AutoCAD 2024 and expertise in VBA coding. Please provide examples of your past work with similar projects, if available.

I'm in need of an AS400 expert to provide all-around support to my small-sized environment. Requirements - Comprehensive AS400 support including programming, database, and system administration. - Able to manage a user base of fewer than 50. - Advanced expertise in AS400 programming support. Skills and Experience - Proficient in AS400 system. - Past experience in configuring and troubleshooting AS400 systems. - Strong understanding of AS400 database structures. - Proven experience in AS400 Programming with advanced expertise.

I am seeking a proficient VBA developer who is well-experienced with Excel, particularly in graphical data representation using charts. The project entails improving a skyline chart. Key tasks include: - Modification of the existing skyline chart using specifically Visual Basic for Applications (VBA). - Ensuring the enhanced chart operates efficiently within Excel and handles statistical data accurately. - Testing the final product to confirm accuracy and functionality within various data scenarios. The ideal freelancer for this project will have: - Strong expertise in VBA programming. - Familiarity with Excel functions. - Significant experience in handling and representing statistical data in charts.

Hi, you did an excel vba macro for me in 2019. It worked fine until now but it just broke, its not working anymore. can you help fixing it?

I am in need of a professional to help me create a toolbar plugin for PowerPoint 365. Key Requirements: - Must be able to translate an already created toolbar with VBA code into a comprehensive PPT add-in package. - Must be ready to review the existing codes and functionality I have developed so far. Ideal Skills: - Familiarity with PowerPoint 365 and its functionalities. - Proficiency in VBA scripting and creating PowerPoint add-ins. - Strong knowledge in plugin development and toolbar customization. Please note your experience in similar projects in your bid, and any ideas you have to enhance the toolbar based on your experience will also be appreciated.

• Strong Hands-on experience in IBM AS400 iSeries platform and RPGLE programming is a must. • Experience on one of the IBM I Supply chain management/ERP applications is a must(PKMS or Infor LX/BPCS). • Experience on migration projects ( From IBM I applications to SAP migration by writing the effective interfaces) • Sound technical knowledge in Integrated Language Environment (ILE), free-format RPG, SQLRPGLE, Subfiles. • Experienced in Creating and debugging RPG/CL programs. • Ability to handle Client requirement, creating design document and walk them with client. • Experience in Designing, Development and Support of Software Products/ Applications in the AS400/ iSeries environment • Technical proficiency in relevant lang...

I have a simple Excel VBA macro file (attached). The file shows up an additional toolbar on my personal PC, but does not show toolbar on client's PC. NOTE: The client can still run the macro code using the button placed on the grid. I just need to know the right group policy that needs to be setup correctly.

As the client, I'm seeking a skilled Excel VBA macro specialist who can create an automated system for a repetitive task in our operation. The task in question involves a data entry form consisting of Product, Quantity and Price fields that needs to be automated. As a professional with deep knowledge in Excel VBA, automation and data entry, you have: - Proven experience in crafting Excel VBA macros. - Proficiency in automating repetitive tasks. - Extensive understanding of data manipulation. - Excellent knowledge of Excel formulas and functions. Your main job will be to create a macro to automate this data entry form. This will involve auto-filling data into the respective form fields where necessary. This efficiency-generating macro should serve to eliminate ...

Please submit your original charges in bid for this project For this project, I'm looking for a talented programmer who is highly-experienced in working with MySQL and Excel VBA. Your task will be to create a MySQL table with 3 columns. This table will be used in conjunction with Excel VBA to import data. Here are some specifics about the project: - The Excel sheet contains similar data types in a single sheet. - The data type is primarily text strings. - We need a VBA process to export these Excel data strings into our newly created MySQL table. Ideal Skills and Experience: - Expert knowledge in MySQL and Excel VBA. - Proven experience in data import/export between Excel and MySQL. - Detail-oriented and accurate in data handling. - Focused on meeti...

My project requires a proficient programmer familiar with Excel VBA and MySQL integrations. I'm seeking a solution that incorporates: - Database creation, modification, and updating - Data import and export via Excel VBA The VBA code should be capable of following tasks: - Reading data from the MySQL database - Writing data to the database - Updating existing data - Deleting data I'll be working with various kinds of data, including: - Text data - Numeric data - Date and time data - Binary data Knowledge of Excel VBA programming and MySQL database management forms the crux of this project. Experience in handling different data types and proficiency in database operations will be of paramount significance.

Insert catalog items(products) on WordPress WooCommerce plugin shop this products are (69 items men category ) and (61 items women ) When Entry the item chooses the category of the color of the bottle of the produ...WordPress WooCommerce plugin shop this products are (69 items men category ) and (61 items women ) When Entry the item chooses the category of the color of the bottle of the product(item) All item has a price of $7.000 Cops Acces keys.

I am struggling with a VBA Excel file where the Macro is not running correctly, and I need someone proficient with VBA and debugging to fix it. The file is crashing frequently, which is causing significant delays and impacting efficiency. • **Macro Issue:** The macro is not running and I am unable to debug or fix it myself. I need an expert who can look into the problem, define what's wrong, and provide a solution that works flawlessly. • **Purpose of the Macro:** I will discuss this further with the successful applicant, but rest assured that your tasks will align with typical VBA Macro functions. Since the purpose of this macro hasn't been disclosed, I am expecting you to have experience with commonly used VBA functions like automated dat...

I am looking for an experienced VBA developer to create a custom add-in for Excel. This project will require: - Developing custom functions to automate the generation of multiple types of charts in Excel, specifically pie charts, bar charts, and line charts. - These charts should be formatted according to our specific design requirements, including our house style and measurements. The ideal freelancer will have exceptional skills and experience in VBA and Excel add-in development. I expect a strong understanding of data analysis and an excellent ability to perform tasks accurately and efficiently. Furthermore, I value clear and regular communication so we can ensure the end result meets our expectations. Please only apply if you are confident you can deliver these tas...

As an entity constantly dealing with vast amounts of data, I need a proficient Excel VBA expert to assist in automating my reporting and dashboarding processes. An ideal candidate for this project should possess the following: Skills and Experience: • Extensive experience developing VBA Macros • Capability to generate reports automatically • Familiarity with handling data across multiple sheets Specific Tasks: • Developing macros to automate data retrieval from sources such as Excel workbooks and CSV files • Implementing these macros to streamline the process of report generation and dashboard updates By simplifying these tasks, this project will enhance our overall productivity and data management processes. It is crucial that the expert maintains...

I'm looking for an expert in Microsoft and Visual Basic for Applications (VBA) to streamline my repetitive financial data entry tasks. Key Tasks: - Develop a VBA script to automate the entry of financial transactions Ideal Profile: - Proficiency in programming with Microsoft and VBA - Previous experience in automating data entry, preferably financial transactions - Strong attention to detail to ensure accuracy in data entry automation - Basic understanding of financial transactions for effective development of the automation system The successful freelancer will create a simplified and efficient data entry process that eliminates the manual input of financial transactions. Attention to detail, speed, and efficiency are vitally important for this project.

I need to redevolop a simple shopping cart based on Excel VBA. Requirement is to rework current design and function. I prefer developer that can with russian and english language, as this would help get some information from former versions. Pls contact me. BR Michael

I am seeking a dedicated and experienced VBA developer to build an inventory management software that tracks both physical and digital products. Key Features Required: - Inventory Tracking: The system needs to provide accurate and updated record of both physical and digital goods. - Purchase Order Management: An automated reordering function based on predefined parameters is paramount for the efficient operation of our procurement process. The ideal freelancer should have a strong background in building inventory management systems with Excel VBA as well as in-depth knowledge of automated reordering functionalities. This knowledge is critical in order to assure the success of this project. It's also expected that the candidate is proactive and asks any needed questi...

...set up scripts that format data according to preset conditions. Understanding of and experience with conditional formatting in Excel is critical. - Report Generation: I will require automatic generation of reports from collected data. Your experience with creating automated report systems in Excel will come in handy. In terms of skills, experience with Excel including knowledge in macros and VBA scripting is a must-have. The ideal candidate should have developed automatic report systems in the past and has extensive experience with conditional formatting. This project offers you an opportunity to showcase your ability to automate and bring efficiency to tasks. Looking forward to your bids....

I need a freelance professional with a strong background in AS400 administration to bring me up to speed with managing this system. Key Tasks include: - Providing detailed steps to navigate and operate the AS400 system - Explaining the functionality and features of the AS400 - Teaching me how to perform routine troubleshooting and error handling. The suitable candidate should possess: - Deep understanding of AS400 system administration - Solid experience in imparting technical skills - Strong communication and tutoring skills. Your bid should include a brief overview of your experience with AS400 system administration and how you can effectively convey this knowledge to me.

In need of a seasoned Excel VBA expert to develop a comprehensive techno-economic analysis tool for solar projects. The automated tool should accomplish the following: - Automate data entry - Generate informative reports - Perform data analysis to inform strategic decision-making Key functionalities to include: - Calculation of Return on Investment (ROI) - Estimation of energy production The tool should take the following inputs to calculate ROI and energy production: - Initial Investment Cost - Annual Energy Production - Energy Tariff - Maintenance Cost Ideal Candidate: - Mastery of Excel and VBA - Previous experience in creating financial/technical analysis tools - Understanding of solar energy industry would be a plus

We're looking to edit an existing automated process created years back. Youll have to see the attachments to see the correlation below. We would like to generate a QR codes containing the information below to then be printed on the LP and MP cards (as seen in the ) attachment. MP Card 1) Date 2) Part Type- MP 3) Item Group Number- 1 of # 4) Order Number- ORD0076301 5) Customer Name- Legend senior living 6) Item- Legend senior living 7) MP Material Type- SPL Cordovan (#192) 8) If "No Image"- No Image 9) Item Quantity- 25 10) Product Line- SPL LB Card 1) Date 2) Part Type- LB 3) Item Group Number- 1 of # 4) Order number- ORD0076301 5) Customer Name- Legend senior living 6) Item- 4 Part 411 7) LB Material- Black 5265 8) Corners Material- SPL Cordovan (#192) 9) If

We require expertise in developing an Excel file that utilizes VBA code to automate specific tasks. Primary objectives of the project include: - Creation of an Excel file referenced to a specific dataset - Designing a robust VBA code system to import data from the reference file - The VBA code should perform complex calculations and data transformations pertinent to technical and economic analysis The ideal candidate will have a rich experience in data analysis, particularly in managing, interpreting, and simplifying complex data systems, with a strong proficiency in Excel and VBA code development. Familiarity with technical and economic analysis would be highly beneficial. Please ensure you have tangible examples of similar work to showcase. Accuracy, co...

I am in need of a proficient Excel workbook developer who can design a system from scratch for me. The primary purpose of this workbook is to keep daily track of business transa...particulars such as expense tracking, revenue tracking, profit calculations as well as an end of the month balance sheet, tracking of sales, and out payments. In the Sales and Out Payments Tracking section, it is vital to monitor the quantity sold, payment received, and payment date. A closing sheet is also something I'm interested in. The ideal candidate would be well-skilled in Excel formulae, VBA (Visual Basic for Applications), applied Mathematics and Accounting. The project heavily requires first-hand experience in business finance tracking and reporting. I look forward to discussing more deta...

I'm seeking expert help in .NET / VBA programming for a seamless integration between Excel and Outlook. The primary feature of this integration should be automatic updating Excel whenever new contacts are added to Outlook. In addition, a bulk auto-reply feature is desired. ---------------- Please read the attached proposal file carefully. Besides, before establishing a milestone, we are possible to continue to revise and update this proposal along with its specifications within the discussion threads. Prior to accepting the milestones, please ensure to review all the most updated proposal details and specifications. Let’s confirm we have the same proposal with the same modification time before accepting milestones. ---------- Key Tasks: - Develop an integration ...

Excel vba work Macro to move files

For my ongoing work, I need assistance in converting an existent VBA script from Excel 16 on Windows to properly function on Excel 2016 on a Mac. The script I currently have is responsible for automating a series of key tasks which substantially help my productivity, specifically: - Arranging and sorting my data Successful candidates should be comfortable with both operating systems, have an excellent command over Excel, and a deep understanding of VBA scripting. Prior experience in Excel-to-Mac conversions is also beneficial. This job requires clever problem-solving, meticulous attention to detail as well as the ability to clearly communicate the changes made.

I'm seeking someone with a strong background in Excel and VBA programming to automate report generation. Details: - This project entails using VBA/macro to automate financial report generation in Excel. - The reports will be created from financial data with the primary goal to simplify the overall reporting process. - The financial data involved may include expense records, costings, revenue data, among others. Desired Skills & Experience: - Strong Excel VBA programming skills - Prior experience in automation of financial reporting - Proficiency in data processing and analysis is a plus. - Familiarity with financial data and terminology - High attention to detail with a proactive approach towards problem-solving The completion of this project will enhance...

I Project requirements Phase 1 Build a learning journey in A newspring that showcases the LMS assignment options using layout best practices. (You can copy the assignment options overview of the “Anewpsring Cactus Demo’. Acces to the demo you will find below. But the visual design is nothing short of awful..) Design a good looking website using layout best practices In attached doc you'll find the specfics of the project. RoadmapPay You tell me how much you want to be paid by the hour and estimate the number of hours. 10% under or over fine And if the project requirements change, I’ll get that. Other free lancers will testify for such. I put the money for Phase 1 in Safepay. If you want to reach out through chat I reside in Amsterdam (GMT plus ...

... /resource-management-panel-integration?next=%2Fresource-management-panel-integration%2F591709 IT Requests and Ticketing The IT Requests and Ticketing template set helps streamline IT requests and track outcomes and team performance. You have to build an issue form. I will give you acces to Resource management platform Smartsheet platform What I would like to have is a fixed price, and be aware I have an idea how much time it will cost you. A timeframe. If you are interested, don't use AI to reformulate my project description. Just tell how much it costs, when it will be done. I am aware there's a plan and there's reality... Send me a cost estimate, and if neccessary

I have project need to knkw if it's can be done If you can start now, start your bid with NOW

I have project need to knkw if it's can be done If you can start now, start your bid with NOW

I am promptly looking for an expert capable of converting a VBA script that currently operates on Windows Excel 16 to function on Mac Excel 16. The existing VBA script is primarily used to automate tasks, owing to which, proficient experience in scripting automation and swift task execution is key. - Ideal Skills: Proficiency in Excel VBA, familiarity with both Windows and Mac Excel 16, understanding of task automation via scripting, and the ability to deliver within short timeframes. - Key Ask: The primary function of the script is to automate tasks. While specifics aren't provided, a good grounding in automating generic tasks through VBA scripts will be invaluable. - Timeframe: This job is immediate. I require a swift conversion, with delivery wi...

I have an Excel 2016 VBA script in need of converting to Mac VBA. The converted script is expected to retain the same functionality. Additionally, I require a video tutorial demonstrating the successful running of this new script. The video duration is flexible and it shows the success of the converted script. I'm urgently looking to complete this project. Ideal freelancer should have: - Experts in VBA scripting, especially Excel 2016. - Proficiency in MAC VBA Scripts. - Experience in creating video tutorials. - An ability to complete tasks on short notice.

I'm seeking a qualified individual to efficiently convert a Windows VBA script to operate on Mac Excel 16. This is an immediate job that requires delivery in a few hours. Key Requirements: - The converted script should exhibit specific functionalities on Mac Excel 16 such as: - Automation of tasks, particularly spreadsheet management - Conducting worksheet operations - Accurately applying formulas Ideal Candidate: The ideal candidate will have an in-depth understanding of VBA, familiarity with both Windows and Mac environments, and proven experience in Excel automation. Deliverables: - The converted VBA script that functions successfully on Mac Excel 16 - A video demonstrating the successful operation of the converted script on Mac Excel 16 Looking fo...

I'm looking for a skilled develope...automation system catering to account processing tasks: Key Tasks: - Data entry - Calculation of financial transactions - Report generation - MLM Plan Incorporation with recurring functions Aligned to eventually be accessible online, this system will be primarily used by one administrator. I operate in the consumer industry, so related experience and understanding is advantageous. Proficiency in VBA or Python programming is paramount. Accounting knowledge is also indispensable, as well as familiarity with Multi-level Marketing (MLM) schemes. This project offers an opportunity to create something that could greatly enhance efficiency in consumer finance. Please bid keeping in mind the balance between quality and cost. Looking forward to ...

I require a talented coder skilled in creating Excel macros to automate data entry tasks. The macro shoul...skilled in creating Excel macros to automate data entry tasks. The macro should efficiently handle logical formulas but does not require extensive knowledge in IF statements, AND/OR/NOT or VLOOKUP-HLOOKUP conditions. Key responsibilities include: - Developing an Excel macro that automates data entry tasks - Implementing logical formulas into the script Ideal skills: - Proficiency in Excel and VBA - Strong understanding of logical formulas in Excel - Experience in creating macros and automating data tasks Please note that while this project doesn't have the specific logical conditions, a generic understanding and ability to implement logical conditions if required...

I'm urgently seeking an Excel and VBA professional who can overhaul my current workflow. Key tasks will involve: - Automating a series of repetitive tasks to significantly increase efficiency. - Optimizing a range of statistical formulas in existing spreadsheets. While the complexity of the statistical formulas in the project isn't certain, you should comfortable dealing with both simple and advanced computations. The ideal freelancer for this project should be proficient in Excel and VBA, have a solid understanding of statistical formulas, and a knack for optimizing work processes. An ability to execute tasks quickly without compromising on quality is critical.

I have an Excel VBA simulation program that I require recoded into Python. This project is not about merely translating the existing code, but about enhancing it to extend its capabilities and improve performance. Key elements of the job: - Recoding: You must be experienced in recoding from VBA to Python, translating the existing script flawlessly. - Simulation Presentation: I require an advanced 2D flow chart with interactions. Familiarity with graphic representation and data visualization in Python is required. - Detail: I expect comprehensive details of all operations. Experience in complex project mapping will be beneficial. This project will suit a developer with deep expertise in both Excel VBA and Python, accompanied by a robust understanding of data visuali...