I have an old workbook - xlsx format - that I forgot the password and need to unlock. Since its newer than Excel 2007 its encrypted and the old style VBA password buster wont work. To confirm you have unlocked the workbook show me "Period 1" sheet
I need vba that will autofill and autoclick through the creation of a Salesforce opportunity. You don't need to know anything about Salesforce. Take csv data in worksheet and fill fields, click buttons to move to next screen, etc..
I have an Excel tracker file from which two dashboards and graphs are to be generated. The tracker gets updated regularly. The dashboards and graphs are to be updated automatically. Time line to complete task would be 2 days. More details will be shared with short listed freelancers.
Hello, i am looking for someone who can scrape the DHL parcel information with MS Excel vba. The tracking number is given (Column A) and the tracking information (Column C:L) should be scraped from DHL page (Link in Column B) This should regulary be done for up to 50 tracking ids.
I need a Macro which can extract specific data from a word file and then generate a User form with drop down having the data from the word file and finally generate a word template with the values selected from the drop down in the user form
...need demo ro using userform in outlook use to set appoitment step 1 : build this simple demo userform in outlook step 2 : set appoitment based cretiria the vba code should look for appointments in the calendar in date 14.11.2018 in this exemple if from example there is appointment in this data from 10-13 then
I have two sets of data wich have DATE, TIME and four other values, some of those dates/times are mismatched, they exist in one side but not in the other and vice versa. I need a macro/script to align all DATES and TIMES and delete the mismatched values in sheets up to 250k lines efficiently. I have uploaded one examples of raw data that need to be aligned.
We have some sales data in a flat file that is structured like this at a transactional level: Product Date Quantity ABC 1-Nov-2018 24 ABC 5-Nov-2018 36 XYZ 12-Aug-2018 32 etc We want a macro VBA Program that can take this data and do the following: 1. Summarise to monthly level by product Store as a new
Necesito un código en VBA que extraiga la data que está en la siguiente web: [login to view URL]:9d16c843bb5201b86696ba79f964adbf/stock/AAPL/financials y la coloque en una hoja llamada DATA. Adjunto el archivo excel donde debe realizarse el codigo. ---------------------------------------------
...Cloud ML Need someone with actual experience installing models to Google ML Engine and configuring them to process jobs. Ideally, you know how to trigger a job based on a new file uploaded to Google Cloud Storage Please don't apply unless you have actually made this work and can demonstrate your experience Auto bids will be deleted False bids will be
hello, we bought new BGP Edge router which uses XR ios , and current ios configuration not compatible. needs migration from IOS TO IOS XR. BIDDERS MUST HAVE CCNP certificate
I have two sets of data wich have DATE, TIME and four other values, some of those dates/times are mismatched, they exist in one side but not in the other. I need a macro/script to delete those values and align all other entrys in mutiple sheets.
Code to copy from a worksheet with multiple pivot tables, timeline slicers, and a pivot chart into a new workbook and retain formatting (freeze pane). We need to copy the date from the pivot chart to the a new workbook based on every filter in the pivot chart
Develop a node.js azure function to read an azure table with following columns and provide output over https call. The key for table is email address. column details: Partition , Row , Status, Limit, ClientId Sample data: A, abc@[login to view URL], active, 200, ICE1309 The function should be called via http trigger http://............. row = 'abc@[login to view URL]'
Try to code in VBA but it's not working. Trying to select on range of 2 original columns and match a new column and replace it with one of the original columns.
Convert a Single Excel Macro VBA Calculator file with buttons and simple math formulas to an Android App to be used on Android Phones.
I have an Excel spreadsheet that uses the worksheet_calculate function within VBA to monitor changes to a cell on Sheet1, which in turn triggers a timer whenever a change is made to that cell; worksheet_calculate is used instead of worksheet_calculate because the cell contains a lookup formula that references a table on another sheet within the workbook
Manufacturing business wants to take a daily download excel file from GE Appliance website and create a Macro/VBA tool for non-excel users. The tool would look up our internal part number and box count from a table and output a pick sheet for shipping with customer part number, our part number and number of boxes. Should be able to select time range
Need the file automated. I can provide a full walk through on how its currently done, but would like to automate the file! I have to filter every interval and it pastes data. I would like to avoid filtering every interval.
create API in my word press API and connect to my HasOffer Account and manage marceting campaigns [login to view URL]
I have a very complex macro which takes a csv of all our orders and put it in a neat printable html format. It isnt doing one of the things its supposed to properly so I need that fixing and I also need to give it some extra functionality.
- Updating of pivot tables to ensure that numbers change when cells are updated - Advanced filtering - Having a data entry sheet and using VBA to transfer the new data to the bottom of the existing data set - Improve user experience by making future data entry convenient
...the usability of the tool, we will need the excel spreadsheet to host a number of specific VBA's to improve usability and functionality. I need a VBA programmer for approximately one week with proven VBA credentials to further assist in the development of the excel spreadsheet. It will be for Mac and PC, 23 bit and 64 bit, 2010 - 2016. VBA's with the
We are looking for Freelancers that can help us in building a solution where we can upload/downlaod information from an MS Access database to WooCommerce and back using the WooCommerce API. [login to view URL] We would need an expert in communicating with the Woocommerce API and Parsing XML data. The goal is 1. Automate and import/export of products from Woocommerce which would also include imag...
Need VBA code to select a row in external SysListView32 and send right click to it using sendmessage or postmessage API. Assume hwnd of SysListView32 is known.
I need a dash board build in Excel. When I paste the data, it needs to process it onto a dashboard showing me sale details as I require. Also I ...board build in Excel. When I paste the data, it needs to process it onto a dashboard showing me sale details as I require. Also I need the data to extract details from master file to sub files on click.
Hi my name is Sotiris Kazabakas, I need an excel with some pop-up alerts and sound alerts. You will find more on the word ...Kazabakas, I need an excel with some pop-up alerts and sound alerts. You will find more on the word that i have uploaded which includes a description of what i need the excel file to do. For any questions do not hesitate to ask.
Hello, I have an Access database with an existing f...Access database with an existing form. I need someone to develop a script that exports the form as individual pdf files for each record in the database. The name of the pdf file will be derived from a field in one of the tables. I will upload an example Access database shortly. Thank you, Simon
I want to prepare a excel workbook in which, I w...Accordingly, in a second sheet an analysis will be prepared. The labour rate will be intered in first sheet as an input. Each and every time a new PDF need to be generated with given file name format and need to be saved. Similarly the loop need to be executed up to the last entry in the first sheet.
need to update outgoing calls, currently set to use SIP, but we are cancelling SIP for International calling and use the ISDN for all calls. the PABX is setup to use ISDN for Local and Mobile calls only and since we are terminating the SIP trunk for International calling we need to have it routed via ISDN
I have two workbooks, each with multiple worksheets. I need the information from one worksheet (as it is inpu...workbooks, each with multiple worksheets. I need the information from one worksheet (as it is inputted) to populate to another based on a couple of variables. Best done in VBA. I will provide the working files to the successful candidate.
I'm looking for an experienced Linux sysadmin who has experience with Digital Ocean. It's about linking a domain and setting up e-mail addresses + email server.