Visual Basic Jobs

I need a macro for Excel 365 that will allow me to export specific columns of data to a new CSV file. The exported file must be in CSV tab delimited format. The criteria for selecting the data to export will be based on specific columns. I also need the macro to match data in the other 4 sheets and delete certain rows based on criteria before exporting. Ideal skills for this job include experience with Excel macros and proficiency in VBA. Match, Delete and Export Excel 365 Macro This project is based on the enclosed sample active workbook, which has the following worksheets (one in each tab, labeled: Cases, Casework, Comments, Contacts, plan_request The macro should run in Excel 365. The macro should basically delete all the entries from a specific “Issuer State” (eg: HI...

I am looking for a freelancer who can develop a VB trading software for me for stocks. Developer should have good background working with stocks, trading related platforms and must know how to code on VB. More details through chat.

i need the excel macro only for multiple jobs. Details will be discussed.

I am looking for a freelancer who can create a vb.NET demo form that can handle opening and saving files with a zip file built in. The specific file format that I want to work with is *.zip. In addition to the basic functionality, I have specific features in mind that I would like to include in the demo form. I am looking for a freelancer who has experience with vb.NET and is able to work efficiently and effectively to deliver a high-quality product. The ideal freelancer should have experience with file handling and zip files in vb.NET. Thank you for your interest in this project.?

I am looking for a freelancer to create a Stock In & Stock Out Register for my business. The register will track Finished goods and will require Inventory tracking. The stock will be updated daily, so the system will need to be able to handle frequent updates. Ideal Skills and Experience: - Experience in creating inventory management systems - Knowledge of database management systems - Ability to integrate automated alerts for low inventory levels - Experience in creating customized reporting features for inventory data - Strong communication skills to ensure a smooth implementation process.

Hey there, I have an Excel template that is in need of some repair. Specifically, I'm having issues with the calculations and formulas - both of which seem to be at fault. I'm currently using Excel 365, the most recent version. I'm not sure what I'm doing wrong, but thankfully, I know just where to look for help! I'm looking for an experienced Excel expert who can help me fix this template as soon as possible. Can you help me get back on track?

Convert multiple excel financial models into VB.net and SQL server. This application should convert all the formulas and macros implemented within the excel models into VB.net and SQL server. The data has to be imported into an SQL server DB.

I am looking for a skilled developer to work on a legacy Visual Basic 6 (VB6) desktop GUI VB Form project with database access. The primary purpose of the VB6 desktop GUI form is data entry. The project requires working with an existing database structure, which is already set up. The database system being used is Oracle. The feature of the desktop application GUI is to modify a few fields in a DB table (less than 10 fields), keeping the access logs. There is already an existing VB desktop application with source code, the task is to add additional GUI access VB Form for the above mentioned data access. Ideal skills and experience: - Proficiency in VB6 desktop GUI form development - Familiarity with Oracle database system - Ability to work with an existing database structure - Experienc...

Files are available at this link: :f:/g/personal/naveen_yourit_team/Ep8cJJyW2k5PpaPDsdTxC1QBrP8jvzrloD48yLTIJYa-aA?e=BNlms0 ********************************************************************** Requirement: Scope 1: Need an installer file or setup file (EXE) that would load 3 files a) - Install this PPAM file so it is available as a new ADD-IN file in PowerPoint b) - Load this as the default Theme/Template in PowerPoint c) - Load this file in C:UsersUserAppDataLocalTemp Please note, the PPAM and PPTX files listed here will get changed later. As of now, these are sample files for testing. The deliverable: EXE file - Similar to the file () Full Visual Studio Project/Solution folder so I can modify it on my end. ***************************************************************...

I have an Excel sheet and want to dynamically fetch data from some rows and display user forms accordingly. I have an Excel workbook, it has 4 sheets. 1. General: in this sheet, the user can enter different space types at the bottom. So what I want is, as the space type is entered, dynamically buttons are added on the second sheet (mechanical), with names the same as the space type names the user entered in the general sheet. now when the button is clicked I want a form to be opened in which the user can enter values, and those values are then pasted on the specific cells, and a similar should happen in other two sheets named electrical and plumbing i have already done the dynamic creation of buttons but i am stuck on how to trigger the on click and display the user form in vba

I am looking to build a spreadsheet system to help with the design of a complex harness assembly. The spreadsheet should be able to assist in organizing wire connections, while taking into account the existing template and format that I have provided. This spreadsheet will need to be compatible with Microsoft Excel. It needs to generate new tables as data is input into the sheet and needs to validate and/or provide options via drop down box for data input.

I have an application that (on some computers), the PNG background, is cut off in some parts, and the windows wallpaper is seen. Why could this problem be? What is it related to? To those interested, who demonstrate knowledge, I will send a screenshot.

I am in need of a freelancer to update my BAP Map by updating existing locations. I am looking for someone who has experience in map creation and updating. Preferred Format: - Embeddable map / Static map - for display on websites, not interactive. Timeline: - Within a week Ideal Skills: - Experienced in map creation and updating - Proficient in using mapping software - Attention to detail - Ability to work efficiently under tight deadlines Responsibilities: - Update existing locations on the BAP Map - Ensure accuracy of location information - Provide an embeddable map format If you meet these qualifications and can complete this project within the given timeline, please apply.

Objective: The objective of this project is to revamp and re-develop the existing In-Plant Management System (IPM). The current application, developed in Visual Basic with MS Access as the backend database support, will serve as a reference for the new development. Dispense Program and Management System: The primary focus of this project is the development of a Dispense Program and Management System software. The new software should function identically to the existing VB program. It will provide operators with a user-friendly interface to accurately mix chemicals, resulting in the production of a specific amount of color. Performance and Technology Upgrade: The new system will be built using the latest technologies and architecture to enhance performance and scalability. The foll...

We need somebody who is an expert in C#/AJAX. Our Application is throwing access error while processing data of more than 5 facilities on Production server, Its working fine on test environment. we need somebody who can find the solution to this issue.

It is 1an excel file (in spanish) but no problem, its only mathematics, simple pivot tables that requires; 1) unlock it (if you can) or make a copy and Remove expiration date (December 2023) (I dont have the password) 2) make little improvements to this file 3) add a password (if someone copies this file for me from the internet or in my computer or laptop) Only few formulas I assume one unlocked, you can edit any column or add formula (I Know how to do it) but dont know about If it affects the dynamic tables when making the change of whole numbers to decimal numbers in a specific colum More info, i can send a link to check the file.. If you are interest, I will not pay more than 10us dollar

Specific Requirements The data received from Vivino wine rating IT department comprises three data files: , and Region.xml. The file records the information of wine list across the world which detailed information about their ratings is recorded in and records the country of each wine region. You are asked to: 1 Import all the data from the other files into the Excel file. Write Excel formulas to fill the last three empty columns in the file with appropriate information provided from the other files. 2 Assess the data and correct it if necessary. You are also required to use Excel functions to automate the correction. 3 Investigate the data distribution of wine price by drawing its histogram and boxplot and providing your insight. 4 The company wants to collaborate with the favourite...

I am looking for a freelancer to create a PowerBi dashboard for my business that will primarily be used for performance tracking. The data sources for the dashboard will be Excel spreadsheets, and I am looking for custom visualizations to be included in the design. Ideal skills and experience for the job include: - Proficiency in PowerBi and dashboard design - Experience with Excel spreadsheets and data analysis - Ability to create custom visualizations and charts - Strong attention to detail and ability to meet project deadlines.

Excel has raw data in excel related to valet system Need to analyse and present valuable insights out of it

I am looking for a freelancer who can help me with my Microsoft Excel project. The purpose of the spreadsheet is for data analysis, specifically with the use of Pivot Tables. I am looking for someone who is experienced in using Pivot Tables and can assist with creating charts and graphs for data visualization. Ideal skills for this job include: - Proficiency in Microsoft Excel - Experience with Pivot Tables - Knowledge of creating charts and graphs in Excel If you have the necessary skills and experience to help with this project, please apply!

Need to develop a powerbi quality dashboard that gathers data from multiple excel spreadsheets and visual show daily, weekly, monthly and yearly results automatically.

Looking to have someone develop a data entry program using for data to be imported into excell. Ai integration for data scraping.

i need an Excel programmer with a perfect knowledge. i want to display an Excel graph as hourly base (four graphs on one page). Excel file includes 4 different data (temperature) which obtained in every 10 seconds. User will select the hours from a drop down menu (between hours). please check the given graph carefully. Time frame very limited.

I am looking for a freelancer to create a VBA coded Excel sheet to track test results for my medical history. The sheet should include charts or graphs to visualize the data. No security measures are needed. Ideal skills and experience: - Proficiency in VBA coding and Excel - Experience with medical data tracking - Ability to create visually appealing charts and graphs for data visualization

I need a system that enables bidirectional data transfer between two systems using TCP IP communication. The ideal candidate should have experience in developing applications that enable seamless data transfer between different systems. Additionally, the project requires the use of platform-specific languages. The candidate should, therefore, be proficient in the relevant programming languages and platforms. As for security, I am open to suggestions on the appropriate level of encryption needed to secure the communication. Skills required are VB.Net Specific Only

I need an advanced excel user to create a simple dashboard. Though it is simple advanced user is needed as we need to link the excel to larger dashboard. Excel will be shared on server online so activeX does not work. We have desktop version of same dashboard but when we put that into web, it does not work. Because of data confidentiality we can not give that for verification and it is larger in size. The actual requirement we will send through message and quick turnaround is needed. We have concern for budget as we will use this assignment to roll over into other areas of our company.

Create vba code for a userform the explanatory data will be sent via chat.

Hey there! I'll need an app for my personal use (I would be the only one to have access to this App). Basically, the app would read a row from a source spreadsheet from Google Sheets, then it would modify others spreadsheets accordingly to what is found in the column I and J (ex. if column J = France and I = Orange, modify 'France Orange spreadsheet'. If column J = France and I = Blue, modify 'France Blue spreadsheet') with data from source spreadsheet. The app would then export the destination spreadsheet to a .csv file. The app would then open an Adobe Illustrator file accordingly to data found in columns I and J from source spreadsheet. Then it would open the .csv file as a variable library and export the result as a .pdf file. Then it would convert the .pdf to ...

Create Hlookup or customer formula to refer the data from the right table and populate on the main runrate table. All particulars have been given. Regional and Baseline are drop down list Data should be automatically populated from the right side table based on the options selected in this two drop down list. Should be done straight away ASAP right now over screenshare call

1. sign nda and ip agreement 2. create windows based desktop to do list with all standard features Task Description: A clear and concise description of each task or item to be completed. Priority: Assigning a priority level to tasks, such as high, medium, or low, to indicate their importance or urgency. Due Date: Setting a deadline or due date for each task to ensure timely completion. Status: Tracking the progress or current status of each task, such as Not Started, In Progress, or Completed. Reminders: Providing reminders or notifications to help you remember important tasks or approaching deadlines. Categories or Labels: Grouping or categorizing tasks based on different criteria or projects for easy organization and filtering. Notes/Comments: Adding additional details, instruction...

1. Divide the products into sections and calculate the total volume of each category (section) of products in money; 2. Calculate the total volume of Cameroon's exports for these products; 3. Determine the largest part of the trade value of each section using any Excel tool.; Next, on a separate sheet in this table, you need to draw a conclusion from this data containing several indicators. To do this, you need to transfer the received data of each section to a newly created sheet in this table. Next you need to create a pie chart and determine the largest and smallest export section. This is a time sensitive task and needs to be completed within a few hours.

Dear All, I want the code below to be changed to dapper with database access on vb.net. The code below uses and with mysql database. My goal is to be able to use kimtoo datagridview binding provider with dapper database access Thanks 'Module Connection Imports Imports Imports MySql Imports ServiceStack Namespace Public Module Connection 'constructor Sub New() Try 'setttings for mysql Dim err = ("Server=localhost;Database=demo;Uid=root;SslMode=none;", ) 'settings for sql server 'var err = (@"Server=admin-PCLOCALHOST;Database=demo;Trusted_Connection=True;", ); If err IsNot Nothing Then () (0) End If Catch err As Exception () (0) End Try End Sub Public Sub CheckAndCreateTables() Dim db As = () (Of User)() End Sub...

Hello, I need an app for Android that allows me to register and receive status notifications from various servers on Windows Server and Linux Centos 7: This application must send a tabto status alert via email as to the android app, every time one of the following events occurs on any server: 1- Reboot or shutdown of the server 2- Little Disk Space 3- High Memory Consumption 4- Windows Server license expiration 5- Failed Login Attempts I need a person who perfectly understands the requirements and can work fully

i need ninja trading program update Version saving error

Exporting multiple chart to PowerPoint using VBA

I am looking for a freelancer who can help me sort data alphabetically using the Vlookup function in Excel. The ideal candidate should have experience in Excel and be proficient in using Vlookup. The output format should be an Excel file. There are no additional functions or formulas required for this project. The task is simple and should not take long to complete.

I am looking for a freelancer to create an Excel Gantt chart for my project. The purpose of the chart is to visually track and manage project timelines. Ideal skills and experience: - Advanced knowledge of Excel and Gantt chart creation - Understanding of project management principles - Ability to create a visually appealing and user-friendly chart Project details: - The Gantt chart should be based on an existing template or design - The client has a specific design in mind, which the freelancer should work with - The chart should include automated calculations for easy project tracking and management Customizations needed: - Automated calculations for project timelines - No conditional formatting or custom reporting needed Overall, the freelancer should have a strong attention to det...

Need to prepare a report to visualize data using pivots and other options

I am looking for a social media assistant to help me manage my Instagram account. This project is for personal use only. The primary focus of this job will be to post content on my Instagram profile once a day. This job will require someone who understands how to leverage the potential of the Instagram platform to increase visibility of content and grow reach. The ideal candidate is eager to stay up-to-date on the latest trends and has a talent for creating eye-catching visuals. The essential skills for this position include an understanding of social media and digital marketing strategies, with proficiency in Instagram. If you believe you have the necessary skills and knowledge to be my social media assistant, I would love to hear from you!

Hi. This is a one off query. I use Excel with Office 2000, the attached file is a copy of a daily download from ESignal, the daily data file layout is constant. Up until May 1st the data was presented in a comma separated format, every spreadsheet I use looking at this raw data is comma separated. What I did:- I wrote and saved a simple macro DOTStoCOMMAS converting all dots to commas in the raw data file, it only worked 100% once, running the macro on the next days raw data file gave results which do not relate to the original file. I installed Office 365 thinking it would resolve the issue to no avail. I would prefer to keep everything in Excel 2000 if possible. Editing a macro is beyond my level at the present. I would ask what causes the macro to produce unrelated data and is it viab...

I want to change my forms from paper to excel on my computer

I am looking to create a loan calculator that will be specific to a business loan. I would like to be able to input the interest rate and the calculator should then generate a loans terms and payment frequency. I prefer the output of the calculation to be in a graphical dashboard format, so I can get the correct visuals when working with this assessment.

I am looking for a skilled developer who can create a SQL database with a web interface in Visual Basic for my customer database. The purpose of this project is to assign tasks to different employees, so I need a database that can track employee task assignments and progress. Ideal Skills and Experience: - Proficient in SQL and Visual Basic - Experience with creating web interfaces - Ability to customize and add extensive features to the web interface - Strong attention to detail and ability to create a user-friendly interface The web interface must be advanced with extensive features and customization, allowing for easy task assignment and progress tracking. If you have the necessary skills and experience, please submit your proposal.

I cant disclose it i want an excel expert with vba knowledge for creating a frontpage of my data base

I have an excel sheet and i want to dynamically fetch data from some rows and display user forms accordingly

I'm looking to design a user-friendly Microsoft Access Database UI to help manage my employee data. I prefer the user interface to have a detailed and comprehensive design with multiple features, allowing a wide range of functionality and usability. Specifically my desired features include the ability to view employee information, as well as other functionalities such as editing employee information and generating reports.

Create an excel sheet that has the same macros in as the HSE Fatigue Risk Calculator Excel sheet. the old one is corrupt and we require a new version

Seeking a dependable, quick turn around excel / google sheets experienced spreadsheet builder. Someone who can take an outline and build a functional spreadsheet from scratch. Technical skill sets for the project we are looking to complete now: : 1. Experience building spreadsheets (excel, google sheets) and experience with product production traceability to inventory when given an outline specifically for product development and tracking.

Looking for an Excel specialist to automate my audit tracker. My team sends an audit email to the auditor everyday and the same needs to be maintained in our audit tracker Is it possible to extract the data in the audit tracker as soon as the mail is sent?

I am looking for an Excel Macro expert who can help me automate tasks. The main goal of this project is to automate various tasks that I have listed in detail. The tasks are of intermediate complexity level. Ideal skills and experience: - Advanced knowledge of Excel Macros - Strong understanding of VBA programming language - Experience in automating tasks in Excel - Ability to work with data analysis and formatting - Attention to detail and accuracy in coding - Good communication skills to understand my requirements and provide suggestions for improvement.