Project Detail

Update VBA Code in Excel Workbooks

Update VBA Code in Excel Workbooks is project number 280298
posted at GetAFreelancer.com. Click here to post your own project.

Status: Closed
(Selected Service Provider)

Selected Providers: JustPlainBill

Budget: $30-250

Created: 06/28/2008 at 9:54 EDT

Bid Count: 15

Average Bid: $ 138

07/12/2008 at 9:54 EDT

Project Creator: busperf
Employer Rating: (No Feedback Yet)

Description

I developed two commercial excel spreadsheets with VBA in Excel 97 in 2003. I want to extend the product life of these two spreadsheets.

Tasks include:

1. testing spreadsheets (2 crippled samples and three fully working versions) in Excel 2002, 2003 and 2007

2. updating/enhancing VBA code for improved efficiency and reliability

3. fixing know bugs and issues (see below)

KNOWN BUGS AND ISSUES

Project Master - Regular Version and UK Version
On Schedule sheet with data filtered, inserting a new task deletes current task selected.

ProjectMasterSample and ProjectMasterUKSample
With Win2000 and Excel 2000 - closing workbook on most sheets generates Program Error. Commenting out Iterations = False fixes problem.

Project Master - Regular Version (customer in Spain)
With Office 2003 and Win XP Service Pack 2, VB runtime error 9 on opening workbook.

Training Tracker Template and Training Tracker Sample
If user leaves empty cell in list on List sheet, Records sheet accepts any value in respective field, rendering data validation for that field impotent.

Training Tracker Template and Training Tracker Sample
User can select a data column on Records sheet and delete contents, including field label (column heading). This creates blank Pivot Tables and Charts.

Training Tracker Template
For some users, pivot tables become corrupted or become inactive data. This may be due to Excel and not VBA code.

Training Tracker Template and Training Tracker Sample
In Excel 2003, Excel reports errors on opening workbook.

I will supply the User Guides and the Technical Manual for developers.

Please only bid if you are highly experienced in VBA.

Additional files submitted:
ProjectMasterTemplate.xls

Report Violation

Job Type

Messages Posted: 2

If you are the project creator or one of the bidders Log In for more options

PMB

200

3 days

06-28-2008 10:11 EDT

9.88/10 9.88/10 9.88/10 9.88/10 9.88/10 9.88/10 9.88/10 9.88/10 9.88/10 9.88/10
(152 reviews)

Hello,Please refer your PMB.Thank you.

crajeshbe

100

5 days

06-29-2008 09:02 EDT

10.00/10
(38 reviews)

Excel Guru Bid. Having 3+ years of Experience in Excel addin Developement. Ready To Start. Regards C.Rajesh B.E

tusharvv

180

5 days

06-28-2008 13:29 EDT

10.00/10
(9 reviews)

Reviewed description as well as .xls files. Can be done. Please refer to PM.

azrajobs

180

2 days

06-28-2008 14:51 EDT

9.60/10 9.60/10 9.60/10 9.60/10 9.60/10 9.60/10 9.60/10 9.60/10 9.60/10 9.60/10
(5 reviews)

plz view pm for demo

cheungkc

150

7 days

06-28-2008 22:41 EDT

10.00/10
(5 reviews)

Hi Insert Delete function appears working in Schedule sheet; Closing workbook & Opening workbook (Excel 2003) no error encountered; Tracker template and sample not available.Can we view them please? Codes well documented. Regards PY & Associates

antony123

145

5 days

06-28-2008 14:18 EDT

9.00/10 9.00/10 9.00/10 9.00/10 9.00/10 9.00/10 9.00/10 9.00/10 9.00/10 9.00/10
(7 reviews)

I can offer this

sivanvega

145

3 days

06-28-2008 15:13 EDT

9.00/10 9.00/10 9.00/10 9.00/10 9.00/10 9.00/10 9.00/10 9.00/10 9.00/10 9.00/10
(2 reviews)

VBA Excel Expert. Hi Sir, I'm ready to start today.

JustPlainBill

200

5 days

06-28-2008 12:40 EDT

(No Feedback Yet)

Hello Busperf, Please see the PM for details. Thank you.Bill

realc

110

3 days

06-29-2008 04:16 EDT

(No Feedback Yet)

Hi.I can fix these problem.Please check PM. thank you!

amsh

120

8 days

06-28-2008 23:08 EDT

(No Feedback Yet)

Hi, I am having 3.7 years of experience in Software Industry in following domain: Testing Debugging Developement Database Analysis and Design Knowledge of Technologies Java, VB, Oracle PL-SQL,SQL perl,Shell,sunsolaris 5.2. I have worked on Defect fixing in C#,Pl-SQL, Java. I am interested in your proposal. kindly provide few more details about the task so that I can have clear understanding of your business domain and where this applications fits in this domain so that we can think of alternative optimal solutions. Please share the details and then I will send you the schedule timeliness. I am looking for long-term relationship with client. Recently completed the Application to application data sending using skype and Call Handling through Skype in Access(VBA). Please check the odesk history(http://www.odesk.com/users/~~220aedf2f2a9fe3f). The work is appreciated by the client as the technology was new to me and the work delivered to the client was with high quality and before time and with pro-active communication. Waiting for your kind feedback. I am willing to explore new technology and new challenges. Please feel free to ask any questions. I am available for part time. With Regards, Techsolution2008

erpurohit

5 days

06-29-2008 08:59 EDT

(No Feedback Yet)

I am working as a VBA programmer in one of the fortune 500 company.

sarojsharma1

3 days

06-29-2008 12:09 EDT

(No Feedback Yet)

Excellent knowledge in VBA MAcro and having 3 years of experience.

nilaymalda

7 days

06-29-2008 05:36 EDT

(No Feedback Yet)

Sir, My name is Nilay Sarkar.I am a student of Computer Science Final year. I have no experience but I have the ability to perform your task. Please give me a chance.

pgppra

150

2 days

06-30-2008 04:42 EDT

(No Feedback Yet)

Have good Experience in this.

Tiybhu

160

15 days

06-30-2008 08:02 EDT

(No Feedback Yet)

i hv done many wrk like this and i hv the lot of experiance in that particular wrk. i will do ur wrk as ur wish and ur requrement...........

Bid on this Project

WHAT IS GETAFREELANCER.COM?

Get A Freelancer is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!

We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started! Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.