Excel vba code data web page jobs
i want to prepare a excel sheet with vba coding to import data from zerodha api and for excel sheet and make it algo trading you can find a sample file in the attachment
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...
I have a twilio project that was working fine. Just one part of it is not working. Let me know if you can help. Only VBA expert please. Thanks.
I am a freelancer that need a .Net developer to migrate a program written in Excel VBA to a .Net C# with Access DB
I need a VBA or other type of programming to add multiple accounts into MS Outlook (2007 and above). The account details can be entered in an Excel sheet. VBA should manage account creation for me. Thanks.
Need a freelancer who is experienced in excel and VBA scripts Dealing with betting websites and understand sports and odds is preferred.
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 working
I need my excel spreadsheet finished with formula ,it cant be done with VBA or Macro because only formula is alowed .
Phase 1: Data Staging from Stock Exchange file or API with applied calculations using Combinatorics. Output in webapp or excel
I need very simple code. But need it NOW. I have two tables "Quote Master Table" and "tblProposalStatus". Both have a field in it named "Quote Number". And there is a Field in the "Quote Master Table" named "Bid Status". Those are the exact names. (Note: I cannot change the names of the tables or fields, so please don't ask me to...
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.
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
...to an existing application/data lake that exchanges information with suppliers and verifying supplier owned data (leadtime, MOQ, location info, etc..) The project will require the following: - Setup a back-end server system to send information to suppliers asking to verify certain points of data from our existing data lake, then accepting feedback
Need a freelancer who can build my VBA application using Office Access 2016.
...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 support
...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 next to 'scheduled location & times...' written information. 4. Correct printing error, right now in 'print preview' it only show the 1st page and not the...
Hello, I need an expert who have bets scraping knowledge and who can scrap million data within a short time. If you know how python, VBA, it is good. Thank you
I need to fill the form automatically with excel data.
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...
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.
Write VBA program in excel that will automate the process for going through a library of MS Word documents and extracting specific paragraphs and tables from the Word Document and inserting the results into a excel spreadsheet.
I need you to designe/vba code a excel document that give a good overview of stock holding of personal equipment. The sugestion of a setup and how i want it to be can be seen in the excel document that are attaced. 1. overview over all registrated crew. 2. Profil can be added for each person and materila/equimpent etc. 3. It should be easy to work
Hello, I would like to receive quotes for someone to develop a spreadsheet in vba which would update prices. From some sites through their Api Olá gostaria de receber orçamentos para que alguém desenvolva uma planilha em vba a qual fizesse atualização de preç[login to view URL] alguns sites através de suas Api
...produces an excel sheet called the statement of accounts (screenshot attached). It is then printed out and handed to an employee in the legal department which has to manually key in the details from the statement of accounts to create the letter of demand which is sent to tenants. This process is time consuming and can be automated through VBA. Unfortunately
Need expert on vba and macros on backend coding
I need VBA code for an excel formula that I want to be able to save within Excel formulas i have =EXTRAE(A2;1;6) and another =TEXTO(G2;"000000")&TEXTO(F2;"0000")
...phone numbers. It has to go and look at 3 other tabs to see if the exact match exhists. One of the tabs has multiple columns where it needs to check. What im looking for is VBA to: 1)Create a new tab and name it something of my choice. 2)Copys columns from all tabs identified and places them into essentially 4 columns with appropriate headers 3)A new
Column D is a Date and Time stamp that a ticket was entered. If the Date and ti...a Date and Time stamp that a ticket was entered. If the Date and time are between 17:01 and 07:59 or on a weekend we want to copy all of the data in that row to another sheet. I prefer this be done with a VBA Script but if it can be done using formulas I am ok with that.
Thanks for your interest. Would like to talk to you to discuss my needs. Please reach out to me ar /> [REMOVED BY FREELANCER.COM ADMIN - PLEASE SEE SECTION 13 OF OUR TERMS AND CONDITIONS]
...[login to view URL] is used in Microsoft Access 365. It monitors the folder C:123 for new files every 60 seconds. When a new file is created there it displays a message box. I need code to that instead of displaying a message box will: - Load XML from an xml file created in that folder (ignore if file is not .xml) - Create a record in the table "ListOrdersResponse"
I develop business logic in Excel and need a formula to scan several hundred transactions to find circular payments. In the example, A pays B, B pays C, C pays D, D pays E, E pays F, F pays A the elimination formula needs to remove from each payment the smallest circular amount. (A pays 180 to B; B pays 30 to C; C pays 50 to D; D pays 10 to A:
We need someone to help writing the code for an TDS3034, controlled by VBA 2015 USB, we are using the community version. We need to get the waveform and get some information from it in order to determine pass/fail criteria. You should be able to read voltage/current configure the scope depending on the expected parameters.
Hope someone can help. I'm writing an excel file in which, by entering certain data & values into pre defined fields, will ultimately create a list of products. We operate an e-commerce web site and often need to import products on mass. Our web site accepts csv's for importing the data. The data however has to be very specific &...
...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 which
insert excel row data into PowerPoint slide vba in a certain textual format
...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
Hi Vba A., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
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" matc...
