I gang

Update VBA Code in Excel Workbooks

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.

Færdigheder: Excel, Visual Basic

Se mere: update vba excel, update vba, vba update vba code, excel update vba, excel update vba code, update vba code vba, update closed workbook sheet using excel vba, vba update excel worksheet opening, update vba code, vba excel workbook update, update column excel, vba code samples, vba excel update column, excel code bid, excel scheduling job coding, manual update workbook excel vba, update excel sheet code, excel workbook update project, update code excel vba, vba update excel, updating vba code vba, vba with, vba developers, update tracker, testing iterations

Om arbejdsgiveren:
( 3 bedømmelser ) Melbourne, Australia

Projekt-ID: #280298

Tildelt til:

JustPlainBill

Hello Busperf, Please see the PM for details. Thank [url removed, login to view]

$200 USD in 5 dage
(12 bedømmelser)
3.2

15 freelancere byder i gennemsnit $138 for dette job

MAnkita

Hello,Please refer your [url removed, login to view] you.

$200 USD in 3 dage
(76 bedømmelser)
6.1
crajeshbe

Excel Guru Bid. Having 3+ years of Experience in Excel addin Developement. Ready To Start. Regards [url removed, login to view] B.E

$100 USD in 5 dage
(8 bedømmelser)
4.1
refractocd

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

$180 USD in 5 dage
(14 bedømmelser)
4.0
azrajobs

plz view pm for demo

$180 USD in 2 dage
(26 bedømmelser)
4.0
cheungkc

Hi Insert Delete function appears working in Schedule sheet; Closing workbook & Opening workbook (Excel 2003) no error encountered; Tracker template and sample not [url removed, login to view] we view them please? Codes well Mere

$150 USD in 7 dage
(7 bedømmelser)
3.0
amsh

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,su Mere

$120 USD in 8 dage
(2 bedømmelser)
1.6
sivanvega

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

$145 USD in 3 dage
(0 bedømmelser)
0.0
antony123

I can offer this

$145 USD in 5 dage
(0 bedømmelser)
0.0
realc

Hi.I can fix these [url removed, login to view] check PM. thank you!

$110 USD in 3 dage
(0 bedømmelser)
0.0
erpurohit

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

$69 USD in 5 dage
(0 bedømmelser)
0.0
sarojsharma1

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

$90 USD in 3 dage
(0 bedømmelser)
0.0
nilaymalda

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.

$70 USD in 7 dage
(0 bedømmelser)
0.0
pgppra

Have good Experience in this.

$150 USD in 2 dage
(0 bedømmelser)
0.0
Tiybhu

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...........

$160 USD in 15 dage
(0 bedømmelser)
0.0