Connexion acces vba iseries as400 jobs

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.

I want to move my website from one VPS to the other VPS So we need to copy and paste everything :) But I have SSH acces of both.

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.

I need a VBA function to which I can pass two street addresses, and get back an object containing all the data from the Google Distance Matrix, the AIP that provides travel distance/time information, like directions on Google Maps. I need the function to be written exclusively in vba so I can troubleshoot / edit as necessary. Your code should assume the data is clean. I'll provide access to the api. I need at least a ballpark price for this asap. I'd like to spend as little as possible. Thank you!!!

Hey Paris, my name is James. I'm a developer working on a project here in the USA. I have the code laid out already, I just need some help ironing out some minor things. Please contact me when you're ready. Regards, James

Hi Paris - would like to discuss working on a project. We estimate the first iteration of the project will take a few days. Summary Build a VBA application to... - take user input (e.g. a date range) - parse a csv/xls file with raw data - filter this source data and (using an existing design) - itterate through data - and generate a formatted report. - with other requirements of logic to be discussed.

Need a VBA pro to write VBA that runs upon opening the master excel file. This VBscirpt loads load multiple, variable csv files into multiple sheets in an excel workbook, as described in the spec and as shown in the example master excel file.

ASAP In the web I have found several demo to develop a short vba code to get it done. I need a consultancy to have this piece of sw working properly on my pc I am strugling to find the proper vba code to use. I have 2 pcs. On thsi I disinstalled Internat explorer and I am not able to install anymore since it is not availbale from summer so i would need to use chrome with selenium etc,,, on another pc I still have Internet explorer and I could use it

I need someone to unlock a Excel-sheet and underlying python-code to extend it use beyond its limitation. It has validity period of 1 year, i just need to unlock that feature, nothing else. May have used vba compiler to make macros unviewable and may have locked to be working on certain company server. Some background what this Excel tool I have is: Plaxis Excel Exporter , Excel-sheet to collect results from Plaxis Output. Results of a Plaxis calculation can be imported in the Excel-sheet and are visualised and available for further processing. For instance presentation in charts. After data have been imported into the Excel sheet, they can be viewed any time later without the need for running Plaxis Output.

Hi, Looking for Excel VBA Macro Work

Hi, Looking for Excel VBA Macro Work

Hi, I have an old Macro Enabled Excel Template from 2014 World Cup that I would like fixed and updated for upcoming 2022 World Cup. The purpose of the Simulator is to project the outcome of the tournament using various known inputs. The macro currently does not work as the version is out ...I have an old Macro Enabled Excel Template from 2014 World Cup that I would like fixed and updated for upcoming 2022 World Cup. The purpose of the Simulator is to project the outcome of the tournament using various known inputs. The macro currently does not work as the version is out of date, but an experienced Excel user should be able to view the code and update accordingly. I am seeking a VBA expert who should find this task relatively straightforward given the existing template will be ...