Get a Freelance Job

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.

I am looking for someone to write 1-2 Excel related tutorials per month. Each tutorial will need to be 50-250 words depending on the complexity. All tutorials will be written using WordPress. Each tutorial will also need to be unique.

Sample Topics:
Excel VBA – Requested
Excel 2010
Access 2010

This is an on going job. I’m looking to pay $5 USD per tutorial.

If you have any questions, please ask.

In short: I need Visual Basic for Access code to use in ms access application, that will do 3 things:

- optimize (resize) images and save them in specific folder (path to do images for optimization is in tblImages)

- generate XML file from defined query

- synchronize XML file and images from local to the web server.

I wrote detailed description of work that should be done (attached), however, Im open to discuss any other solution that you could provide.

I need someone who can repair an error in my software, I have the original vb code I need you to make the software function properly.

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 …

Develop a Macro that will look at a CSV file in Excel and do the following:
1. The user will select cells of text in a column , (ex. D2- D420)
2. The Macros will search for a key word, phrase, or series of key words in selected cells
3. If the keyword, phrase, or series of key words is found in the text selection, the Macro assigns a category (ex. “positive”) and writes that category in a new cell in the same row where the search was successful. (ex. writes “positive” in cells J2 – J420).
- …

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

VBA Assignment for Excel 2007/2010.
Must be done today. PM me for details.
No Escrow.
Thanks
dkjain01

In need a vba script I can run in Powerpoint to indentify where an object is embedded in the powerpoint and the name of the object.

I need an excel macro that I can add into our excel spreadsheet which will automatically do the following:

1. It will replace anything in the spreadsheet that is bold with the html equivalent ()

2. It will replace anything in the spreadsheet that is underlined with the html equivalent ()

3. It will replace anything in the spreadsheet that is in italic with the html equivalent ()

4. After doing the above it will auto…

Please check this website to see the project (Use of VB and VBA)

http://imz371.ust.hk/isom3230/assignment.html

There are two projects, I need to do the Project 2 ((!):not assignment 1 part 2, but Assignment 2)

The project is needed for the 30th of November and if possible preferably before.

PS: In case you need supporting information about VB-VBA, there are a few courses on the “Lectures” part of the website.

Please check this website to see the project (Use of VB and VBA)

http://imz371.ust.hk/isom3230/assignment.html

There are two projects, I need to do the Project 1 part 1 & 2.
The project is needed for the 17th of of November at latest (preferably before).

PS: In case you need supporting information about VB-VBA, there are a few courses on the “Lectures” part of the website.

VBA Specialist needed. Attached is a document which details the project to be completed. We also have a part-completed .xlsm file which we cannot post due to some client sensitive details, but which we will share with any serious bidders which we choose.
Thanks.

VBA Specialist needed. Attached is a document which details the project to be completed. We also have a part-completed .xlsm file which we cannot post due to some client sensitive details, but which we will share with any serious bidders which we choose.
Thanks.

Hi,
I am looking for a skilled excel vba macro programmer.
Its a very simple task of transfering matching data and just creating some calculations on that data. There are a few sheets in the workbook, but its the same data as such and same calculations.
So you will need to transfer the data from one sheet depending if it matched the name and date from the row in another sheet in that workbook and then perform calculations.
This is a small project and budget, but the selected programmer has the opportunity to work more on other projects on this workbook.

I am attaching a spell checker designed to be used with MS Access. This is a free offering from the author, so you aren’t violating any copywright, etc.

The spell checker currently checks the field with the focus. I need for it to check multiple fields on a form without having to confirm the “Spell Check is complete” after each field.

It should put the focus on the first field, spell check it and then move the focus to the second field and spell check it, etc. The “Spell Check is Complete” message should only appear after the form has been checked.

The field names that will be checked are Field78, Field80, Comments,PrivateComment.

- Basic VBA program to be create via MS Excel
- Test Data provided (attached)
- Project Specification and Requirements attached
- Please read and check attachment before contact

We are looking for an expert in Microsoft Office 2010, here especially in the creation of templates. We do have various templates (Word/Powerpoint) which need to be reviewed, enhanced and migrated to office 2010. We would also implement some VBA Macros in Word to update status information, etc.

We would start with one template and if we are happy will continue step by step with more.

We are also looking for someone with experience at other clients who can consult us in the usage of Office 2010 templates, enhance features, etc.

Please show us examples of your work. and only apply if you are an advanced Microsoft Office 2010 user.

- Basic VBA program to be create via MS Excel
- Test Data provided (attached)
- Project Specification and Requirements attached
- Please read and check attachment before contact

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.

I have a large booklet / Disclosure that I need to email to clients on occasion after some minor customizing.

I would like an MS Word VBA solution to add a little customization. Other solutions I may be open to including a VB single purpose program or a .pdf solution. I do not have a full Adobe Acrobat program though. I just have Adobe Reader.

It should pop up a user form (which I provided a screen shot sample for lay out) I will enter a few pieces of information and click one of two buttons. The first button is Merge – which shall transfer the data from the input box to all the footers on all 80 pages and also add a few of these pieces of data onto the title page. At this point I can see it is done right and save through the normal MS Word interface as a “Save As” if I need to save.

The Second Button is “Merge and Email in PDF”. When I click this button it will merge like previously stated and also open my default mail client into a new message window. It will add this created form as an attachment and label it using the Address field (if selected) from the User Form and the name of the document. Example “Combined Hazard Booklet – 1234 Main Street.pdf” also it will Copy the last page of the document which is the receipt into a second attachment labeled as “SIGN & RETURN – Receipt – Combined Hazard Booklet for 1234 Main Street.pdf”.

The VBA code shall be unlocked and viewable by me. This is for my personal use and not for resell. The VBA code shall be commented on nicely so I can make some changes and follow along.

When the .PDF forms are created I want them locked down to avoid editing completely. I generally only want them to have the ability to view and print. No editing or removing data. I believe there are user codes to lock this down.

There shall be a sub form with the ability to set defaults. (I have designed a snapshop of what I am looking for) The VBA Code shall have a place for me to input the proper pass code information, pdf security settings and other items related to email.

So to re-summarize I want my steps to be minimum to just opening the word template have the input box open automatically > I add some quick information > click the merge and email button > Have it open the client insert the two documents and add subject line text and the body text.

After it does all this I will use the email client to send the document. I just want it to get to the point that I just need to add an email address and send.

Finally, I am flexible on the solution but I need to make sure that if using MS Word then all issue with Widows and Orphans need to be resolved to avoid ugly print outs. My .pdf is exactly how I want it to look page by page but with the customization in the footer and title page.

I will provide you a .pdf of the document to review upon request it is 79 pages and 4mb in size

I have attached screen shot of the current header and the change to the title page for you to review. I have also added a screenshot of the user form and sub user form I have made up as an example

We need two Excel VBA files, each of which creates a batch file, runs the batch file and then deletes the batch file after the batch file has completed its run.

Batch file #1 uses the inputs (source directory, destination directory), goes through each and every CSV file within the source directory, removes the last carriage return of each CSV file and then overwrites the new CSV file to the destination directory.

Batch file #2 uses the inputs (source directory, destination directory, latestdata.csv directory), goes through each and every CSV file within the source directory, removes the last carriage return of each CSV file, retrieves the latest data from latestdata.csv (if the data is there), appends the data to the CSV file and then overwrites the new CSV file to the destination directory.

Since there are a lot of CSV 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.

I have an access databse that was working until I changed the email from address. I got a vba error and it hasnt worked since.

I have attached the database for review. The form is the
BoydCustomerEmailsToSend
Form loads the old email from address, which needs changed to the email address in the cc field.

To see the error, load the form, click select all, then bottom left, click here to send emails. It’ll error on you.

Should be a quick fix if you know what you are doing.

I have an access databse that was working until I changed the email from address. I got a vba error and it hasnt worked since.

I have attached the database for review. The form is the
BoydCustomerEmailsToSend
Form loads the old email from address, which needs changed to the email address in the cc field.

To see the error, load the form, click select all, then bottom left, click here to send emails. It’ll error on you.

Should be a quick fix if you know what you are doing.

I need a simple one page data scrapper written in MS Access – VBA.

The source is
http://www.state.nj.us/lottery/instant/2-0_instant_games.shtml.
Only for the Active Games Tab.

Required is a data table of all active Games Info Data which is available on this Page.

Any easy approach or suggestion is also Welcomed.

I have an access databse that was working until I changed the email from address. I got a vba error and it hasnt worked since.

I have attached the database for review. The form is the
BoydCustomerEmailsToSend
Form loads the old email from address, which needs changed to the email address in the cc field.

To see the error, load the form, click select all, then bottom left, click here to send emails. It’ll error on you.

Should be a quick fix if you know what you are doing.

Apologies all, the client wants to go back to this original spec.

I need a script to allow users to detach attachments from emails to prevent the Exchange server getting bloated.

Nicola Delfino has a VBA script that is nearly working, but if there are multiple attachments it fails. The script is here:
http://blogs.msdn.com/b/nicold/archive/2009/10/22/how-to-remove-attachments-from-outlook-2007-emails-easily.aspx

As per his script, I would like the email to have the detached file names inserted in the body. However, it would be beneficial to allow the user to choose where each file is saved to.

Convert large MS Access database to Java. This project consists of 300 plus forms and 250 plus reports. significant VBA and SQL (mostly in the forms). Must have a minimum of 5 years experience with MS Access and 5 years experience with Java. This will be a desktop solution.

I am looking for a candidate who has specific experience in this type of project. Initial estimation would be 200,000 – 250,000 lines of Java code so you would need to utilize conversion software.

The program will have a very large user base and has a strong possibility for long term position after successful completion.

Time Frame
This project is time sensitive

Payment
Payment will be based on percentage of job completion with a 5% deposit.

I have an excel spreadsheet that enables us to produce quotes based upon various criteria and data. It works reasonably well but I wanted to make it more sophisticated, so I had a VBA expert develop it using VBA. Unfortunately first one programmer gave up doing programming and then the next was taken sick. I would now like to find someone who could pick up the pieces and finish the job. Once it is finished I would then want to do some further work using a combination of excel and VBA.

One of the fundamental things that the VBA programmer did, I believe, was to incorporate a link to our Sage Act database, so that customer names and addresses and other data could be ‘grabbed’ by the system.

If Excel/VBA does not suit you I am open to suggestions as to better ways to go about it.

The first step would be get a handle on how my ‘simple’ quoter system works and then how the VBA version works. Then it would be a matter of trying to incorporate some enhancements that my team wish to add and also to break it all down so that it is entirely driven by parameters.

Please take a look at the files attached and let me know what you can do and also provide me with information about your skills and experience at handling such a task.

I need a script to allow users to detach and remove attachments from emails to prevent the Exchange server getting bloated.

Nicola Delfino has a VBA script that is nearly working, but if there are multiple attachments it fails. The script is here:
http://blogs.msdn.com/b/nicold/archive/2009/10/22/how-to-remove-attachments-from-outlook-2007-emails-easily.aspx

As per his script, I would like the email to have the detached file name paths and date detached, inserted in the body of the message. However, I would like to allow the user to choose where each file is saved to, with an option to skip if required. Skipping the file should remove it and stamp the body as removed. It should also prompt with the last saved location to save time when saving to long paths.

Script must work on Office 2003, 2007 & 2010

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.

Hello all,

I’m looking for a simple solution in an excel file to add buttons wich auto increment the value of a field by +1
This is to keep scores of a soccer game.

I need to have a button for every player in my team.
When he scores a goal. I want to push the button next to the players name. and see the scores in each column.
So per user I need a button wich auto increments the value of the field by 1

I’ll send the xls file in attachment so you can see the lay-out of the xls file.

Basic Tasks:
-Add security to an Excel model (written in VBA) above what VBA & password protection can provide
-Add licensing mechanism & connection to a web resource that complements the model

Overview:
We have a functioning excel model that we want to distribute freely while protecting its coding and database. We want to pair the model with a very simple web resource, but restrict access to the resource through license purchasing and expiration.

Details:
Have a look at the attached PDF for details.

* MUST BE COMPLETED WITHIN 3 HOURS OF ME ACCEPTING YOUR BID *

I have a spreadsheet (see attached) that contains several quick questions/tasks involving both formulas and macros.

Please note that this quick assignment is highly urgent and MUST be completed WITHIN 3 HOURS of me accepting your bid.

Please only bid if:

- You have viewed ALL 7 tasks in the attached spreadsheet and you can complete ALL of them correctly (question 7 will take the longest).

- You understand that you must return the completed spreadsheet within 3 hours of me accepting your bid.

Once I have verified that all questions have been answered correctly, I will release the milestone.

Only low bids will be accepted.

The successful bidder will also be offered ongoing work upon completion.

This should be a relatively simple project for anyone with VBA experience. Given a Word document, extract blocks of text (always beginning with WORD1 and ending with WORD2) and send them to a table in Access.

The code will need to be run again in 6 months, with a new word document, but appending the results to the existing Access file (so it may be helpful to prompt the user for the specific word and access files to use)

See attached word file. I need extracted to Access: CASE NAME, PRIOR HISTORY, DISPOSITION, CASE SUMMARY, PROCEDURAL POSTURE, OVERVIEW, OUTCOME, & CORE TERMS (bonus points if each of the core terms are easily query-able)

I have a data processing program that exports ascii files similar to the attached. I need a VBA program in Excel that will allow me to select multiple files of this type, and import them into an excel workbook. Each file would need to be delimited into a separate worksheet in the workbook, with the worksheet name changed to the ascii file name.

Notice in the ascii file that the depth values are negative at the beginning of the file. I would like these negative values to be deleted from the file at some point, as well as the first 10 records following the first positive depth value (this is when the instrument is coming to equilibrium and these data are meaningless).

Next, I would like the column headers to be changed to something a bit easier to understand for the end users. While 95% of the time the column headers will be the same as in the example file, there may be instances where some of these do not appear and/or additional ones are added (depending on the equipment used). I’d be satisfied if these nine headers were changed as follows:
DepSM

I require a vba macro that opens up a new xls spreadsheet for each instance the macro is run and runs a set of rules off an open xls spreadsheet and puts the resulting data into the new spreadsheet.
You will be required to know how to count font colours and cell colours. As well as implementing the set of rules I give you. Many are simple rules for example finding a cell with

I need a script to allow users to detach attachments from emails to prevent the Exchange server getting bloated.

Nicola Delfino has a VBA script that is nearly working, but if there are multiple attachments it fails. The script is here:
http://blogs.msdn.com/b/nicold/archive/2009/10/22/how-to-remove-attachments-from-outlook-2007-emails-easily.aspx

As per his script, I would like the email to have the detached file names inserted in the body. However, it would be beneficial to allow the user to choose where each file is saved to.

BASIC INFORMATION
Summary
1) Access 2010 user interface
2) Rework forms and tables
3) Mail merge functionality

Requirements
- Must have ACCESS 2010 experience
- Fluent English
- Fast internet

We are company that processes CDR reports from stores. We receive reports from various stores. Each of these contains a series of records detailing the amount of sales that store has made within a period. Each of the online stores sends us their reports in a different format, we call these