Save this Search
     

All JobsVBA

 56 results  
Sort by:
  • Posted Date
Fixed Price: Less than $500   |  Posted: 2h, 37m ago  |  Ends: 14d, 21h  |   0 Proposals
In this project you need first to install ForexConnect API: Forum Home: FXProgrammers   [obscured]  /wiki/index.php/Download   [obscured]  /fxprogrammers/ latest Forex Connect API download:   [obscured]  /forexconnect/392705-forexconnect-api-subscribe-updates.html #post1368775 FXCM Forex Connect API - downloads for different platforms   [obscured]  /wiki/index.php/Download Download com library ForexConnectAPI-1.3.0-win64.exe if your pc 32 bit or use other file ForexConnectAPI-1.3.0-win64-COM.exe, then use my excel file to log in to demo account. Read in the installation directory, there are many help and samples. You have to create your own demo account for test. Create your demo forex account from here   [obscured]   . This attached excel file is run ok for one demo account. This is not stable run, its disconnected each hour, I want to improve it to work without interruption. This project is aim to improve robustness of this exc...
Category: Management Consulting       

k****377
 [?]
Sign in to view client's details.
| k****377
|    Saudi Arabia
Fixed Price: Less than $500   |  Posted: 6h, 52m ago  |  Ends: 14d, 17h  |   18 Proposals
Hi, I am a marketing PhD student. I have lots of data in excel in the vertical format. I need to convert it into a horizontal format. Although, it is not a simple 'Paste special' operation and require a lot of manual sorting. I am looking for someone who can program a macro to sort it the way I want. I am attaching two excel sheets - one with the original data and the other with the way I want. The original excel file (Buxton Demo Raw) has 4 sheets inside - 0.5 miles, 1 mile, 2 miles and 5 miles. I want all the data in the sheets to be aggregated in one sheet and per the format I have shown in the Buxton Demo file. I have attached both excel files for your reference. I have manually rearranged the data from the original file to the new file but it is taking a lot of time so I am looking for someone who can design a macro for excel for quickly doing it. Time is very important and the earlier I get it done the better.
Category: Database Development       
Skills: Data Entry, VBA, Data Cleansing       

s****ani
 [?]
Sign in to view client's details.
| s****ani
|    United States
Fixed Price: Less than $500   |  Posted: 11h, 52m ago  |  Ends: 14d, 12h  |   14 Proposals
I have an Excel application that I'd like to license out to a few companies. I'd like to have the following features: 1) A function that checks whether the computer is connected to the internet. If it isn't, it closes the worksheet down. 2) Have the application only work on one computer - I don't know what the best unique computer identifier will be...if it's an IP address or whatever you might suggest. If it picks up a different IP address, then it shuts down the worksheet. While I want a unique identifier, I also want to use something that will be easy to find on the computer. 3) Have the application look up the date online and if it is later than an expiry date for the license, it will shut the workbook down. I'd need it to pull from a reliable website that is not going to be changing its url or anything. I don't care about the time zone, within 1 day is fine. I'd be interested to know if there are any other security features i could add to a workbook to make it more secure for...
Category: Software Application       
Skills: Visual Basic       

K****ary
 [?]
Sign in to view client's details.
| K****ary
|    Canada
Fixed Price: Less than $500   |  Posted: Apr 19, 2014  |  Ends: 1d, 6h  |   31 Proposals
I need 2 macros written for Excel. (1) To e-mail the active sheet/tab (with Outlook) to a list of e-mails contained in cells on a different tab. The different tab is named "DistroList" and the e-mails are contained within cells B2:B20. I could also name the range of cells "DistroList" if needed. (2) To e-mail the entire workbook to the same list described above. In short the workbook is a calendar and I want to be able to e-mail each month (when viewing it as the active tab) and the entire workbook to an easily updated list of e-mails on a distribution list within the workbook. I can read Visual Basic pretty well but I've never written a macro from scratch and just need to cut the amount of time/research on how to do this. In other words I can "Speak your lingo" and follow instructions you provide on how to modify the macros you produce if needed and I should be able to troubleshoot and verify the contents of the macro; I also know how to implement t...
Category: Other IT & Programming       

B****the
 [?]
Sign in to view client's details.
| B****the
|    United States
Fixed Price: $1,000 - $5,000   |  Posted: Apr 19, 2014  |  Ends: 12d, 18h  |   36 Proposals
I have an excel file and want it formatted into several different file formats. I would like it done with macros,
Category: Software Application       
Skills: .NET Framework, PHP, VBA       

j****nno
 [?]
Sign in to view client's details.
| j****nno
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Apr 18, 2014  |  Ends: 12d, 9h  |   15 Proposals
I have an inventory receiving spreadsheet which is updated with new receipts data weekly. I need a report run on that data to show how long it takes each item to be received from the original order date.
Category: Financial Reporting       
Skills: Microsoft Excel       

b****vin
 [?]
Sign in to view client's details.
| b****vin
|    United States
Fixed Price: Not Sure   |  Posted: Apr 18, 2014  |  Ends: 12d, 5h  |   21 Proposals
Please see attached file. Code is present but needs your expertise to work. When a value (a date) is added to the 2nd to last open line in column F for each task (i.e., cell F8, F12, F16, etc.), an entire row should be inserted under this line. Contrary, if the date value is removed from any cell in column F within the each task, that same entire line should be automatically deleted...nothing else. That is all.
Category: Other IT & Programming       
Skills: Microsoft Excel, VBA       

E****tin
 [?]
Sign in to view client's details.
| E****tin
|    United States
Fixed Price: $1,000 - $5,000   |  Posted: Apr 18, 2014  |  Ends: 27d, 2h  |   27 Proposals
I want to create an executable that does three things: 1) I have a bunch of standalone macros that I want to package and display as a tab in the MS Excel ribbon. The idea is that if a user clicks on a button within that ribbon; it will execute the associated macro. 2) It should solicit information during the installation process that creates an ODBC connection to the user's sql server and generates a connection string which the macro can use for data tables in excel to be able to link to the database. 3) Is compatible with all versions of MS Excel. Additional details based on questions from proposals: -Yes, this is very similar to creating an excel add-in -If you have capability to enhance the macros I currently have to make them more interactive or efficient, I would be interested in knowing that also -The macros are primarily queries to a sql view or stored procedure and then some formatting. However, if you know how to get the macro to also create pivot tables, graphs, slicers f...
Category: Software Application       
Skills: Microsoft Excel, .NET Framework, PHP, VBA, vbs       

s****tan
 [?]
Sign in to view client's details.
| s****tan
|    United States
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Apr 17, 2014  |  Ends: 11d, 7h  |   4 Proposals
I want to create a prototype of a health decision-making app for patients that I can then show to potential partners. At this point, I have a few PowerPoint slides.
Category: User Experience Design       
Skills: CSS, HTML, VBA       
Preferred Location: North America

J****918
 [?]
Sign in to view client's details.
| J****918
|    United States
Fixed Price: $40 or less   |  Posted: Apr 17, 2014  |  Ends: 11d, 6h  |   18 Proposals
I have a Microsoft Excel spreadsheet wich I use to calculate freight. A Macro was developed to send parameters as weight and volume to a webservice of a freight company and as a result we become the freight cost. The Macro works very well with Windows 7 / Microsoft Office 2007 When we tried to use the same macro with Windows 8, it didnīt work Now we must adequate so It can work with Windows 8.1 and Excel 2007 When trying to run the Macro, the problem seems to be at "Dim Req As New XMLHTTP" The excel sheet with the code is attached.
Category: Other IT & Programming       
Skills: Microsoft Excel, PHP, VBA, Visual Basic       

p****tao
 [?]
Sign in to view client's details.
| p****tao
|    Brazil
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Apr 17, 2014  |  Ends: 10d, 20h  |   17 Proposals
Need the vba code for a baseball game simulation model using Monte Carlo simulation. Rules/logic and a dummy data set can be provided but I cannot write the loops and if statements.
Category: Data Analysis       
Skills: Microsoft Excel, VBA       

F****s85
 [?]
Sign in to view client's details.
| F****s85
|    United States
Fixed Price: $1,000 - $5,000   |  Posted: Apr 16, 2014  |  Ends: 25d, 16h  |   13 Proposals
Seeking a strategic analyst to assist in performing research on lottery, gaming, casino markets in Asia and also assisting in modifying (adding sheets, cells and VBA coding) of excel spreadsheets for a publicly listed company. Must be an effective researcher with excellent written English skills and VBA expertise.
Category: Investment Analysis       

R****ise
 [?]
Sign in to view client's details.
| R****ise
|    Australia
Hourly Rate: $30 - $40 / hr   |  Duration: Not Sure  |  Posted: Apr 16, 2014  |  Ends: 10d, 9h  |   3 Proposals
I would like 2 different fonts loaded into an AutoCAD file for the purpose of sending the file to a manufacturer so they may load it into their laser cutter. I would like the job done as soon as possible, as the manufacturer is waiting for this. Thank you.
Category: Other IT & Programming       
Skills: AutoCAD, .NET Framework, PHP, VBA, Auditing       

m****lfe
 [?]
Sign in to view client's details.
| m****lfe
|    Canada
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Apr 16, 2014  |  Ends: 10d, 8h  |   38 Proposals
I have a spreadsheet for entering in customer information when they call. I'd like to make the data input easier by adding a simple form that would feed the spreadsheet. Please look at the attached spreadsheet and let me know if you would be able to add a professional form to easily capture the data keyed in to the first tab. I'd like to use as many drop downs as possible to reduce keying. This project would be recurring whenever new fields were added or if I want to change drop down menus.
Category: User Experience Design       
Skills: Microsoft Excel, VBA       

Q****tal
 [?]
Sign in to view client's details.
| Q****tal
|    United States
Fixed Price: Not Sure   |  Posted: Apr 16, 2014  |  Ends: 10d, 0h  |   16 Proposals
I am looking to create a programme using VBA that allows my dashboard to dynamically auto-scale my charts. We use many different types of charts (bar, line etc) and link this to a Microsoft SQL database. This screens for hundreds of stocks with various values, therefore we need code that allows this to auto-scale in a seamless fashion.
Category: Other IT & Programming       
Skills: Microsoft Excel, VBA       

W****oos
 [?]
Sign in to view client's details.
| W****oos
|    United Kingdom
Hourly Rate: Not Sure   |  Duration: 1-2 weeks  |  Posted: Apr 16, 2014  |  Ends: 9d, 22h  |   16 Proposals
Hello, I need help to build VBA code in excel (or something equal to that). This should be a simple project for a person who is good in VBA. Im building a model of the price development in the apartment market in the Swedish capital Stockholm.So what I need you to do is to go to this homepage (its in swedish but i'll guide you)   [obscured]  /salda/resultat From that homepage I want you to collect certain data. I need the date for when the apartment is sold (the first column) and the end final price (the big orange text) and also which part of the city it was located in (can be found in small text in 3rd column) and also how many rooms the apartment is (can be found in the 3rd colum top right corner.. example "2 rum"). I want you to build a excel spreedsheet with a button that I just can click so it collects all the data. I want the data sorted in a good and nice way so I can work with it easy. Write me how many hours you need and your cost for this project (fixed...
Category: Data Engineering       
Skills: VBA       

E****les
 [?]
Sign in to view client's details.
| E****les
|    Sweden
Fixed Price: Not Sure   |  Posted: Apr 16, 2014  |  Ends: 9d, 20h  |   20 Proposals
Need help with the development of this Database on a ongoing basis Must be experienced and know VBA and SQL. You will liaison with me personally with given jobs to complete. Will pay for jobs done and progress on a ongoing basis. Need to get this working ASAP.
Category: Database Development       

p****007
 [?]
Sign in to view client's details.
| p****007
|    Australia
Fixed Price: Less than $500   |  Posted: Apr 16, 2014  |  Ends: 9d, 20h  |   2 Proposals
We need to convert an Excel VBA custom add-in into a Google apps script add-in. This add-in basically enables the staff to manipulate files in mass in a Windows environment from any excel spreadsheet: 1. List filenames of files stored in a folder. 2. Copy files from a folder to another. 3. Copy and rename files from a folder to another. We are looking for an experienced Google apps script developer (javascript) able to understand VBA. Ideally you are working in an agile framework. Depending on the outcomes, this small project might turn into long term relationship as we have many other programs to convert. Our requirements and the excel add-in are located the following link   [obscured]  /pJ2InB. If you think you have the right skills and experience, please do not hesitate to contact us!
Category: Other IT & Programming       
Skills: Javascript, Visual Basic, google apps script       

t****t12
 [?]
Sign in to view client's details.
| t****t12
|    Australia
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Apr 16, 2014  |  Ends: 9d, 18h  |   11 Proposals
Hi There, need to get conditional formatting work with current date Example : first deadline >= today() then color should be green second deadline < today() and third deadline > today() then color should be yellow likewise for another two conditions. Only want to work with xsltlistview Please suggest the time it could take
Category: Software Application       
Skills: Microsoft Sharepoint, .NET Framework, PHP, VBA       

m****hir
 [?]
Sign in to view client's details.
| m****hir
|    Canada
Hourly Rate: Not Sure   |  Duration: Not Sure  |  Posted: Apr 15, 2014  |  Ends: 9d, 9h  |   24 Proposals
We are looking for someone to help our sales agency run monthly sales reports in Excel or VBA. We pull sales data from large retail chains and from our distributors on several different brands, some only have 1-2 products but many have up to 80 products. It will require about 30 - 40 hours the first week of every month, so it is a recurring job that could lead to more work. We have developed the database and reporting format already but need someone who can follow the formulas, enter the data and run the reports. You will need at least 8GB of RAM and ideally a solid state drive. Below are links to dropbox files that will show you what we are looking for: 1.)   [obscured]  /1p7OqC7 - File with brief instructions and login info. 2.)   [obscured]  /1h0PLAt 3.)   [obscured]  /1l4927Y 4.)   [obscured]  /1l49aV4
Category: Data Analysis       

g****ng3
 [?]
Sign in to view client's details.
| g****ng3
|    United States
Hourly Rate: Not Sure   |  Duration: 1-2 weeks  |  Posted: Apr 15, 2014  |  Ends: 9d, 3h  |   9 Proposals
Need the calculation behind a continuous variance-covariance in VBA, can do it Excel. Having difficulties programming it into Visual Basics.
Category: Other IT & Programming       
Skills: VBA       

J****811
 [?]
Sign in to view client's details.
| J****811
|    United Kingdom
Hourly Rate: $15 - $20 / hr   |  Duration: 1-3 months  |  Posted: Apr 15, 2014  |  Ends: 9d, 2h  |   10 Proposals
We build games for trainers in PowerPoint. Searching for a PowerPoint VBA programmer to work on occasional but fairly consistent projects as our needs arise (  [obscured]  -games.com)
Category: Software Application       
Skills: VBA       

t****mes
 [?]
Sign in to view client's details.
| t****mes
|    United States
Hourly Rate: Not Sure   |  Duration: 3-4 weeks  |  Posted: Apr 14, 2014  |  Ends: 8d, 8h  |   2 Proposals
Starting with an existing script that takes actuals hours worked from a timesheet database and posts the actuals to MS project. Redesign and or rework the script to perform more automation. We will discuss details. Job Description: We are looking for a talented Visual Basic for Applications Developer who will be responsible for the design, development and deployment of certain macros to assist in automating certain project management functions. Your responsibilities: - Review and perform a technical analysis of requirements - Produce a solid, detailed technical design - Write clean, modular, robust code to implement the desired requirements - Contribute ideas for making the application(s) better and easier to use Your qualifications: - A work style that is extremely detail oriented - A complete Elance profile - References or an established Elance reputation preferred - Working knowledge of the latest release of MS Excel and MS Project - Working knowledge of the lates...
Category: Mobile Applications       
Preferred Location: United States

b****ett
 [?]
Sign in to view client's details.
| b****ett
|    United States
Fixed Price: Not Sure   |  Posted: Apr 14, 2014  |  Ends: 7d, 20h  |   7 Proposals
We have an Excel macro file that needs to work for PC and MAC. It gives an error on MAC - We'll need to transfer vba code fom macro to apple scripting language for Excel.
Category: Data Engineering       

t****ory
 [?]
Sign in to view client's details.
| t****ory *
|    United States
Symbol Key
Payment method not yet verified
Payment verified
Purchased $1-$500
Purchased $500-$5,000
Purchased more than $5,000
You have already submitted a
proposal to this job