Vba|cprogrammingvisualbasic työt

Hi Mamuka B., I noticed your profile and would like to offer you my project. I need help with excel VBA in template

I already have a Quotation Tool developed by me in Excel + VBA creating Quotations and sending PDF quotations to selected e-mail addresses. It is working based on Databases which are updated manually, as from the corporate rules I'm not allowed to Read/Write directly from/to the ERP system. The tool is then constatly updated within users' laptops and the Company Server thanks to .bat file for syncronization. The tool is properly working, and it have been working for more than 5 years. I need an implementation to add some features to the existing system (i.e. main one is that I need to be able to act on multiple customers at the same time). I'm looking for a VBA Excel developer to put hands on the existing system, develop the required features and identify f...

Need VBA developer for small projects, should be from Pune , Maharashtra only

I need a price list creating in excel from the attached PDF price list. There are quite a lot of different parameters so VBA will probably be required. I would like an "input" page where the options are selected that show the retail price. I would like a read/write password protected page where I can input/update the prices in the future.

I need a macro coded so that I can update 20 powerpoint text fields with data I input into excel and so that it saves a new version of the file and a separate new pdf version. Should be a quick file for someone that knows VBA.

I am new here BUT, If you require any of the following for your SPREADSHEET: databases, pivot tables, charts and graphs, dashboards, complicated formulas, interdependent drop-down menus, straightforward VBA & Macros, or any other professional custom spreadsheets, Then look no further...

If you require any of the following for your SPREADSHEET: databases, pivot tables, charts and graphs, dashboards, complicated formulas, interdependent drop-down menus, straightforward VBA & Macros, or any other professional custom spreadsheets, Then look no further...

Buenas noches soy Ing. en Sistemas, con 4 años de experiencia en : creador de web, diseñador web, programador web, Diseño grafico, marketing digital, creacion de logos, branding, flayers, poster, Manejo de excel avanzado , programacion vba , experto en Canva. Experto en Herramaienta Wordpress, Elementor., posicionamiento SEO. manejo de cuentas. Me gustaria poder ayudarlo en su requerimiento si desea contactarse conmigo al privado.

Add if loop in VBA on an existing file

VB.net / Selenium / Database / Excel VBA / Access / Web Scraping Expert Required to build excel vba selenium scraper 2 websites and 1 form filler connected to access database

Hi, I need a power point macro programmed so it automatically updates a powerpoint presentation from an excel sheet. Should be a quick task and will provide full instructions. Please confirm you are strong in powerpoint vba. Many thanks, Benedict

I have a program based in Excel that mail merges a Word document with a list from Excel and mails it from Outlook I am recently getting an error message suggesting the macros have been blocked. I have attached - the Excel program - a modified excel list - a copy of the Word document - the error messages (2) - and the VBA error message - the location of the excel file on my server: MDSERVERPublicGroupEmail and Letter Generation Modules I have adjusted the "trust center" in Excel and the properties of the specific program. Please look and advise. I need it back by today, if possible

Excel developer to create technical forms that will be used to undertake a variety of calibrations comparing sensors to each other and presenting the data for import into reports

1. Rename a worksheet NAME1 to NAME2 2. in Worksheet NAME2 (former NAME1): - add a button LISTA PRODUSE NAME2 below LISTA PRODUSE NAME1 - rename FORMULAR COMANDA NAME1 to FORMULAR COMANDA - remove 2 sections from worksheet 2 2. Rename worksheet Lista Produse to Lista Produse NAME1 3. At lista produse NAME2 worksheet add the 3 buttons from top row (like in Lista produse NAME1 and add the formulas for discount column (like in Lista produse NAME1) 4. Change the functionality of formular comanda to read products from both Lista produse Tece and Lista produse GROSSMAN 5. Change everywhere the logo NAME1 with NAME2 6. At Worksheet3, we have a section Discount partener. Below add a new section Discount partener NAME2 with 4 items: At this point , the discounts should be corelated to price list...

finding people to write excel vba to check the data, it should be fast and simple and all code with comment use all the conditions to check with the data, and calculate the maximum gain, maximum give back, average mark and total mark with graph output all the selected conditions and results to TEST REPORT with TEST ID NO. change to short form or return to normal of the results my budget is USD60

Hi Mamuka B., I noticed your profile and would like to offer you my project. We can discuss any details over chat.

I need someone who is a VBA guru for a small task.

I am looking to replace some of the columns of the current program/ .exe file which utilizes VB.NET. I have the new VBA code to replace the indicated columns, but I don't know how to replace the new/replacement column calculations without messing up the current program. I assume that a programmer who is proficient in VBA and VB.NET should be able to put these together (or slightly revise the VBA code) without interfering with the functionality and accuracy of the current .exe file. Please see the overview of the current program in the attached "Current " file. I am also including files and source code of the current program. Source Code for the current program, can be found in the attached zip. Code for the program can be found within that zip file...

Hello, I have several excel sheets in the same excel doc, each sheet has it's own vba macro and they all has the same code, anyway i need them to automatically run every certain time, i have done my search for that topic but none of the simple code i found is working. Could you please help me with that. Thank you, ----------------------------------------- vba code sample. ----------------------------------------- Private Sub Worksheet_SelectionChange(ByVal CountrySize As Range) If <> "$O$5" Then Exit Sub = False Dim ws As Worksheet: Set ws = (7) Dim r, r2 As Range . . . . . . . Call otherMacro End Sub Private Sub otherMacro() = False Dim ws As Worksheet: Set ws = (7) Dim r

I run a tax compliance business that works with individuals with connections to both the US and Canada. These individuals have to file taxes both in Canada and the US. Over 8 years I've developed a spreadsheet to do foreign exchange conversion and tax calculations for stock investment activity. There are certain problems, however, that I've been unable to solve on my own. I am l... Two key problems are: 1) Avoiding circularity with the use of new formulas like filter, scan, etc. 2) Creating a first in, first out approach to security dispositions for the purpose of capital gain calculations. I'm an advanced Excel user, so you should only consider this assignment if you think you are very advanced and can bring advanced solutions (either in formula, data analysis or ...

Hi. Do you have time for a small PowerPoint VBA-project? I need an addin which installs some menu-buttons which do some simple color-changes in PP. I have the code for the color-change to build on. I am busy today, but want to know if u have time next week.

I have a workbook with 3 sheets Electric, Bank, Master and I want to update entries from Bank and electric Automatically to Master sheet as per condition. I have attached here sample data sheet and instruction text file. Any one who is expert in VBA can do this simple task within 4-5 hours.

Create a script that loops through all the stocks for one year and outputs the following information: The ticker symbol - Completed Yearly change from the opening price at the beginning of a given year to the closing price at the end of that year. The percentage change from the opening price at the beginning of a given year to the closing price at the end of that year. The total stock volume of the stock. - Completed Add functionality to your script to return the stock with the "Greatest % increase", "Greatest % decrease", and "Greatest total volume".

VBA Projects needs to be completed on an urgent basis. Majority is completed need to transfer over the automation to an updated file. Need to speak to an expert in VBA, projects needs to be completed on an urgent basis.

Add and change some vba commands in a prepared file 1. When I click the edit button. I want the editor to open for me in a new window 2. Adding an edit button only to the Department command. which will open in a new window and it will be possible to change from Department x to Department y . and update the data in the database 3 . When I mark one of the Employee Ids in the table there will be a button to add/delete a picture When I add a picture to the Employee Id, the picture will appear in the DATABASE and will also be displayed in the picture template

Hi, I have an excel VBA that works on windows and i want it to be revised to work on MAC, very simple and should take couple of minutes for a person who knows their way around VBA for MAC. I've attached the excel file along with the issues i'm getting on mac.

I have a mail file in VbA want to fix the bug

Need to find hourly, daily and monthly averages of data.

I have a design which needs to be converted into a VBA script.

Need to find hourly, daily and monthly averages of data.

we have delimited txt file +- 400 rows by 12 columns (of invoice data) that we need VBA to -fetch and drop into temp tab -parse the rows into format tab ensuring alignments formats etc attached is png of before and after we do this allot and are looking to outsource these. you should budget 6-8 hours to do this well (4 hours will get it done but not tidy) you need to be used to parsing txt files with vba

3 freelancer for Multiple VBA projects: I am looking for VBA expert who can work on any kind of projects and can work as long term. So preferably full time freelancer.

Need an inventory management system where in I need a spreadsheet created using Excel that allows for barcodes and is connected to a scanner. The fields shall be product id, particulars, price, qty, barcode. I need to deduct 1 from qty field each time I scan a particular product. So just the inventory out part here to be captured. Another requirement is for a billing system using excel vba, where in the scanner reads the barcode on the product label and auto enters the product details into the invoice. Then discounts, taxes, and shipping are applied to return the total amount due. Also need the ability to capture mode of payment-- cash, debit, credit, gift card, scrap trade-in. Also, since people may pay using multiple methods (partly in cash and remaining using credit), I need ...

We need help with the following: Excel file will have a field (key) input Your VBA code to create connection to MYSQL Query to be run in MySQL based on Key Output from MySQl query to be sent to Excel This project should be easy for someone who knows it. If you do not have experience, you will struggle. Our DB is on Amazon.

Hi, I have a keywords categorisation task which should be simple and straight forward for someone who knows their way around excel. Basically what i need is, based on the rules in the "Keywords Intent" Sheet i want the column category on "Keywords list" to be filled. I've added the guidance needed within the excel file attached and I'm happy to answer any questions that might arise. Many thanks, Lin

This is the first step of a 3 to 4 step project. Utilizing VBA, create script and single button that with retrieve indicated data from csv file and create a csv file of the results. This project will utilize 2 files. 1) attached "Fractal Study " 2) attached "Fractal Study " file which will be a csv file when produced by the VBA script. Included for the purpose of explanation are two additional files: 1) "Fractal Study " 2) "Fractal Study " 3) "Fractal Study " Please begin by opening the "Fractal Study " file.

I have an excel application with multiple pages that I have personally developed, it has parts of code in VBA. I want to create a web app that has the same functions that I have with excel but adding some enhancements. With various users and levels. Connection to other data sources and export to a CRM; ERP. As there is one possibility to convert my app in a module to be added to a CRM like Dolibar or OODO or any other CRM highly recommended by you. I have uploaded a PDF. It is a real example of my quotations I use for sale me soler energy systems. I've aso added my Excel file. The way I proceed usually is that I import data from the customer. Also when I have it I import electric consumption by months. I have my own price list, with my products, which I add to them. details as ...

I want a minor change in the program that does exclude all lines with qty 0 or empty. See word documentation the field that is in green. That's the only change.

I'm looking for a expert who have a experience of VBA in Excel. - Excel VBA experience - basic understanding of POST and json . - Mouse wheel support for listbox , textbox etc. - Custom Ribbon supporting an unicode 1) Attached contains a description for a project . 2) Please check an attached. 3) Office version : over 2016. 4) only one milestone will be allowed. Best Regards.

Require few modification/ debug in VBA program for successful run

I want ascript to save the tiktok weekly ranking of my country. The username, number of points made on the week and the ranking within the top. (Tiktok Battles Weekly Top) I don't really mind if its in VBA for excel or in Python.

I have a lookup table that returns text; either, Red, Blue, Black, Green, Purple, Maroon, or Grey depending on the lookup criteria. They show up in black font color in the destination cell. I need a macro that will run automatically and change the font color to be the same as the text reads. For example, if the lookup table reports Red, into cell C6, then change th...change the font color to red. If the table reports purple, then change the font color to purple, etc. Further I want several other cells (say D23, H12, and K23) to be shaded the same color as the changed text color. So, if the lookup table reports green to cell C6, the macro would change the word green to a green color, and shade cell D23, H12, K23 to the same green color. I need the macro and the VBA code to execute...

Hi, I have a script (from the internet and copied below) to delete duplicates in a selected Outlook folder. I need to modify the below VBA script for Outlook to: 1) Scan each sub-folder (as well as the selected folder). 2) Instead of delete an item (at the remove step), permanently delete it. (Note: The Deleted Items folder may already contain some items so it's not as simple as just emptying the Deleted Items folder). 3) Export the full name of each Folder being processed (e.g. ImportedInboxInfo) from step 1 and output (from the processing/delete step) to a file C: (replace yyyy-mm-dd-hh-mm with current date/time). Work must be well tested!!! Goal is to complete within 2 days. Sub RemoveDuplicateItems() Dim objFolder

I need an Excel VBA Developer to assist me with implementing a whitepaper model with formulas into VBA. It's a financial model related to a specific financial industry and would help me land my dream job. I am knowledgeable in excel and will be able to make edits once the main subs have been created.

Project is to provide Excel macro/VBA scripts that will do each of the following tasks: Script Part #1: 1. Select range B20 through L20 (this will be the starting range). 2. Copy the data in that range of cells 3. Paste that data (using "Paste-Special: Values") in the row exactly seven rows above the range (Columns B though L) that the script just copied. (i.e., Paste in Columns B though L in that row) 4. Then add 1 to the row of this range in the script that will be selected the next time (i.e., next time the script is run, it will select B21:L21) Script Part #2: 1. Select range T13 through CZ13 (this will be the starting range). 2. Copy the data in that range of cells 3. Paste that data (using "Paste-Special: Formulas") in a range of cells that a...

Need a small task to be done in Excel.

create multiplier to existing Word VBA+ template to auto scale reduce text to fit on one line

Hello, I'm using a Vba script in order to scap data, but it doesnt' working more. I need to fix This is the script Sub pro1() Dim m As Integer 'If (Now()) = 8 And (Now()) = 9 And (Now()) = 2022 Then Dim element As IHTMLElement Dim elements As IHTMLElementCollection Dim IE As Object Dim html As HTMLDocument Set IE = CreateObject("") 'If you want to see the internet explorer window you should type down as True otherwise False = True For m = 2 To ("A" & ).End(xlUp).Row If ("B" & m) = "" Then GoTo lab2: Url = "" & ("B" & m) & "&__mk_it_IT=%C3%85M%C3%85%C5%BD%C3%95%C3%91&crid=2J09C1LHL9BH2&sprefix=" & ("B" & m) & "%2Caps%2C184&ref=nb...

Hi we have a single file VBA xlsm file that processes data into tabs and then outputs to a pdf service. we need the code documented into a type of developer map. as well as understanding VBA as you will need to understand what the code is doing, you will need some good business/documentation skills/disciplines. Part 1 is approx 20-30 hours work.