Visual Basic Jobs

Hi, I need someone who can execute queries, from within Excel VBA such as the following: [login to view URL],THB,HKD,GBP,EUR&base=USD To retrieve currency data and then paste it into excel cells. The HTTP query from within VBA is quite simple to build. Example: str = "[login to view URL]" _ & "&start_at=" _ & Year(startDate) & "-" & Mont...

Hi, I need someone who can execute queries, from within Excel VBA such as the following: [login to view URL],THB,HKD,GBP,EUR&base=USD To retrieve currency data and then paste it into excel cells. The HTTP query from within VBA is quite simple to build. Example: str = "[login to view URL]" _ & "&start_at=" _ & Year(startDate) & "-" & Mont...

Background: Excel spreadsheet has two workbooks: One for data entry, one for controlling entered data. Entry to a range of cells (A1:A10) on data entry sheet is LOV controlled by a table on the control sheet. The table controlling the LOV is exhaustive and the user cannot enter values outside the range. A second range of cells (B1:B10) on data entry sheet are controlled by an LOV, which is depen...

Looking for someone who can create audio video at corporate level. Get in touch to know the project better

We have a report that we have generated with around 3500 rows of data. These are shifts that our workers have worked. We want to be able to have a Google Sheet where we import data like this each week and it populates predetermined charts and graphs. I need someone who is at super advanced Google Sheet skills to be able to create a template spreadsheet so that we data dump into sheet 1, and then a...

Please bid if you are expert. Details will be shared with winning bidder.

I want to list some numbers , and then have excel randomly select a number from that list( I want it to select 5 random numbers)

I have a data export that contains duplicate rows of data for the same user identified by email address. All of the other columns in the spreadsheet for each user can be different. Some will be NULL and others may have values. I need a VB script that will do the following: 1. Identify duplicate rows identified by the email address column 2. Consolidate each set of rows with the same email address...

I'm looking for a complete dataset for the Gender pay Gap in The United States. You need to include all the states, ther gdp, the proportion, pay gap between men and women. Education for men and women for each state, the sectors where they differ in their jobs and their pay and many more needed information to make a complete dataset using Excel.

FACTURACION ELECTRONICA PARA MI SISTEMA QUE ESTA EN VISUAL NET FACTURAY BOLETA ELECTRONICA.

I would like have a UK heat map of placements are company has made and has currently vacant by county. Is this possible? We have the data on an excel pivot chart...

I want to build spreadsheets (employee schedules and financial reports) that will populate from other sheets easily.

Need users to be able to enter comments directly into a row from the pivot table and not the data source sheet. They should be able to enter anything within the field be it unique/duplicate info. The 'comments' row must also be able to sort with the pivot table. I was able to somewhat get it to work by adding the columns in the source data sheet, placed a unique number or character in ...

Payment is INR 600 Program is in Visual Studio and has to be done right now. 2.1 - Write the definition of a class that represents a Car. Include the definition of these properties: VIN Number, GasLevel, Mileage, and MPG (Miles Per Gallon). Make sure to choose proper data types based on how these properties are used. For example, VIN Number, even though a number, but does not need to be defined as...

Hi experts! I have few google sheet files that require some data manipulation such as deleting some columns and rows, filtering and sorting, add some charts and perhaps add data from multiple sheets into one. It is also possible to do a Macro to apply the same manipulation into an Excel spreadsheet, I will just download it from google as excel format and use the macro. Let me know if you have a...

This project is to build a VBA macro to cycle through a drop down list of dates contained on an open internet explorer page and print them to pdf via pdf creator. For the file name I would like to be able to type a 6 digit number at the beginning of each run to be used with a date stamp added from the webpage (I.e. the pages date that is currently being printed). The dates on the drop list are var...

build small app that lets me send out emails one at a time from excel spreadsheet. I use outlook as 2010 email client. One email contains a PDF File & another email contains an excel spreadsheet. Seems like sending 450 at a time some don't get through & I don't get notice of failure.

Seeking a skilled programmer to export current LIMS database from Microsoft Access and provide a rebuild in alternative program. This would require creating necessary fields in program to generate documents of its entries.

Need help in Visual Studio 2012 for my work

I would like for someone to build me multiple excel macros with a lookup feature to show high probabilites within a data set. For examle over 90% FHG and for other columns on different macro buttons - can you give me a price thanks

I would like to make two excel file through macros

Hi, I am after a simple excel macro to run on the latest MS 365 excel (2016?). I want a macro where I can easily click on an icon in the excel program.. it then allows me to go to any website/software.. and draw a highlight box (see picture attached). It will then extract all the numeric values into a column view in excel. But I want to be able to paste the values anywhere I chose in excel. So ...

Hi, I am after a simple excel macro to run on the latest MS 365 excel (2016?). I want a macro where I can easily click on an icon in the excel program.. it then allows me to go to any website/software.. and draw a highlight box (see picture attached). It will then extract all the numeric values into a column view in excel. But I want to be able to paste the values anywhere I chose in excel. So ...

We are looking for a software intern for our company. You can work remotely as well. Good hand on experience with C / C++ / VB and willingness to learn 2 new language will be appreciated. C2C 240000

Person should have good knowledge in C++ / VB. Mql will be advantage. Should be willing to sign agreement with us. NDA is mandatory. Developer can work from remote place too. More details over chat.

I would like to create a database with search function. I have set of data in excel sheet and need an GUI for easy searching and copying

Would like a custom webform created to accept credit cards both online and in person that will use our payment processor's credit card fields and card swiping capabilities along with our preset prices. We would also like to be able use the same form for our cash sales and tracking The necessary information will go to the CC processor but the result of the transaction as well as any demogr...

i have some work in excel .after some one to make football prediction software for in excel where it will down load past match info and odds for game then prediction for them as in the chance of the out [login to view URL] you can do it ,bid me my project . budget 50$ thank you

I have images of forms that I need help designing in vb.net and DevExpress. this is a long term job so you should be available most of the time, start you bids with "Hi Devexpress" The controls will have names as follows; Textboxes will start with txt, Combobox = cbo, DatagridView = dgv, Buttons = btn , You should be able to start immediately. Thanks

I want a database for a small clothing factory assembling lines ( 8 ), it should have a graphic calender planning with the detail of the planned production per day and compare it to the real daily production per each line and the summary of all styles progress separatly. it should work as follow: creat a style by adding name of style, client name, order quantity , theoric production per hour for...

Using all the information contained here [login to view URL] I would like on one excel speadsheet (without macros) for the Stamp Duty and Government Grants for each State (ACT, NSW, NT, QLD, SA, TAS, VIC, WA) to be calculated based on inputs it has received from other spreadsheets. Inputs Value of Property $ amount Primary Residence Yes / No Investment Yes / No Established Home Yes / No New...

I am using an old Excel Spreadsheet that has been modified with many Macros to automate a "Risk Management Tool". At the click of a button, I can choose the severity and likelihood factors for risk ranking work tasks on a construction site. There is an "Add-Ins" tab that allows the user to insert rows, delete rows, rank risks from highest to lowest, number the tasks, sort order...

I have a small Windows Forms Application of a software done in VB .Net. I need to create its setup file. The application requires some files to be created and stored during runtime in the user's C/Programdata folder (in the Outputs folder), as well as read some files stored in the same folder (In the Inputs and Samples folders). Files for Inputs and Samples folders will be provided. Some imag...

Hello i need someone to to convert a file from and map out whats inside the file into a txt file thru a small simple app windows for the user just to select the file thru the window app user will get convert button and it will save that converted txt file into a folder on a desktop thank you

I need a freelancer to build out an excel sheet that allows me to upload 10 or more different shipping plans into the document. Those shipment plans each have a number of products going to different warehouses. The products in my inventory are mixed and going to different warehouses. Each product has a custom barcode that is listed in each of the different shipping plans. I need the ability to...

formulas are off, someone made this years ago and something happened to change it.

Application to Digitally Sign Documents 1. Source: PDF of all the documents like certificates, marksheet etc. 2. Mandatory Requirement: a. Location of Signature (Top, left, bottom, right coordinates) b. Source Folder Containing plain PDF documents c. Destination folder for output files. d. Valid digital signature dongle. 3. Process Flow a. User need to specify the source folder from where unsigned...

database applications using [login to view URL] with crystal report and MS access

I want to create an Access database / report (queried from excel files) based on the Form in the attached image. The report will populate based on the database (see excel files) and the data will be inputed either through a User Form in Access or via spreadsheet upload (bulk upload). The bulk upload and input form should have a capability to determine if the person was already inputed. For the ...

We use excel for check how products orders from suppliers with an algorithm, we need a select menu where we can choose the supplier and a button. When we select the supplier and pressed the button an email is created with the products to order. It is a simple thing for who know excel macro, more simple to make that to explain

Need help with attached excel spreadsheet in doing formulas to calculate discounts

Require vb.net developer to work on existing applications and work few hours a day. Should be good in vb.net and xml. We don't want any company. Only individual freelancers please.

scan files in a selectable folder, identify all images in the file and dump the image and all known attributes into an excel spreadsheet.

I need to price a project that involves creating an Access database, populating and updating the database. I have another project involving creating an Excel spreadsheet and building a mailing list from it then mail merging this data to do a mass mailing in Word. What will be the hourly charge for the Access project? What will be the hourly rate for the Excel and Word project? Thank you

I have a web based app that needs to have components run on a smartphone (with the small screen size). The system is all written with FrontPage and runs on a classic ASP on Microsoft IIS 8.0. The problem is that the screen size, when it is displayed on a smart phone is way, way too small. Although the user can pinch and zoom to make it useful, that is not a viable option. The system needs to displ...

We have a product catalog and we want to put the part #s and product data chart into excel. Budget is $0.05 per product and job complete in 24 hours. See attached catalog and sample record in excel. This will be ongoing work. We have almost 100,000 products total we want to do this for in the next few months. IMPORTANT: DATA must be 100% accurate. Typos or missing data will result in cancellatio...

We are using a excel form today to calculate. But we would like to have it to be webbased function. We would like to have the excel calc function as in the document but also a text field where we can insert text next to the digitits. And when we have used the form to calculate, we would like to email the calculation as a file to an email that we write in. Thanks in advance.

I have an employee schedule in work. I would like to put in hours and get totals in an excel spreadsheet.

Create 2 spreadsheets in Excel. See attached data for each spreadsheet.

Hello, I require an excel expert to work on an existing excel sheet. You must have an excellent knowledge of Excel VBA, Macros and add-ins. The sheet already contains a lot of existing code which has some bugs which need to be fixed. The main part of the project is to create an add-in for mapping. This need to be dynamic. It needs to map the values from cells on one sheet (all cells are named w...