Hi, I need to rewrite Word VBA script into Google Docs script. The script must perform these 3 actions 1 / The word document is segmented into bookmarks (ie: Chapter1, Chapter2 .., Chapter11). On the first page of the Word document there are 11 checkbox allowing to select or not the display of these chapters. 2 / On the first page there is also a table
...information about properties in Mohave County, AZ. Entering the Parcel number in the website and manually typing everything into excel would be tedious. So I need someone to write a vba code that will do that for me. The attached excel sheet has the website and the columns represent the information that I need. I need it to loop through all the parcel numbers
Proofreading and editing write-ups Create macros using VBA scripting with various files
Proofreading and editing write-ups Create macros using VBA scripting with various files
1.) Export a table from Excel to acces Note: One table contains Project data of one month 2.) The table contains 29 Columns 3.) The unique identifier (UID) consists of 8 columns . 4.) If Project data of the corresponding month exists -> replace the existing record set. Note: Data exists if "Jahr" &"Monat"&"PSP" match Ideas exist to enhance t...
NOTE: The code needs to be written INSIDE ACCESS (In VBA). I have stored client information in an MS Access database, and would now like to populate a PDF FORM from MS Access and send it to my clients and ask them to update their contact information. When they send me the updated file, I want to be able to update the data in my database as well. So
HI. I need simple VBA script for Excel. I need excel file with two columns - Barcode and Quantity Functionality: #1 Create Income button. On click it will show textarea popup - there I will enter list of barcodes. On Click OK - Script will search each barcode in "Barcode" column - if it exists it will increment Quantity column, if not exists -
Hi, I am looking for the following functions to be added to my VBA spreadsheet: 1. Amend my stopwatch counter code so that it starts and runs without having to have the sheet selected (currently, if I am not on the sheet, it doesn't run, and if I am on the sheet and it starts, it creates an error when I leave to click onto another sheet); 2. Amend
...Brief (short): Looking for excel VBA expert to help us automate repetitive tasks we do in excel for keyword research. Final deliverable must work on both Windows Office & Mac Excel 2016. We use OneDrive, so if any external data sources are required, must be OneDrive (not Google Drive) compatible. Requirements • Excel VBA & Macro expert • Combine multiple
Looking for a VBA / Google Maps API coder to recreate excel app have used similar excel app so know the process can be done. I will require access to the code once complete and will add my own google maps API key (if necessary) see attached file for example
Specification for the Macro 1. Description of the Project Excel integrates a programming language, VBA, which allows to realize powerful and user-friendly applications, example a Macro, is an achievement of this product. Since it’s possible to use the macro for a sequence of tasks within a software program, it’ll be used for daily reports of inspections
...with a small portion of a small Excel VBA project. The objective is to establish an API link between VBA and NCH’s “Verbose” text-to-speech application. NCH provides a “Unified Application Program Interface” including all necessary, supporting files in their archive. My intention is to pass two variables from VBA to Verbose, one, a text stri...
...idea is that i dump a load of data from my excel version into the first tab on the spreadsheet, and then a dump of data from the new system into the second tab. I then need VBA to look up the information and highlight the cell if it does not match the same cell on the opposite spreadsheet. The job number is the constant number on both sheets, so need
1. Around 500 unique tasks are allocated. 2. Will be assigned to 12 employees. 3. Will be updating hours worked on assigned tasks once a week. 4. Need to have tracking of hours spent on preparation and reviewing for each tasks. 5. Should be able to track hours spent weekly, monthly and yearly on a particluar task by employee.
HI, I have written code in Excel VBA it needs to be converted to Andriod Interface, Its really just 4 inputs and the result comes out. I need the source code so that i can modify it my self later on. the password for the RAR file is freelanceNOW18. If you have done this below and can do it, please type "done it can do it for you" if you dont, I won't
Convert an Excel Macros VBA with fields, buttons, conditional cells, email reports and math formulas to an Android App to be used in a Tablet Android and easy data review from any device. Could you please see the attached files? One of them is my Downtime, Leaks, and Scrap form used to collect on real time data on different Production Cells (402 on
Problem/Challenge: I have all the questions in MS Word format. Currently there are 2 options available to upload these questions from MS Word to MYSQL – 1) Upload one question at a time via an html form. Have to manually copy paste the question, all the answers and any images in the question. Takes 1-2 minutes per question 2) Upload via a CSV file by populating all the fields but we have ...
One of our old clients wants us to add some conditional features and also correct some calculation errors as well as copy current code and create new email function. It also includes 1. Show/Hide fields based on predefined selections. 2. Add a few more fields in the list so they get updated on our clients online msql. Note: a connetion is already setup and it updates data but you need to add a ...
I have some VBA code that works in Windows but in Mac generates Runtime error 429 ActiveX Component can't create Object. Need somebody to convert code so that is works on a Mac
...in MS Access and send to website to get data Step 2 - Plot that data on Google Earth. Data to be taken from the below location. The variables are "lng", "lat" & "radius" [login to view URL] I have code that can take data from MS Access data
I have a project that requires inputting repetitive data into an online web form (Medical Billing Form). I need a VBA macro written that will pull data from an excel worksheet and populate it into the web form. There are some special characteristics of the web form in that certain fields require multiple lines of data which require a button push on
i have some work in excel. This is about smaller Excel works, i.a. First calculate approximate values for a range from all columns in the worksheet for approx. 100 individual Excel worksheets and then transfer them to a mastersheet. Furthermore, via VLOOKUP or similar. Data is read from a sheet and read into another mastersheet. If successful, a follow-up project exists in the next 2 weeks. Data i...
...Categorize Library and upload products (from excel csv upload. This may include 20k to 30k products. It may require you to clean and edit data so you should have excellent Excel and VBA skills) • Find and edit images we may require • Install any appropriate addons/plugins • Help find acceptable payment system • Carry out and prepare a user acceptance test Requirement...
...looking for someone to work for me part time (after office hours and/or weekends) on data analytics using tools such as Excel/Access/Tableau. Person should be good in writing complex formulas , advance in pivots, charting etc. VBA a plus Will pay good compensation depending upon your skill levels. [Removed by Freelancer.com Admin for offsiting - please
The project is basically sorting and coloring cells in an excel sheet based on a specification file. I have Excel sheets that have many fields and I need to sort, add color and analyze. I have to do this many times per day and it is time consuming. I need a way to (1) sort on any number of fields and (2) color cells based on conditions. The project as (3) files attached. 1. Example "befo...
Find & Replace Words in EXCEL VBA Task: • Create VBA script to remove any additional spaces from a cell in a column (for example remove extra space from the following text “apple “ or “ apple”. However do not remove spaces in between of words for example “I like apples” – These spaces should not be removed. • Create a VBA<...
Hi, I would like an Excel VBA programme which is linked to my BitCoin trading account. The code would regularly connect to the exchange API ([login to view URL]) to: - Get the current market value for Bitcoin (bid and offer) - Check how much bitcoin and USD I have in my account - Either send a buy or sell order based on some formula (for
Actualmente tenemos tres aplicaciones de escritorio desarrolladas en Delphi 2007 que hace envío de correos, pero ahora que vamos a cambiar de servidor de correo necesitamos modificar la clase de envío de correos para que use SSL ya que para envío de correo a través de office 365 es necesario, además de modificar la clase si es necesario habría que
PLEASE READ THE WHOLE TEXT BEFORE YOU ANSWER. THE PROJECT IS NOT TO CREATE A FULL TOOL. I need an Excel / VBA expert to help me create a quotation tool for our sales staff. The tool should hide and show different check box fields based based on which parts of the home our customers wish to renovate. To give you an example: If our customer want
Hi, We have a scraping macro in Excel VBA which takes data from nowgoal.com. Basically each row in Excel has a [login to view URL] ID and for each ID when scraping is done, then script moves to the next row and proceeds with a new ID. The disadvantage of this method is a) right now during scraping it's impossible to browse other tabs of Excel document b)