I want someone to scrap data automatically from the given financial websites using EXCEL Macro. Then apply some formulas to calculate some desired output. The macro should be fast to bring the output. Use the graphs Below are some websites for your reference [login to view URL] [login to view URL] https://www
...working on a personal project where i have an excel sheet (call it input sheet) with 4 columns and several rows (not fixed). I need a program which on click can sort out rows in desired order (based on a key word in second column e.g. 'Design', Test', 'Material' etc. and desired format. Results shall be in new excel sheet (call it output sheet). Out...
Looking for freelancer who can visit our office and do VBA work as per requirement of the head of department, should be good in advance excell, macros, developing applications, maintaining computer system, collecting data, set of reports.
Hello! I need some simple PHP (+5.6) scripts with example on how to comunicate and manage a XMPP server (Prosody 0.10.1), using JAXL or similar free PHP library. - Create and delete an user account; - Add or remove an user from a specific user roster; - List users from roster with status (online / offline); - Send and receive text message to/from a
make VBA-function to request simple informatie from 2 sites/webgrabbing. Often I have to look on 2 sites, type some inputvar to get a value. I want to automate that request in MS Access 2010, for future requests. The 2 sites are: [login to view URL] (fill in a zipcode+housenumber to get a energy label of the house) [login to view URL]
...problematic in the past. This video below shows how to code the for the Checkboxes in Microsoft Word. That would To prevent the end user from accidentally clearing the form there should be a caution box in that once the end user hits the clear form button a box would appear “Are you sure you want to clear this survey? YES NO The box should look exactly
...submission workbook. Should not paste if the data is existing in Main Reg(Related charts and tables should be automatically updated) 3. Weekly submission can be from any site. Example provided is Marina 01. Each Submission document will be in a different file with different file name. So macro should prompt user to encode the site code and it should prompt
Hi... We would like to design a front end user form using the existing excel sheet. We have done all the formulae and calculations. You must able to convert this set of info using vba and design the form. Its manufacturing parts assembly form. Data will be shared during our discussion.
Trace a Homes Floor plan, add color and landscaping as the example shows. In addition to the Bailey floorplan, here is an example of a past project, these only take a very small amount of time to do. See the Grant Flyer, then see the finished product by taking that Grant Floorplan from it and tracing it to make the pretty 2-page colorful landscaping
I have an Access database with tables, queries, forms (with vba code sometimes) and reports. This database now is sepparated by 2 access files. One with tables, and other with all rest, because we need to work some persons with this database. But some tables are very big, and queries sometimes are slow to load. Now only one person work on database
I will show you an example website and you modify it to my company. You will need to recode some as google doesn't like duplicate coding. 5 pages with top tabs and maybe a sidebar so I can add more later. Nothing to hard. I have a logo so you will need to intregate that into the website. I need to get this up and done today. Shouldn't take that long
...are not limited to the following: - Microsoft applications: Excel, Word, Power point etc.. - PDF Fillable Forms: PDF creation, editing with scripting using Adobe Pro DC. - Data entry – PDF to word, PDF to excel, - Web Scraping - Data to CSV and image extraction using IMacros, VBA Macros, Zillow Zestimate, Yelp,YellowPages,Houzz, Sport sites.
I also needed a before/after slider made so I can compare photos. E.g. the before photo and after photo. I need it a webpage that I can create and load up to a sub folder on my website hosting address. I need to show a header and be able to select the image sizes of the before /after slider or even full page. I also would like to compare 1 photo and then be able to select and compare from mult...
Hello, I Need to copy data from pdf to excel using macro. Pdf have some data including image form which need to be copied in excel . More details will be given to selected freelancer. Happy bidding. Thanks
Must be fluent English persona and have phone account so we can chat. We require Data completed Immediately or at least 12 hours.
...(mismos que pueden ser visibles con Open Office) hacia un libro de Excel por medio de código VBA. Tengo muchas tablas de este tipo de las cuales necesito extraer información, entonces el número de filas y columnas con contenido sería variable Anexo un ejemplo de mis archivos .dbf y un Excel que reflejaría el producto final Un manual con ...
Need help writing a vba code to import a tab delimited text file into an array, return the list of clients that has matched email address for population as value for a listbox control in outlook vba. Please refer to attached file, there's 3 columns of data: client, address and email. Code to 1. import tab delimited file into array. 2. search through
...such MS Outlook for sharing database and avoid duplicates and usage of this template over internet online such at sharepoint!.... Of course that study would require some VBA and SQL scripts, cloud and security information feedback for the developer. Just to imagine what we are looking for: The project is similar in MS access 2007 templates list
I have to set a relay controlled by arduino from a condition processed by vba access
I have a VBA code that I run which helps me divide up a larger spreadsheet for customer orders. We have one customer with two sub-units that order multiple parts from multiple locations at once. I would like the macro to look up the parts in our inventory spreadsheet to determine what we have available to ship, look up the sales order number, purchase
Hi, I want an example code that uses the built-in implementation of OpenCV's KCF tracker [login to view URL] together with the built-in implementation of HOG features. [login to view URL] The version
Hi Zoltan N., I noticed your profile and would like to offer you my project. 01 VBA macro that logs changes in a column in existing excel file each time an existing macro is run. The VBA code has been written, but is not working properly. 02 In the 'logsheet' push the 'old' values together with a timestamp in a column to the right side... There is
We have an excel macro that copies data from one worksheet then creates a pivot table on said data. For some reason, as the quantity of data has increased, some of the data being copied is lost. I know which row the data stops at. It seems some of the VBA or Formula's are incorrect. The data seems to stop at SheetA: Row: 13880
I am trying to create an algorithmic excel trade sheet based on multiple, optional criteria. The user will have many optional fields to fill out. The vba code will need to go look up values in different places depending on which tables the user selects. And this code will need to run over multiple cells. See the attached image. The user will
write me an VBA Code which fires a mysql query as a pass through query in ACCESS 2007. # background information Access checks the query if it is sql well formend. After you switch to pass through query you can also fire mysql queries to an externals server. I need a vba code what i could only do in the frontend A Mysql Query is for example is INSERT
Hi, I want an example code that uses the built-in implementation of OpenCV's KCF tracker together with the built-in implementation of HOG features. The version of OpenCV should be 3.4 and the OS Linux/Ubuntu. I would like this to be done asap. Thanks.
... I have a fully functioning daily database app which was created in Excel VBA but unfortunately is running too slow so I want a replica of that daily sales database built in Java. The new Java app must be able to run on a Mac and Windows. All the functionality and layout of the VBA app must be carried over to the new app. What does the existing app
Hi, I'm looking to find someone who can help me on the coding of an Excel VBA Multithread web scraping project involving multiple URL's, each containing multiple tables. Here's a link to the type of URL's used: [login to view URL] The full workbook will need
Seeking a challenging career with a progressive organization that provides an opportunity to capitalize my skills and abilities in the field of Graphics Design and Architecture. I am recent college graduate seeking a position that will allow me to use my Bachelor in Graphics Technology Major in Architecture Technology, my practical experience,strong interpersonal skills as well as my eagerness to...
Hello, I am new to Excel, and trying to write code for VBA, but just found myself spending whole day on it and running in to error all the time. I attached Utilization new template file, and what I am trying to do is: 1)A-Asset Inventory WorkSheet - Cell D3 I created a dropdown validation for "All, Owned and Rental". I need to insert a button "Hide/Show
I'm a cyclist. I need some graphic designer who can...can put a human body shape with parts from bicycle. It could be a mosaic or any way you create a nice human body shap with all the different components from a bicycle. For example, the head can be form with the chainset. I have attached a picture. This is the same idea I want but with a full body.
I need the VBA code for Microsoft Excel which enables me to generate customised e-certificates in pdf format with customised file names. Include one face-to-face meeting to explain the code and how to use the document. Example: [login to view URL]
I have an excel sheet where I have inserted list boxes with the capability of selecting multiple checkboxes. When selected, it must appear in the selection in the adjacent box: See this image for better understanding: [login to view URL] Now I want to have the same in multiple rows. THere maybe 500+ rows, I can do it manually by editing
I want to get a VBA automation created which downloads the data from a ecommerce website , with automatic login and downloads 2 files of excel and merges the data , and forms it into a specified format, and sends the file to specified group everyday in the morning.