We have an Excel Sheet with details of work to be invoiced each month. We have used Pivot Tables and VBA to create the Invoice. Additional VBA is required to do the following. 1. Add the header row of the pivot table to each page of the Invoice. 2. Increment the Invoice Number by 1 each time an invoice is printed. 3. Add the customer’s name &
...data entry. My expert in VBA left the company 3 weeks ago and I need to move forward on my project. The project is simple and consist in : (From an excel sheet) 1) automate login into website 2) copy and paste data from an excel file into the website 3) copy and paste data generated from the website on the excel sheet. This is done manually
...embedded/nested tags. The project is required to be run in VBA in excel. It should be able to either "throw keys" or take limited control of the page to loop through a list of values, look these values up and then store the innerText of what is displayed on the page in the respective columns/rows on the excel page. Preference would be that the macro is able
5 files need pivot table, pivot chart , chart using VBA code.
I need you to extract only certain details from the attached XML file. Example <item name="[url removed, login to view]"><![CDATA[Achievement bearbeiten]]></item> I would only need the data between the second [ and the next ] in a new word document. So here you would remove everything but "Achievement bearbeiten" and have this in one line
...so choosing all values in those fields. • I would also like a button to export the results to a new empty spreadsheet in excel. With my very limited knowledge I would assume a connection string may be required if done though vba which will be provided if needed. Following pass-through SQL Code select informix.whs_order.whs_order_nbr, informix.whs_order
I need to scrape data from a website and save into a mysql database
These are the requirements of the app: 1. The application should allow the users to capture a photo using the in-built Camera. 2. The camera should save images to the SD card of the device. 3. When the user is finished taking photos, they should be returned to the app where they should be able to view the photo. 4. The application should
...from each product page: Features Specifications Part Numbers Downloads (if available) For this project, you will write a VBA script for Excel that will go through the website and extract this data and create an Excel workbook with the HTML from each tab in a cell along with the item's main part number. For example, for item D21 (http://tecniqinc
The requirement is to sc...requirement, though scanning each entry would be good. Drop a message with your approach or a sample of the output, the results just require syntax de-duplication from source image.. Will pay for the the requirement. Thanks. Forward a message with your inputs, and will attach the document or the physically scanned book.
...website: [url removed, login to view] extract hospital name and address for all of Canada, need to go through each province and extract the data for each city. Name and address for each records to go onto an excel record. * Nice to have determine the latitude and longitude for each address (geo-coding)
I ha...Word Perfect files (.wpd) that need to have the password removed and be converted to a word .doc format. I need someone with access to the old software and who can remove the passwords. See attached example. If you are qualified, please convert the example file and send it back to me. I will then award the project for the remaining files.
[url removed, login to view] site has listing of dental offices want to get name of office in one field and address in...listing of dental offices want to get name of office in one field and address in another field, just the address Calgary not needed in the address field output can be an excel file
I have an already functioning VBA-code, which hast to be modified to fit an other case. A new variable hast to be added, which also affects already existing variables. The VBA-skills you need do not have to be very advanced, but you need enough experience in programming because understanding the problem is pretty hard. You also would have to work with