Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using
Excel Add-In joka hakee ja tallentaa taulukkomuodossa oleva...hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.
We want to hire a person to go to 2 x websites: [kirjaudu nähdäksesi URL:n] and [kirjaudu nähdäksesi URL:n] From here we want to activate the following fields: FSC - Country - "Australia" - Certificate Status - "Valid" - Certificate Code (2nd box) - "COC" PEFC - Country - "Australia" - Certificate Status - "Valid" - Type ...
...an Excel Application that pulls data from the Spire PostgreSQL database and then allows the user to enter data. As the data is entered SPOKE performs various calculations. Once all required values are entered the user then can push the specifically calculated values back into the Spire database via SPOKE’s current VBA code. (Spire is a full Business
...Excel VBA macros to copy and highlight some data from a few columns to other sheets/worksheets. Please sign the NDA, read the requirements in the word and txt documents and feel free to ask any questions you may have. Bids over the maximum project amount will be ignored. P.S. Please note that some columns and rows get added every week and data needs
...debug error this workbook collects data and on collection when running it makes selection as in the races sheet. I no longer want to collect data from certain sources so needs all the links removing so as not to get debug error and remaining data collected will give me the figures I need without errors the data changes daily Please look at races
I am the Data Admin for my company. I am currently interested in building a form for the company. I specifically want to use excel, but I also want a nice, friendly and intuitive interface. I have experience with VBA macro's. The form must be able to have as many "if" "then" options as I want.
...formulas, macros (VBA) and who can help me with a large project cash flow workbook that I have created. Some years ago when I was working at another company, I actually created a functioning version of this workbook that utilizes various monster lookup formulas to search through three or more (+3) sheets of big cost reporting data. The challenge I’m
Hi, I need an expert on the MollyBet API, Excel VBA and API/Excel VBA interactions for a project. When I write expert I mean EXPERT. Details will be provided in chat. Thanks.
We need someone to go through [kirjaudu nähdäksesi URL:n]'s wine selection (of around 1800 different types of wine they sell). Scrape the information and then take the same bottle's name and scrape the info from [kirjaudu nähdäksesi URL:n]'s descriptions on it. Below screenshot shows all the information that we need:
Epic As a project manager I wish to have a macro enabled RACI chart where I can document the tasks, roles, and responsibilities on a “RACI” worksheet. On a “Role” worksheet, a list of names, roles, email addresses along with other personnel information is entered. On an “Email” worksheet, the results of the macro would be displayed in four (4) categories; &ldquo...
Hi Milan S., I have another Excel VBA project for you, if you're interested. There is an Excel worksheet that resides on a server at work. It is shared by many people, we only want one person at a time to be in it, and some people stay logged into it for hours even if they aren't at their desk. That keeps the rest of us from being able to do our work
I would like to have someone who is proficient in excel and VBA to build a simple calendar scheduler and student enrollment forecast in my excel with the data set i have. On top of that, i need someone who is good with formulas such as index-match to assist as well.
Standalone VBA macro that will compare any two csv files based on a key column (in this case 3rd one) and create a new csv with differences (could be changes to existing rows or new rows). Needs ability to define the delimited (comma or semi-column) and ability to convert date fields into numbers
Does anyone know how to write a small VBA code to automate a process of pulling data from a website into a spreadsheet please .. Has to be through VBA so if you don't know how to write a VBA doe please don't apply for the job ..
I have an excel vba solution that produces a text file from a spreadsheet. This text file is currently imported into MYOB AccountRight Time Sheet module and the Payroll is then prepared in AccountRight. I need a VBA programmer that will take the text file and send it into MYOB AccountRight In The cloud. So no need to do the importing. please see http://developer
Scrape all the posts (~84K) some variables from each post in [kirjaudu nähdäksesi URL:n] (I will explain which variables need to be extracted from each post). I need the python code to run it myself as well as the database. No captchas, logins or any technical roadblocks.
Hi Milan S. You did a few projects for me a while back and they were great. I have another, if you're interested. Here's the project description: I need an Excel VBA macro that, when a button called "Midnights" (placed on a sheet called " Operator Sheet") is pressed: * It deletes the contents of cells B3 through BT on a sheet called "Shift Lead Sheet&qu...
Hi there, I'm currently working on a VBA code which aims at extracting the data of a particular searched address(like area, zestimate, rental zestimate, tax & year of tax). I'd like you to develop code within the next 10-12 hours. The code if accepted may lead to various other project proposals by the client. Only serious bidders required
Hi, I am using an excel documents that has a few input sheet and based on various formulas, several output files are generated. These output sheets has a few chart...files are generated. These output sheets has a few charts. The initial coding is done, however I need someone to finish it. Should be a 15-30 min job if you are efficient in vba coding.
We need a VBA developer that can interface the Excel engine with our Access database so we can run reports for our clients. We would most likely need only a few hours of work every month. Someone with applied mathematical skills and knowledge of Bloomberg would be a plus.
I have three "Saved Imports" I want VBA Code to upload each of them. When they are uploaded, I want to add the Date the information was uploaded added to the second to last column and to add the UserID to the last column (in each of the three tables). The code shouldn't run all three uploads - I want code for each. I am assuming you don't need the
I have 31 PDF files, each containing about 200 pages. On each page are names, email address and telephone numbers that need to be extracted and put into...pages. On each page are names, email address and telephone numbers that need to be extracted and put into a spreadsheet. YOU WILL need a automated method for scrape. this is a large amount of data.
Hello, I have a lot of email addresses in excel. I need an excel VBA to send emails with a pdf attachment automatically. The text of every email is a template, but the VBA must chose the salutation correctly. Thanks for your help.
I need a spreadsheet of all available opportunities on the property market. There are three main property sites, and I need data scraped from each site but specifically, filtered for London and Land. In the spreadsheet I’d need the description of each line item.
I need to attach images from a folder from my PC (I want it to be prompted while running the macro regarding which folder to select) basis multiple Option Numbers (please refer file). The macro should look for images from the folder and insert it on the left side of the column (Specified for image) and the rows should auto adjust basis image height and width.
...website and have certain data scraped and stored into my database. This page shows different information with each ID. The URL will be [kirjaudu nähdäksesi URL:n]$variable where $variable is an ID number. As an example use [kirjaudu nähdäksesi URL:n] to see the layout of the page and the data. I have had this done
...e-mail and a button and make sure the script sends that e-mail to a fixed e-mail-address. 2. Excel-VBA: Again - I only want the code - I will install it and tweak it myself. The program should fetch the Google Forms data and put it in Excel. The data to be fetched is filtered by the e-mail the user of the Google-form has given. In your code you can
I need a VBA script written that can insert row data into MS Word and MS Powerpoint and then add an entry into MS Access. The script should prompt the user for the row's primary key (number) and then retrieve that data from the table and insert it into the word or powerpoint document at a specified bookmark location. Simultaneously, a new entry in another
to create a utility using vba, functionality of the tool - open and parse a source file (PO file, attached), PO syntax can be found from [kirjaudu nähdäksesi URL:n] - for each message to be translated, ie. the message after "msgid "/"msgid_plural", call a function convert(msg) -> just return msg in this function
We are running a few research projects and need to source a lot of relevant industry images. For an example, the first project we need images of Garage Doors. You will use scraping tools to find images of Garage doors from Google images etc. You will find images that are minimum 800x800px in size. You will manually vet the output and ensure that every result is a garage door etc. We will pay ...
Hi, Im a student looking into simple VBA Excel project. Need help on generating Sudoku 16 by 16 grid. Requirements:- - random puzzle generator with 4 levels of difficulty - comes with a solver/solution - hints or guide to solve puzzle in Bright Colours and Bold Numbers - start and stop timer - VBA Excel format - fastest timer ranking (optional) Additional
Please refer to the spreadsheet: I need to look at status, if the status is "Executed" then ignore and go to the next row. It then needs to find the latest date entered for that row, in row 2 this would be 16/11/17, it needs to then put into an array the contract number "2", then comments "Finalising contract" then the date 16/11/17 followed by the latest date header...