Add buttons to: 1. Save As (name in particular text field). 2. Clear form. 3. Create 6x area polygon and fill with different colour and opacity etc. - and display area value as small text in polygon. 4. Create 6x freehand drawing styles with different colour & thickness. also to lock & password protect template.
Will pay $30. Need a simple macro written. Should take less than five minutes. Need macro to copy name of font from prior cell, move one font down, paste name of new font on following line. I'm trying to get a list of all fonts in Word where it shows them in this document. You can see I've done 1 through 75 manually....
...CSV files into 1 structured report split over 2 cost centres (1 XML and CSV for each cost centre) XML Data will change daily (will have the same file name and location) VBA code written to pull in the XML file, refresh all data and export the report saved as .xls STEP 2: Use the saved daily reports to automate the production of both a weekly
Simple excel macro which use Bittrex exchanges API. Base code in here: [login to view URL] you will find everything what you need in there. In the app we need few parameters: -API Key - StopLoss % - CurrencyPair - Price Check Interval in Seconds Macro need to do Trailing Stop-Loss which is for example: For example, a user buys 1
Hi there, I'm looking for someone to build a tool that uses VBA or excel functions to call bing API and retrieve the first result then log in the domain name Basically, I have a list of companies and I need to get the domain name of each. e.g. I have a company name "Midmac" and I need someone to call out Bing API on the search term "Midmac", retrieve
Create pdf template. Macro/tool buttons on pdf to edit: 1) draw with different "pens". 2) create coloured polygons calculating and displaying area. 3) button to clear. 4) button to save as. 5) button to export all entered fields to excel/csv. Already have a template made up but needs re-doing with correct formatting and functionality.
Please read and bid exactly what you would like for this project, no time for negotiations We would like to revise the attached template to use for future reports: 1. Using the column A "Student_Number" from the first sheet labeled "Data" 2. date of the assessment (column W) from the "SR sheet" for the first assessment of the client by date to be listed in column i ...
Im working on a project that has a lot of excel calcualtions , sheets and formulas. I need to aut...on a project that has a lot of excel calcualtions , sheets and formulas. I need to automate the process to make it a little more user friendly. I have some basic knowledge of VBA but am havign trouble figuring out the best way to streamline my project.
Good day, I want to hire someone who will be able to create me a point of sale system through excel vba. It must be able to meet the following requirements. 1.) Add inventory and price 2.) Keep track of customer listing and sales 3.) Create payment receipt 4.) Inventory count where an email can be sent if it is at the minimum 5.) Sales report for
Good day everyone, I wanted to see if there is anyone who will be able to assist me with creating a VBA excel add in that I am able to push data from an excel to a google spreadsheet and vice versa pull data from an google spreadsheet back to excel. I want to have my colleagues be able to update through excel and if I am on the go make changes through
I have a VBA userform that reads data from a sheet of over 200,000 entries with over 200 columns per entry. I need to convert this into a website that can be sorted, filtered and searched like in Excel. Also need the ability to import CSV files to add to or merge with the existing data if it already exists. Ability to export refined search data as
I have Excel hotel meetings game created ...have Excel hotel meetings game created in .xls format (around 2006) and it now doesn't run, throwing up a runtime error everytime I open it in Excel 2016 on a Mac and PC. I need a VBA expert to review the macro's and VBA code and fix the game so it runs on both Mac and PC on in the latest versions of Excel.
Réalisation d'une macro qui 1- enregistre une feuille courante avec un nom structuré et un path 2- Effacer les zones saisies 3 - mettre à jour le n° de pièce suivant 4- Enregistrer le classeur
Soy un gestor de soluciones. Requiero migrar una macro de word (vba) a un ADDIN en C# con todas la funcionalidades de la macro. De facil instalacion asi como su mantenimiento. Esta solución debe incluir Fuentes, manual.
Hi We have a small scraping macro written in VBA which takes [login to view URL] game ID from column D and scrapes data to Excel for respective cells (so for example for ID 1402510 it will scrape data from [login to view URL]) However there are some minor issues with this macro. One of them is scraping data when betting market was
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
...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). Output sheet shall have a desired format
I need an outlook macro which will convert current events to HTML format. The current formats are rich text and text.
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.
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]
...[login to view URL] I really don’t need the document saved as a template since that has been 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
...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 user to select the particular file and run the process. If it doesnt match with the user input then macro should notify to the user. (Related charts and tables should
we have one Excel Macro in 2003 need to upgrade macro ,
...a small travel agency recently started and we are looking to customise a costing excel sheet with certain formula's which can calculate package cost and print the package in word or note file. We have designed an excel sheet ourself but want to rebuild the excel sheet with more functionality added. Need a expert in excel who can rebuild the excel sheet
Hi... We would like to design a front end user form using the existi...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.
I have a Python script which basically runs an Excel macro, but it is giving me a Runtime Error 1004. the macro basically refreshes Bloomberg formulas in the sheet. The macro runs fine within Excel but gives the above error when calling from Python.
...have a suspect macro document and need to understand what will happen when it is opened on windows 7 or 10 with Office 2010. Apply only if you have such system available to test and can do it very shortly after the bid is awarded. Your participation is to: 1) download malwarebytes freeware and run it to verify you have clean system 2) open the attachment
I need someone who can create a macro which will find duplicated events in Outlook calendar. The macro must search by these parameters: - Start - End - Length of event - Attachment - Body text - If name includes "Copy :"
There are about 6 sheets and we need to pick certain information from those sheets and make a summary sheet. This project is in the google sheet. This is a simple project and total project cost is10 USD only. Please check the project here [login to view URL]
There are about 6 sheets and we need to pick certain information from those sheets and make a summary sheet. This project is in the google sheet. This is a simple project and total project cost is 600 Rupees only
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
...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. -
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