I have an access based contacts database that comprises UI as well. I need a VBA / MS Access expert to analyze/optimize the VBA codes in the DB. Also, there is a functionality that has to be updated, which can trigger the change in DB structure and source code accordingly. This functionality shows if a postcard was sent to the selected manager’s contacts
...6-a2be20ce2fd9/convert-contents-of-a-formatted-excel-cell-to-html-format?forum=isvvba It works perfectly, but is very slow as it steps through each cell one at a time. e.g. to covert a single 1000 character cell, it takes about 10 seconds on my fast computer. I found a fix I think, but I need a VBA expert to do it for me (or find a fix that will):
A small job. Need someone to make a excel-macro (or any other way it can be done) to do a series of calculations on a sheet of excel workbook. It's a small job. Details will be discussed.
Hi, if you know Excel, Word and VBA, this one is easy! Here is the program flow: 1) User enters First Name, Last Name, Address, City, Province, Postalcode into Excel (columns) 2) Clicks a button "Create Letters" and for each row that has a column "Already Printed?" marked "No" it takes a Word Template and merges the fields in for the letter (add...
We are aiming to to run a campaign targeting brands to come onto our mobile app. We are a mobile fashion app - www.wonderfits.com. Need help with scrapping website info with email addressed and contact details of target brands. Example website - [login to view URL] (Focus on fashion/clothing/beauty brands)
You have to scrap Name and email addresses from different sites. I will give you the list of sites. You need to get the email address in different csv files for each of the website. I will pay you $1 for each 20 email addresses. (There are sites where all the email addresses are in a single page and can be copied immediately. Whereas there are other sites where you need to copy emach email address...
Want to scrap the gaming site - ONLY Macro expert bid -Want to scrap from VBA only . Please bid. Details will be shared with winning bidder.
Hi, I am creating an excel userform based tool and would like to hire someone who is proficient in excel, userforms and VBA. This project is expected to last for around 2 months full time(significantly less for a person who has great VBA skills).l I know exactly what is required to be built and have a Proof-of-concept with the code already ready and
Hello, thank you for reading this project proposal. I would like you to find email adresses related to a list of 89 business contacts. You need to : 1. Find the company's url thanks to Google (company name is in column A) and complete the column E /// 2. Write the verified emails in column F. To find the emails, please ONLY use this tool : [login to view URL] . Also, to guess the email, ple...
This is a weekly project that will require a daily Name, Email, and Phone Number scrapping from a website for up to 200 (# varies daily) contacts. List of contacts will be provided daily at specific time and the project is to be completed within 4 hours after we notify you of new list of contacts (but it only takes less than an hour to copy contacts)
Phase 1: Data Staging from Stock Exchange file or API with applied calculations using Combinatorics. Output in webapp or excel
...services. 1. Web scrap an online mall products into a data file (eg. excel) with: Product Title/Name Brand Selling Price Discount Price Main image (URL) Additional images (URLs) Product Description Product Categories Ratings (stars) We need all product categories to be setup. We only need around 200k++ products. 2. Import the web scrap data into opencart
Search for sports ... in range 200-250 site with high activity.. and blogs, forums, news, only unofficial sites.. general and specific sports only english sites.. all big soccer teams all EPL...like: Manchester city , chelsea , arsenal , liverpool , crystal palace..Leicester , Manchester United italy: inter milan , juventus ,roma ,
I need very simple code....unmatched it needs to Append those unique "Quote Numbers" into the tblProposalStatus. (There should not be Duplicate "Quote Numbers" in the tblProposalStatus Table.) I need VBA Code. So I can take what you submit and paste it into an event action (button: on Click) Private Sub CmdRunButton1_Click() Your Code Here End Sub
I have almost 5 million companies list. I w...almost 5 million companies list. I want to get more information from the Web Directories. I will share a google sheet with all the requirements. You must be an expert scrapper and able to scrape information from Web Directories. Please ignore if you are not expert scrapping from Web Directories. Thank you.
set a timer in an excel worksheet, once condition met in the worksheet1, copy and paste certain data to MS outlook and send it out everyday , back to workbook, create a worksheet2 and name it (mmddyy the date we create) save the data(we send to outlook) in the same workbook in the attached excel, if G3 >10%, copy A3:E3 to outlook again if G4>10%
Extract data from a website with pagination. Need to get the data to Excel file. Not a complex data extract, but since it has pagination I am not able to get it using available tools. Developer with Excel VBA knowledge & web extracts should be able to do it easily.
There's a website which posts daily materials pricing, available for everyone, I would like to save these data at my database. So that I can apply analysis across time intervals.
Make me a Macro / VBA / Program To be able to Nest objects in corel draw into a given size area, and be able to dictate what gap to have between the objects, and also dictate the gap between the given area and the objects So in short I want to be able to for example: create an oblong box in corel draw, I have objects on the page that I want to nest
We want to scrap 3 different contacts websites and add them and update in a firebase database , the script ...and it must have an admin backoffice to control sheduled tasks, scripts to run and manage database with filters each domain can have 10k pages max in total, it's an easy scrapping job be aware : websites to scrap are related to @dult content
...where it can be uploaded into our systems either in EDI or excel format. However, not all terminals in the world today are able to produce the TDRs in the TPFREP format, hence a number of locations worldwide are still sending their TDRs in their own formats. The task is to be able to write a VBA code to convert the TDRs from those terminals not able to
...trusted workbook. 2. Add 4 offerings to a drop-down class menu. (I'll provide the additional information in more detail once hired) 3. Between columns 'AG' Add macro buttons or VBA for an interactive dynamic list of classes that prompt the existing dynamic calendars in the same way the drop-down class menu already does. Can have list print on second page
Hi, I need to be able to fill a web form automatically with excel data, excel file contains basic info like names,address,email. I think it should be pretty simple for some of you.. let me know if you can do this and how long it takes,
I have data register, which I need to make better. It generates invoices with words in my native language and there is another macro which saves invoice in pdf and excel new sheet. I need to make better logic for selecting invoice number, because it is not working ok .. (I will tell how). And there is a problem somethere, when I run macro which saves
...measured individually. We use an Excel VBA script to generate a table from some input tables, which eventually is used for controlling a measurement robot. This vba script used to work fine with an old version of excel (5 years ago or so) but does hang or executes very slowly with new excel (2016, version 1807). The vba runs two nested for loops o...
...Make sure to include the filters applied when scrapping a company's profile: There are 9 filters that you can see on the left hand side of the page: Buyers/Sellers, Products, Species, Continent, Country, Activity, Certification, Number of employees, trust rating. See also uploaded file. Delivery: An Excel, where every row represents a company and every
I need to get a Excel macro developed that can match two Excel files and find matching lines based on amount. The macro should then take all rows that it finds matching and list them under each other. and the ones it did not match it should line up in another column.