Connexion acces vba iseries as400 jobs
I am in need of an expert Word VBA programmer to: - Develop custom macros for Word documents - Make these macros capable of converting Word files (.docx) to PDF, and vice versa (this PDF file -> .docx) using the website (PDF to WORD Converter) or free API (similar like quality). The ideal freelancer for this project will: - Have in-depth knowledge and experience in Word VBA programming and macro development - Be familiar with file conversion resources such as - Be capable of thoroughly testing the macro to ensure it functions correctly, specifically for document conversion. The goal of this project is not only to automate document conversion, but also to enhance workflow efficiency. If you are keen on taking part in this project, kindly send in your
I need an experienced Excel and VBA specialist to assist with a project that involves data cleaning and generating reports from a CSV file. This file contains dates and times against power usage for apartments and needs to be processed in Microsoft Excel. The job tasks include: - Fixing inconsistent data entries in the CSV file - Extracting time of usage for each apartment - Creating a repeatable VBA script for future use Ideal freelancers will have strong experience in: - Microsoft Excel for managing and manipulating CSV files - VBA for creating automated tasks related to data cleaning and report generation Your help will save me time and effort in terms of managing this CSV file and creating valuable reports in the future. Successful completion of this project co...
...advanced topics, including but not limited to Excel Macros. - For each topic, I need 5 well-thought-out lab exercises created with step-by-step answers. - The exercises must be suitably challenging for advanced-level Excel users. - Each exercise should come with a step-by-step questions and answers guide to aid understanding. IDEAL SKILLS: - Extensive knowledge of Excel, especially in Macros and VBA programming - Proven experience in developing training materials or lab exercises. - Familiarity with financial modeling and data analysis in Excel. - Ability to break down complex Excel operations into understandable steps. - Strong written communication skills. I will pay $30 for each topic (5 labs). I need exercises for 10 topics making a total of 50. You will be paid by each top...
In my pursuit to simplify and automate my Costing-related tasks, I need an Excel VBA utility that is able to perform calculations, specifically advanced financial modeling for cost using VBA & Macros. I require complex projections for various scenarios to be calculated through this utility. This tool should enable me to: - Efficiently perform cost calculation for a project and financial based on inputs - Efficiently calculate the cashflows automatically based on the inputs. - Generate advanced financial projections incorporating different scenarios. Ideally, the freelancer taking this project on would have a robust background in both financial analysis and Excel VBA programming. Proficiency in financial modeling (Including Project cost calculation) and a solid u...
I need an experienced Excel and VBA specialist to assist with a project that involves data cleaning and generating reports from a CSV file. This file contains dates and times against power usage for apartments and needs to be processed in Microsoft Excel. The job tasks include: - Fixing inconsistent data entries in the CSV file - Extracting time of usage for each apartment - Creating a repeatable VBA script for future use Ideal freelancers will have strong experience in: - Microsoft Excel for managing and manipulating CSV files - VBA for creating automated tasks related to data cleaning and report generation Your help will save me time and effort in terms of managing this CSV file and creating valuable reports in the future. Successful completion of this project co...
I'm in need of an Excel programmer who is proficient with VBA. The task involves creating a VBA scroll bar that changes values within a specific cell. The cell's contents should be adjusted in increments of 0.01 through the scrollbar's activities. - Proficiency in Excel and VBA is a must. - An understanding of user interface designs with Excel is ideal. - The candidate should be capable of testing and debugging functions within Excel. Your main goal is to create a VBA scroll bar that can accurately manipulate cell contents. Your work will be deemed successful when the scrolling alters the cell value as per the increment specified. Reach out if you have the necessary skills and can get this job done.
...wizard who is skilled in Visual Basic for Applications (VBA). Your primary tasks will include: - Leveraging VBA within microsoft excel to perform find and replace tasks on external files (.html files) - An excel spreadsheet placed in a folder will be able to... Macro 1 Will list all the files in the current directly in column A Macro 2 Will open and search the files in column A for strings listed in column B and confirm if they were found in Column C (Found or Not Found) Macro 3 Will open and find the string listed in column A and replace it with the new string listed in Column D Given the nature of the project, strong Excel and VBA proficiency is expected. Your skills should include but not be limited to creating macros, utilizing VBA for intricate data...
I have a need for a VBA Microsoft Visio expert. The project primarily revolves around this specific task: - Automation of rectangle geometric shape creation. The detailed requirements include: - Developing a VBA code that can automate the creation of rectangles in Microsoft Visio. - The shapes must be created accurately and efficiently, with minimal margin for error. - Familiarity with geometrical shapes, especially rectangles, is a must. Also Add picture to shape , and grope . The ideal candidate for this project will possess a deep understanding of Microsoft Visio and Visual Basic for Applications. Experience in automating shape creation, specifically in dealing with geometric shapes in Visio, is crucial for successful completion of this project. This knowledge and ex...
I am in need of an expert Word VBA programmer to: - Develop custom macros for Word documents - Make these macros capable of converting Word files (.docx) to PDF, and vice versa (this PDF file -> .docx) using the (PDF to WORD Converter) website. The ideal freelancer for this project will: - Have in-depth knowledge and experience in Word VBA programming and macro development - Be familiar with file conversion resources such as - Be capable of thoroughly testing the macro to ensure it functions correctly, specifically for document conversion. The goal of this project is not only to automate document conversion, but also to enhance workflow efficiency. If you are keen on taking part in this project, kindly send in your bids.
I'm in need of a skilled VBA coder to help enhance the functionality of Microsoft Word. The specific functionalities required are: - Document automation - Text formatting and styling - Data extraction from documents The Word document essentially consists of tables. The tables have different numbers of rows and two columns. The first column should only contain text. There should be a checkbox in the second column. The checkboxes should initially be hidden. The checkboxes should only become visible when you activate the “Show all” function. If the check box is selected, the text in column 1 should have a specific target style assigned to it. If the check box is cleared, the text should be mapped to another style that is defined to have the text hidden. If I de...
As a real estate owner, I need an ambitious Excel expert to develop a professional spreadsheet for managing my properties' rental income and expenses. With each listed property, manual entry will be utilized for inputting income and expense data. In this project, the focus is on tracking individual real estate assets and not t...categories for easy tracking and assessment. - Monthly/Yearly summary: It should provide a clear and concise picture of the monthly and yearly income and expenses, aiding in financial decision making. The ideal candidate for this job should be a seasoned Excel professional with a track record in financial management spreadsheets, particularly properties and real estate. If you have proficiency in VBA, that can elevate the spreadsheet to an even more o...
As the initiator of this project, I'm on the lookout for an intermediate-level VBA specialist. I am looking for someone who have Finance background, While the specific tasks were not laid out, the hired freelancer should be comfortable with various activities, including but not limited to automating data entry, generating reports, and creating macros. The key skills and experience required include: - Proficiency in Visual Basic for Applications (VBA) programming language. - Ability to automate tasks, create macros, and produce reports using VBA. - Demonstrated experience in a similar role or project. Please highlight your experience in your application. Remember, your ability to showcase your skills and past success in this area will significantly impact the...
VBA basics but no time to do it. I have already started the 1 step of the project () Can you please finish it ? Everything is explained on
I am looking for a freelancer who can make moderate changes to my VBA software in Excel. Here are the details of the project: Type of software: VBA in Excel Function or feature: I do not have a specific function or feature in mind for the software, but I am open to suggestions. Level of customization: Moderate changes are needed for the software. Ideal skills and experience: - Strong proficiency in VBA programming in Excel - Experience in customizing and modifying existing VBA software - Ability to suggest and implement improvements to enhance the software's functionality and usability
VBA basics but no time to do it. I have already started the 1 step of the project () Can you please finish it ? Everything is explained on
I'm looking for an individual with proficiency in Microsoft Excel and Microsoft Word to assist me in generating delivery notes. For this project, your tasks include: - Reading data from an Excel spreadsheet and populating it into a Word template for the delivery note. The data to be transferred includes: customer names and...descriptions, and quantities. - Automating this process for all entries in the spreadsheet in such a way that each entry generates a separate delivery note automatically. - Replicating this delivery note for all the 92 notes captured in the Excel spreadsheet. In addition, you will be creating a PDF copy of each finished delivery note. Possessing experience in visual basic for applications (VBA), data processing, and automation will be advantageous...
I urgently require an expert to lift protection from a VBA macro in my Excel 2007 document. A complex password (10+ characters, including symbols) protects the macro. Here's what's needed: - Thorough understanding of Excel 2007 and later - Proficiency in dealing with complex passwords - Demonstrable experience in unlocking protected VBA macros The document itself is not password-protected and remains accessible. However, the VBA macro within is locked. I am specifically looking for a problem-solver with a track record in removing complex macro passwords without affecting the functionality of the macro. Please only apply if you meet these criteria.
I need a freelancer adept at Excel and Visual Basic for Applications (VBA) to assist with a project that necessitates basic data manipulations and formulas. The application is primarily dealing with both numerical and textual data. The ideal candidate should possess: - Proficiency in Excel functionalities and VBA scripting. - Experience with handling diverse data types like texts and numbers in Excel. - Ability to quickly comprehend and effectively manipulate data structures using VBA. Kindly submit your bids if you meet these requirements and can efficiently solve complex data problems.
...analyst-forecasted growth rate, and the expected industry P/E ratio. 2) Support work a) Well-structured and well-labeled worksheets and VBA code to support your presentation Questions to consider and take into account for the finished project Is the spreadsheet's broad purpose immediately obvious? Is the output of the spreadsheet AND its meaning clear to the user? Is your analysis correct? Are there any hard-coded numbers (other than numbers that would never change in the formulas? Can the user (or developer for some of the assumptions) change each assumption and see that the model adequately reflects changes to each assumption? Are all cells and the VBA code labeled appropriately? Does the spreadsheet look aesthetically pleasing? (Yes, colors matter...
Hi Need to send and receive e-Mail from G-Mail. Need to use oAuth2
I am looking for someone who can transfer my current VBA code into GCP Big Query stored procedure. This basic VBA code is readily available for conversion. Primary Requirement: - Maintain the 'IF ELSE CONDITION' functionality of the current code during the conversion process. Ideal freelancer: - Experienced in converting VBA code into GCP Big Query stored procedures. - Skilled at preserving specified functions through the conversion process. - Good understanding of basic VBA code structures. - Excellent problem-solving skills in case any issues arise during the conversion process. Your expertise in this area will not only help in preserving the original functionality of my code but also enhance it using GCP Big Query's features.
I'm in need of a detail-oriented professional for a simple data entry job. The core of the work includes: - Transferring information from PDF files into an Excel spreadsheet - Ability to accurately input raw data without altering information Ideal skills and experience: - Proven experience in basic Excel data e...into an Excel spreadsheet - Ability to accurately input raw data without altering information Ideal skills and experience: - Proven experience in basic Excel data entry - Proficiency in handling PDF files - High attention to detail - Fast and accurate typing abilities Please note, this project doesn't call for intermediate or advanced Excel techniques like formulas, data sorting, pivot tables, or VBA. The successful freelancer will strictly be transferring dat...
I am looking for someone who can transfer my current VBA code into GCP Big Query stored procedure. This basic VBA code is readily available for conversion. Primary Requirement: - Maintain the 'IF ELSE CONDITION' functionality of the current code during the conversion process. Ideal freelancer: - Experienced in converting VBA code into GCP Big Query stored procedures. - Skilled at preserving specified functions through the conversion process. - Good understanding of basic VBA code structures. - Excellent problem-solving skills in case any issues arise during the conversion process. Your expertise in this area will not only help in preserving the original functionality of my code but also enhance it using GCP Big Query's features.
I am in need of a professional who has experience using VBA in MS Project to automate the process of generating project summary reports. Key tasks include: 1. Utilizing VBA to automate the generation of project summary reports. 2. These reports must provide a list of all tasks and their current status 3. in particular how to create a table of all tasks related to a Milestone - similar to Task path function for predecessors. The ideal freelancer for this project should possess strong skills in VBA and Microsoft Project. They should have a proven track record in automating and streamlining reporting processes. Previous experience in project management reporting is highly desirable. I'm looking for someone who understands project progress reporting and can deliv...
...affecting my code. Specifically, it is producing incorrect outputs when engaging with certain external systems. Key tasks include: - Identify the root cause of the output error - Troubleshoot and rectify the logic flaws causing these errors - Make sure code is efficient, secure, and maintainable The ideal candidate for this role will have: - Proven experience working with Lisp and Autolisp even VBA. - Troubleshooting and debugging expertise - A good communicator that can take my rudimentary directions. To make it short, I have a code that is used for underground drilling permits in the CAD environment. I have a LISP suite that stations a line by generating notes, that generates MLeaders when the subject of the permit crosses a utility lines and puts it on the layer automa...
I'm in need of an expert in VBA programming and Crystal Reports integration to enhance and extend the functionalities of an existing form in our program. - The form was created with VBA for the purpose of data entry. - The enhancement would involve adding more features to this existing form. - The extension requires integrating it with Crystal Reports for more efficient and agile reporting. - Moreover, I'm looking for someone who can provide ongoing support as needed. The ideal freelancer would have extensive experience in VBA programming, form design, and Crystal Reports. Your portfolio or a demonstration of a similar task you've completed would be much appreciated. A commitment to provide ongoing support on an as-needed basis would be a bonus.
I'm seeking assistance with my Microsoft Access project involving the creation of queries, forms, reports, and a comprehensive description of the databa...after project commencement) - Creation of 2 forms: A Main and a Subform. The main form is to be designed for data entry. - Devising 2 reports based on set requirements (to be disclosed upon project initiation). - Crafting a detailed written description of the entire database system using a provided template. Ideal assistance would come from someone with proven experience in Microsoft Access, SQL, VBA, and database development. A deep understanding of query development, form creation, and ensuring data integrity within Access databases is crucial. Your ability to communicate effectively to explain complex systems will also ...
I'm looking for a professional with Excel VBA expertise who can swiftly help in automating the process of printing specified worksheets from Excel to Word. Here's what's important: * Excel VBA proficiency: This task calls for specialized knowledge of Excel VBA, so your skills in this area will be pivotal. * Existing VBA: I will share the existing vba, the VBA has many tools including the print. * Enhancement required: the existing vba has print funtion where user can print specific sheets, we need to print or covert these sheet to a word file. * Quick Turnaround: I need this project completed ASAP, so ability to work under pressure and deliver on time are key. Please ensure you check the requirment carefully before bidding....
I have an Excel document that needs to be updated by reading data from a TXT file. The process must be automated via a script, filling in blank cells, distribute...within the excel document, in the required cells. 3. In the case of data discrepancies within the TXT file, enable an automated resolution by defaulting to a specific value. Leveraging your expertise in data extraction, manipulation, and Excel automation will be instrumental for this project. Ideally, you are proficient in scripts suitable for handling such tasks, debatably the likes of Python or VBA, contingent on your recommendation. Familiarity with Excel data structure is a must. Furthermore, being adept at handling data discrepancies and implementing default values coherently across diverse data entries will be b...
I am looking for a script to automatically add 7 days to a date in a table. The date format is dd/mm/yyyy and the date is located in the column "Not done late +35D". The result should be a new column with the date + 7 days, called "Not done late +42D". Specifications: The script must work on Microsoft Word. The script must be easy to use and does not require any programming knowledge. The script must be compatible with recent versions of Word (2013 and above).
I have 2 unfinished Access/VBA projects. I need assistance to finish the projects. My estimation is 3 working days. Max budget : 100$ Please note that I m also a freelancer. Thanks for you bid
I'm experiencing an issue with my VBA code not running as expected on my Mac with Office 365 version of Excel. I am also receiving error messages when attempting to run the code. I'm in need of a freelancer with a strong background in: - VBA Programming - Excel - Debugging - MacOS, specifically the Office 365 version of Excel Your task will be to inspect my code, identify the issue causing it to malfunction, provide fixes, and guide me through the process to avoid such problems in the future. Your debugging skills will be paramount and your ability to communicate clearly is desired. I expect prompt resolution of this issue, without any loss of original functionality. Please ensure you have the specified skills before making a bid.
I'm seeking an expert in VBA coding, financial dashboard design, and crafting Power BI presentations. This project's focus is to: 1. Develop VBA coding 2. Design interactive and dynamic financial dashboards 3. Create an engaging Power BI presentation The ultimate goal of the dashboard and presentation is to: • Thoroughly analyze financial data • Visualize the company's financial performance in a compelling manner • Present clear and concise financial insights The types of financial data that will be included in the dashboard and presentation encompass: • Revenue • Expenses • Profit/Loss • Cash flow • Budget Ideal candidates possess in-depth experience with VBA, financial dashboards, Power BI, and prove...
I'm in need of an expert in VBA programming and thermodynamics to create a VBA code for vapor-liquid diagrams compatible with Microsoft Excel. The code should be flexible enough to work with any two components. The following skills and experience are required: - Proficient in VBA code in Excel - In-depth understanding of Thermodynamics Key requirements include: - Usage of the Wagner equation - equation for the saturated pressure : p_i^* (T)=exp((Aτ+Bτ^1.5+C^2.5+D^5)/(1-τ))×P_c. - bull point equation P= 1/(y_a/(p_a^* (T_pr))+((1-y_(a)))/(p_b^* (T_pr))) - dew point equation P= x_a p_a^* (T_pb )+(1-x_a)p_b^* (T_pb) - Ridders method to find the right temperature for dew point and bull point - The code must be compatible with Microsoft E...
...below to be automatically looked up from the values within Table above. Each quarter the Table above will change in terms of the values in the two right columns, and the number of rows will also change. I would like the paragraph to again automatically lookup the referenced values from the new Table. Expertise in Word automation and document editing is essential for this project. Familiarity with VBA scripts for Word or similar is also very beneficial. The chosen applicant should demonstrate an understanding of Word functions, automation techniques, and table editing. In a nutshell, I want a system where I don't have to manually change numeric values within the text every time the Table data updates. Sounds like you? I look forward to reading your detailed proposals!...
I urgently need an expert in Excel VBA who is highly skilled to create a tool capable of storing passwords securely. This task is critical and needs immediate attention. Key Requirements: - Development of an Excel VBA sheet with password storage functionality - Emphasis on security measures: While I skipped the question related to specific security measures, the chosen freelancer should be competent in advising and implementing the most appropriate ones such as data encryption, file password protection or two-step verification to ensure the highest level of safety. Ideal Skills: - Proficiency in Excel VBA - Expertise in data security principles - Knowledge about password storage and encryption - Capability to work under tight deadlines Given the urgency of this pro...
I'm in need of a skilled freelancer who is an expert in Excel 365 and specifically skilled in VBA automating tasks. The main function of this role includes: - Automating tasks in Excel 365 - Utilizing VBA to generate regular reports - Should work in Windows and Macbook both The ideal candidate for this project has strong experience in using Excel 365, with specific knowledge in automating tasks through VBA. I am especially interested in those who have a proven track record of generating regular reports using VBA. Please include examples of similar work in your proposal.
More details: What subject is the classwork for? vba What is the specific task or problem you need help with using VBA? Creating macros for repetitive tasks What type of macro functions should the script perform? Filtering and sorting data
...regarding Excel VBA. Unfortunately, during my preparation, I encountered difficulties using ChatGPT for the exam, which was not successful. Additionally, I faced a delicate situation when it turned out that I had used a portion of a friend's work to help me, which was noticed by the professor since my friend's name was on the Excel file. I am simply seeking an expert specializing in automating tasks in Excel using VBA. The main focus of this project revolves around automating data entry processes. Here, efficiency and accuracy are paramount. The main responsibilities include: - Automating data entry in Excel using VBA - Enhancing the speed and accuracy of data input - Implementing error-checking measures to ensure data integrity The ideal candidate sho...
More details: What subject is the classwork for? vba What is the specific task or problem you need help with using VBA? Creating macros for repetitive tasks What type of macro functions should the script perform? Filtering and sorting data
I have 8 lines of attached php code working fine and operational. I need help to convert it into MS Access VBA
...updated every second. Example: I will give Seconds to Minutes Interval(30 sec to any Minutes) value is one cell, If i give value in excell cell, It start copy the live data value in Ex: Live data in Col A If give 1 min interval A col value copied into F col if one minutes end A col value again copied in G col G-F value stoted in H col then G col value assigned F col- Repeat this process in Excel VBA I need an intelligent programmer, who can see future problems and solve them clever and independently. Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet is 175 INR and Good review, Dont expect more I am not big fish. it is difficult job d...
...updated every second. Example: I will give Seconds to Minutes Interval(30 sec to any Minutes) value is one cell, If i give value in excell cell, It start copy the live data value in Ex: Live data in Col A If give 1 min interval A col value copied into F col if one minutes end A col value again copied in G col G-F value stoted in H col then G col value assigned F col- Repeat this process in Excel VBA I need an intelligent programmer, who can see future problems and solve them clever and independently. Note: I dont know about coding, If you install the code and run successfully at my system thereafter I will hire you and release the payment. If you agree this term you will apply this task Budet is 175 INR and Good review, Dont expect more I am not big fish. it is difficult jo...
We have reports generated automatically on daily basis (i have attached a sample for one day 01/01/2024). You may create other days till end of month by changing the alphabets in "Work ID" accordingly. The aim is to consolidate all the days automatically, with the following conditions. - flexibility to choose which date (i may be asked to focus on certain dates only) - to consolidate only Work Status : Completed - to choose which Work Type accordingly (i could just add/minus in the script itself, as we have LOB 1, LOB 2 etc) - once consolidated, there is need to remove duplicates on Work ID as some cases were added accidently from previous day
...in ECU data and parameters - Proficiency in data extraction and analysis This API will be tasked with extracting complete ECU data, specifically: I am searching for an expert developer who can proficiently build a WinOLS API system. The core function of this system is to identify variables, denote the names of different versions, and successfully import changes to the actual file. (an API that acces to a Folder or Server where are stored all ols files, identify variables, names of versions, and import changes to actual file..and sends to the customer..) want to make an online service with custom front-end accounts that will be using Winols tuning software database (over custom front-end) to apply features to clients uploaded files. Custom API to make it work is required. windo...
I'm looking for a f...need to create a system where the embedded values are updated automatically whenever the source Table changes. This should occur without the need for manual intervention. - I highly value clear, precise work and would like to see detailed project proposals outlining your approach to this task. Expertise in Word automation and document editing is essential for this project. Familiarity with VBA scripts for Word or similar is also very beneficial. The chosen applicant should demonstrate an understanding of Word functions, automation techniques, and table editing. In a nutshell, I want a system where I don't have to manually change numeric values within the text every time the Table data updates. Sounds like you? I look forward to reading your...
I am searching for an expert developer who can proficiently build a WinOLS API system. The core function of this system is to identify variables, denote the names of different versions, and successfully import changes to the actual file. (an API that acces to a NAS where are stored all ols files, identify variables, names of versions, and import changes to actual file..and sends to the customer..) want to make an online service with custom front-end accounts that will be using Winols tuning software database (over custom front-end) to apply features to clients uploaded files. Custom API to make it work is required. windows api and online access api About feel of usage.... customer don't want to know that its using winols therefore we need custom look enviroment for this API...
I have a specific ACCDE file that needs expert attention. The required tasks for the freelancer include: - Customization of forms and reports in the ACCDE file. This ACCDE file has forms where users can input the data, I would like to export this data into excel/csv or SQL (whichever is conviniant) - Current challenge is, unable to look at the VBA code or export full columns how in the form. The ideal candidate has extensive experience with MS Access, specifically in the customization of ACCDE files and data exportation. They should have in-depth knowledge of form and report design as well as MS Access to Excel/CSV data migration.
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
