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
I need a VBA or other type of programming to add multiple accounts into MS Outlook (2007 and above). The account details can be entered in an Excel sheet. VBA should manage account creation for me even I provide hundreds of account details and it should set up all of the accounts in the same profile. Thanks.
My name is Pilar, I am working on building an excel for tax calculation purposes and I am running into some trouble with a formula that I cannot build-in on my own. The excel is basically an annual gain/loss stock portfolio statement that takes the dollar amount of the purchase and sale proceeds and converting it into the official Mexican peso rate
I need a VBA or other type of programming to add multiple accounts into MS Outlook (2007 and above). The account details can be entered in an Excel sheet. VBA should manage account creation for me. Thanks.
...across your profile. I need someone who can write a VBA code in Excel that automate some basic calculations: I use an online accounting software to do my booking. But I need certain ratios for which I use Excel. I download the data from the accounting software as a csv file imported into Excel and then I calculated the ratios. I would like to automate
I need a VBA or powershell or other script to add multiple email accounts automatically into Outlook 2007-2010 and may be other versions of Outlook. All of the accounts will be pop3. For example I want to add to my Outlook desktop client 10 accounts at once. I need this today. Please only serious freelancers who can do this for me. Thanks.
Want to scrap the gaming site - ONLY Macro expert bid -Want to scrap from VBA only . Please bid. Details will be shared with winning bidder.
Hi, I am creating an excel userform based tool and would like to hire someone who is proficient in excel, userforms and VBA. This project is expected to last for around 2 months full time(significantly less for a person who has great VBA skills).l I know exactly what is required to be built and have a Proof-of-concept with the code already ready and
I NEED AN EXCEL FORMULA CREATED FOR A HYDRAULIC LOSS PIPE CALCULATOR, I WILL PROVIDE A VIDEO OF ME DOING IT THE LONGHAND WAY (BY HAND) I WILL THEN NEED YOU TO CREATE AN EXCEL PROGRAM FOR THE CALCULATIONS TO BE AUTOMATED - THE CALCULATIONS WILL BE BASED OF INPUT DATA EXTRACTED FROM A COMPUTER PROGRAM, THIS DATA WILL INCLUDE PIPE SIZES, LENGTHS ETC.
I have a spreadsheet data base of time entry which there is VBA code which creates a formatted Calendar and displays the hours worked by day on the calendar format. For any week that splits over 2 months, the total hours for the week are supposed to show in the following month. However, there is a bug in one of the months. I need someone to fix
...specific loan/payment calculator that we are using presently. Our problem is that we would like to have it distributed with more sophistication than simply sending out the xlsm workbook alone, or an xlsm with xlam for placing in the xlstart folder. We'd prefer the securiity of a COM DLL, and an install shield type of package that would be more secure and
Project is 1,800 addresses that are separated into 3 sheets in the workbook. I need these to be converted to 3 separate KML files. I DO NOT have the latitude and longitude coordinates. anyone can do it? only expert apply please, thanks
I have a spreadsheet with approximately 1,800 addresses that are separated into 3 sheets in the workbook. I need these to be converted to 3 separate KML files. I DO NOT have the latitude and longitude coordinates. This will need to be done via the addresses provided.
I need five powerpoint slides edited and three powerpoint made with the same colour scheme 3 and four worksheets in a workbook. Please change the colour scheme to fit in a book- IE softer blues and contrast colour On both new workesheets add this - as title There are two significant factors to consider regarding replacement Comfort…..temperature
VBA Code for Form Filling, from an excel table Hello, I'm needing a vba code that fills out a form on a page on my company's intranet. We are talking about a Human Resources sector In excel I have the personal registration(ID), name, note and description On the intranet page, the code needs to copy the excel personal registration(ID) and click on
Phase 1: Data Staging from Stock Exchange file or API with applied calculations using Combinatorics. Output in webapp or excel
I am a business person. I have created a workbook for entrepreneurs. The name of the workbook called "Entrepreneurs Perfect Start for Success".I need you to create a nice work book cover with the title. Author name: OD Harris
...values from Excel VBA to mynn and receive the predictions from mynn in Excel VBA. Currently within R I send my input to mynn this way: # make a single prediction x <- [login to view URL](5.1, 3.5, 1.4) names(x) <- c("Length", "Depth", "Height") prediction <- predict(mynn, x) I noticed there are several examples here [login to...
I need very simple code....unmatched it needs to Append those unique "Quote Numbers" into the tblProposalStatus. (There should not be Duplicate "Quote Numbers" in the tblProposalStatus Table.) I need VBA Code. So I can take what you submit and paste it into an event action (button: on Click) Private Sub CmdRunButton1_Click() Your Code Here End Sub
Details will be shared with winning bidder. Please bid if you have develop vba for corel.
Details will be shared with winning bidder. Please bid if you have develop vba for corel.
set a timer in an excel worksheet, once condition met in the worksheet1, copy and paste certain data to MS outlook and send it out everyday , back to workbook, create a worksheet2 and name it (mmddyy the date we create) save the data(we send to outlook) in the same workbook in the attached excel, if G3 >10%, copy A3:E3 to outlook again if G4>10%
Extract data from a website with pagination. Need to get the data to Excel file. Not a complex data extract, but since it has pagination I am not able to get it using available tools. Developer with Excel VBA knowledge & web extracts should be able to do it easily.
Make me a Macro / VBA / Program To be able to Nest objects in corel draw into a given size area, and be able to dictate what gap to have between the objects, and also dictate the gap between the given area and the objects So in short I want to be able to for example: create an oblong box in corel draw, I have objects on the page that I want to nest
Using a macro / VBA Nest objects in corel draw into a given size area, and be able to dictate what gap to have between the objects, and also dictate the gap between the given area and the objects So in short I want to be able to for example: create an oblong box in corel draw, I have objects on the page that I want to nest within the oblong box I
...where it can be uploaded into our systems either in EDI or excel format. However, not all terminals in the world today are able to produce the TDRs in the TPFREP format, hence a number of locations worldwide are still sending their TDRs in their own formats. The task is to be able to write a VBA code to convert the TDRs from those terminals not able to
...rid of "enable content" on opening, make a trusted workbook. 2. Add 4 offerings to a drop-down class menu. (I'll provide the additional information in more detail once hired) 3. Between columns 'AG' Add macro buttons or VBA for an interactive dynamic list of classes that prompt the existing dynamic calendars in the same way the drop-down clas...
...rid of "enable content" on opening, make a trusted workbook. 2. Add 4 offerings to a drop-down class menu. (I'll provide the additional information in more detail once hired) 3. Between columns 'AG' Add macro buttons or VBA for an interactive dynamic list of classes that prompt the existing dynamic calendars in the same way the drop-down c...
...ISBNs or more in one upload) as an excel workbook to crawl the web/APIs and be able to return the following data on the app side- Book Title, Author, Book Image, Number of Pages, Book Description, Genre and Publisher. There are 2 key challenges that you must be able to find a solution to-1. Fast speed upload of big excel workbooks with 1000s of ISBNs 2
Hi, I need to be able to fill a web form automatically with excel data, excel file contains basic info like names,address,email. I think it should be pretty simple for some of you.. let me know if you can do this and how long it takes,
Depending on the currently logged user, render a different filter items: 1. all employees as filter item where parent is currently logged in user 2. the year of the first record for this user *and* his children until next year
I need you to designe/vba code a excel document that give a good overview of stock holding of personal equipment. The sugestion of a setup and how i want it to be can be seen in the excel document that are attaced. 1. overview over all registrated crew. 2. Profil can be added for each person and materila/equimpent etc. 3. It should be easy to work
...native language and there is another macro which saves invoice in pdf and excel new sheet. I need to make better logic for selecting invoice number, because it is not working ok .. (I will tell how). And there is a problem somethere, when I run macro which saves invoice excel starts not responding. Few days before it was everyhing ok. But now something
...measured individually. We use an Excel VBA script to generate a table from some input tables, which eventually is used for controlling a measurement robot. This vba script used to work fine with an old version of excel (5 years ago or so) but does hang or executes very slowly with new excel (2016, version 1807). The vba runs two nested for loops o...
We have a dashboard that holds some sensitive data on the backend, I need this data to be moved into a seperate workbook and a series on vlookup / Importrange formulas created to make the sheet read from the data workbook. NO more than 10 formula
I need to get a Excel macro developed that can match two Excel files and find matching lines based on amount. The macro should then take all rows that it finds matching and list them under each other. and the ones it did not match it should line up in another column.
Write VBA program in excel that will automate the process for going through a library of MS Word documents and extracting specific paragraphs and tables from the Word Document and inserting the results into a excel spreadsheet.