Archive

Posts Tagged ‘excel vba’

Excel Vba Tutorials

February 3rd, 2012 Comments off

Excel VBA Tutorial’s

In need of a talented person to write two professional VBA Microsoft Excel 2010 tutorials. The tutorial’s will need to contain step by step instructions. Please only bid if you are serious and actually know Excel VBA.

Topics:

Basic behind a Macro
Explain Macro Editor

The tutorials needs to be unique as well.

Excel Vba To Html

January 7th, 2012 Comments off

We would like to create a VBA macro that converts several Excel tables to a HTML file using the filename located in one cell in the same Excel spreadsheet.

Then each newly created HTML page needs to be opened and the , , , and tags replaced with content located within cells in the same Excel spreadsheet. Also, unnecessary tags/lines must be removed (e.g. a few meta-tags, comments, etc.)

Please quote your best price and estimated time of …

Excel Vba / Macro Programmer Required

December 4th, 2011 Comments off

Hi,

I have a small project for someone who has Excel VBA / Macro skills.

I just need the macro to pickup an extra sheet when it is caluclating data. Currently it runs through 5 sheets, just need to add an extra one on.

I look forward to your bids.

Kind Regards

Chris M

Excel Vba To Ftp Files

October 7th, 2011 Comments off

We need a macro (Excel VBA) that takes all files from a source directory and quickly FTPs (preferably SFTP) all those files to a destination directory (on our server). The variables (source directory, host, destination/remote directory, username, password) would be hardcoded directly into the VBA script itself. We would also want the option to ignore subfolders as well as the option to only upload files of a particular extension (e.g. .htm, .csv, etc.)

Since there are a lot of files, speed is critical.

If you require more details, simply inquire via the PMB. Please make a quote and let us know when you can start.

Excel Challenge

August 14th, 2011 Comments off

I am looking for an excel vba master,someone that is ready for a very challenging project.
I have give all project details in the attached so only bidders interested in testing their excel vba knowledge to bid on this.
What i would like for bidders to read and study the attached before they put forward any bid.Please don’t bid if you can’t 100% complete this project.
Any interesting idea’s or better ways to complete this is very much welcomed.
So if you are interested in a different type of excel project then
please put in your bid.

Excel Vba Test Change Form

January 5th, 2010 Comments off

Need Excel vba script written to test and see if changes have been made on a user form and change a command button on the user form to state a change has happened. On someof the userforms I have as many as 120 text boxes and some I have a combination of text boxes and comboboxes.

Excel Vba

October 13th, 2009 Comments off

I made an Excel VBA code, but it works a bit slow. Is it possible to optimize it and make the calculations faster?

Excel/vba Web Queries

September 8th, 2009 Comments off

We are looking for experienced Excel/VBA Web Queries Programmers for a project. The scope of the project will be as follows :

1. Base on a list of given symbols, extract and export data from a
URL into excel spreadsheet.

2. Add in a few columns in the excel spreadsheet with same
conditional values.

3. Base on a list of given symbols and date range, extract and
export data from a URL into a second excel spreadsheet.

I will either require A macro to store the source code of your programming or whichever means you see deems fit.

This should be a simple project if you know Excel/VBA programming and Web Query.

Thank you,
Leslie

Excel Vba

June 1st, 2009 Comments off

Good Afternoon!

I have a Java program with source code. It’s a ballistic program, that means, You can calculate the bullet trajectory, wind drift, and spin drift too. Is it possible to make an Excel macro from this Java source code?

I attached the source code, please check it!

Thank You for the help!

Regards,
Chris

Excel Vba Add On

April 28th, 2009 Comments off

I am looking to build an excel add on for MS Excel 2007 and 2003 version.

This add on should

1. Be able to query & fetch data via API from Google

2. Be able to let users interact and select data that they would want to be extracted into Excel

3. Should have a nice html user interface where user can select the datablocks that users would like to see

4. Users should be able to edit the data that they have already extracted.

5. It should not take up lot of memory of users computers

6. It should allow login into Google Account via credentials provided by users.

I should be able to provide designs once I select the buyer.

Excel Vba Check/correct

April 24th, 2009 Comments off

Hi i am in need of a Excel Guru to check my Excel VBA programming and make any necessary changes. I will also need this person to suggest proper graphs for my data that i have collected.

Excel Vba Modification + Fix

April 21st, 2009 Comments off

I need to get VBA functions executed based on cell change in different workbook.
There should be some values taken from the originating workbook and the VBA function will use that.

Further, when running the VBA function with some specific values the Excel crash completely.
I need to have this fixed also.

Please download the screenshots explaining the problem. Spreadsheets and specific details via PM. The zip file contains 9 screenshots with explanations.

http://rapidshare.com/files/223691739/Excel_screenshots.zip.html

There are only few lines of code needed. It’s 1 hour job for an expert. All the functions are created already by professional company. I prefer experienced Excel VBA programmer.

I need the VBA code to work fast, efficiently and permanently. I do not want any slow copy and paste function or macro.

Thank you.

Excel Vba Pivot Table

April 5th, 2009 Comments off

Hello
I need a user form in Excel which allows searching and selecting Pivot Items of Pivot Field in Pivot Table.

I posted this before. I have the macro that does almost all I need (one in excel 2003 and another in excel 2007), but have some problems that need to be solved and a little change in Excel 2007 version.
It has been developed with msflxgrd.ocx and msdatagrd.ocx controls, but windows update (KB960715) is causing me problems with those ocx.
If I uninstall that update, this works fine in xp but is not working in 2003 server (don

Bear