I have a finished vba-code to web scrape soccer results from a website. The structure for the scraping is set, and the code has worked for months, but the problem is that the website has updated its security. So I need to get past the error "permission denied", and make the code more robust, since it also fails by losing it structure when I get past
I have a vba-code to web scrape soccer results from a website. The structure for the scraping is set, and the code has worked for months, but the problem is that the website has updated its security. So I need to get past the error "permission denied", and make the code more robust, since it also fails by losing it structure when I get past 200+ links
I have library records in 35 excel files (each file has 500 records) that I want to copy specific rows only to a new workbook. However, the field headings are on the side in Column A not on top. So I want to copy entire rows where the values in column A are equal some fields only. See the attachment how records are stacked in first column.
...produce several graphs in a sheet. . I need a code written to make the graphs automatically update to show the most recent data to the date shown in cells I1 for MBN and W1 for GRV. (the filter buttons on the chart must be hidden so this needs to be worked into the code) I also need my email Report code update so it ask the user whether it wants to
OVERVIEW: I would like to be able to complete the following project by the 8th July 2018. I will download a report daily as an xml file that will be saved with the same name. There will be two reports in total (both in the same format with the same headers), one for each location. All the below will need to be completed so that we can analyse the data for each location and the combined data for ...
Hello everyone! ...freelancer to help me that get all datas(price, product image url, etc) from some AWS shopping sites. You need to have a good skills of creating Python scrapping scripts or VBA. I need excel doc that saved all data from supported sites. Please note "AWS Scrapping" on your head of bid. So I'll consider your correct bid. Best regards!
...show the last 12 months of data based on the date input. There needs to be a way to enter the date so that the graphs know were to work back from? Maybe a pop up textbox in vba asking for the date? or a box in excel where the date is entered? Feel free to change the graphs and tables as need be to any format or setup to make this possible. The easier
I want to have a VBA Macro that creates a HTML page with interactive Charts. In the attachments you can find a Scource and a Result example.
Have written a code for a user form to automatically add information (delivery details) into a database, however code only currently works if all the boxes in the userform are filled, need this corrected so that form will work regardless of whether all the boxes on the form are filled or not.
Need a Bidder for a long term who can bring leads in excel work, vba, ecommerce, webscrabing, graphic design.. every bidder will be in commission based for a long term with monthly commission for every project they take
I want VBA code to scap data from an application HTML This is basic stuff: * Open web application * Enter userID * Select Menu * Select Sub Menu * Select Sub Sub menu * Type a inventory reference * Scrap results This may require one hour sitting together while you develop and test Because you will not have access to the application, I will be opening
We want to have a database developed on MS Access to record data on power purchase transactions . The develope...on MS Access to record data on power purchase transactions . The developer needs to design tables,queries and forms to enable the user easy access of customizable reports. VBA programming will be needed. Audit trail feature shall be there.
...handle this project, then give a realistic bid. In the answer text please answer the following 3 Questions: 1. Which language you will use to create the software (C++, C#, Java, VBA, ect.) and why you think this is the best choice in for this case. 2. Describe in 2-3 sentences the main objective of this project just to proof that you have read the entire
Excel macros play an important role to perform repetitive operations in excel. It takes lot of time, when handled manually. I have done quite good amount of work in excel macro handling. It includes, extracting information from text files, transferring info in to excel, E-commerce templates, Image handling, Shapes variation, Pivot Tables, Text to columns, Flash Fill and others Data tools
I have an excel doc with two worksheets. The second worksheet is a dictionary. I want to be able to type a word from the B column in Column A of the First Worksheet and have B and C columns automatically populate.
I have a bunch of searchable pdf-files (so you can select/copy words from it). I would like to convert each pdf-file in a (raw) xml-file with a VBA-function (or shell-function using for example a java command). I use MS Access 10 and code in VBA. Give you € 200. Pls read instruction before you response. Thanks for reading.
Hello there. I need help with VBA code in Outlook 2016 so that: When email from "no_reply@[login to view URL]" is received in mailbox, sub "OpenFile" is called. and msg is saved in "k:/files/" as "[login to view URL]". Date should be "year-month-day" and time" hour-min" thank you..
This assigment contains technical analysis on Excel via VBA and GUI. Along with the exercise that you can see attached, I will send you data corresponding to it. The workload for this assignment is approximately 3 hours. It is essential to be proficient in Excel and VBA, and building GUIs.
...Acquisition) from Utopia Global Inc. I wanted someone to who is an expert in MSexcel, macros/ VBA who is ready to come to the office(Koramangala, Bangalore, India) occasionally and work with the project managers. Snapshot of the requirement: • Coding development in VBA (Excel) ((Procedures, Functions & Classes) and advanced Excel functions. • Should have
hi there, I'm looking for VBA expert to design a spreadsheet where it can find all combination of a targeted sum. The VBA code should be able to calculate over 8 millions combinations and repetition not allowed, plus showing the quartile for each possible combinations. Other computer language is also computed. Example: Targeted Sum is 52 weeks combinations:
Working for a start up - need someone who can help automate the task of pulling data out of our microsoft access database and into an excel doc. We actually have this process working but to reduce the pain of copying and pasting data in and our of the database we want someone to make it happen automatically.
Hi, I would need an Excel VBA macro. It needs to be quick (running for less than 1 min), and the spreadsheet can have many rows (100k+) As you can see the attached excel file has header in row 2 and some extra headers in random rows, First thing the macro should is getting rid of any extra header rows, i.e delete them (delete in a way that no blank
Hi, Im looking for a an MS Access vba code to read an xml file and show th enumber of records, (ususally only about 5 reocrds in the file) and display the CDATA element and store the records in a MS Access table, may include some comments.
...corrections for latest Win10 Office 2016 or 360 versions. Code base includes plugin, registry settings, Office version detection, installer creation, small tool-bar menu button and wizard sequence. This is not new a new project development, it is for adjustment and porting an existing plugin. VSTO and VBA skills for PowerPoint are critical. NDA required.
Hopefully this will be...(Cyrillic character set). I need these split into two columns: one for the English, one for the Russian; both comma-delimited. The purpose of the project will be to provide a VBA macro that will do this. I will supply the full spreadsheet to interested bidders. Please let me know if you have any questions. Thanks for bidding!
Hi, I would need a quick VBA macro, The task is relatively straightforward: As per attached, there is an excel file with data only in two columns, A and B. For column A you have data for all of the rows, For column B you only have data for some of the rows, The macro should loop through the spreadsheet and copy the content of column A to column
creating a new options to select by department or cost center or both
Kolkata based EXPERT VBA teacher who can help someone learning VBA on freelance basis.
Hi H John D., I am not as VBA-competent as I would wish, and I want you to engage you to help me understand what VBA coding might be possible to move entries in various Excel worksheets' fields to a single database and allowing for updates of data in subsequent entries into those worksheet fields (essentially allowing for an audit trail, which would