Færdiggjort

Make Excel 2000 VBA code work in Excel 2010(repost)

We have an Excel 2000 spreadsheet which has VBA code that interfaces with SQL 2005. We would like to upgrade to Excel 2010, but when we do so the programming does not work. We are looking for someone who can make them work. The original spreadsheet is attached.

## Deliverables

Instructions to test if the programming is working:

Log on through terminal services to the server (will provide access instructions):

1. On the desktop there is a folder called "Integrated Business Systems"

2. Open up the excel 2000 document in that folder. We do not have Excel 2010 loaded on this machine. Let me know if we need to load it on another machine (like Server05, so that you can run parallel tests).

3. On tab 1 (Inputs) click on the Update button. That will take about 1-2 minutes for the hourglass image to disappear, while the macros and SQL queries refresh on all the tabs.

4. Go to tab 2 (PSat Rows) 1. Change first drop down box (Level) to "Note1"

2. Change second drop downbox (vs) to "KI"

3. Click the update button. This refreshes the data on the page and prompts you to replace the data in the cells. The pivot table basically ends up refreshing.

4. Click the format button to resize the columns. Most of the data in the table has red/green backgrounds based on statistical significance of that level's score vs. the KI. If it's significantly higher, then it will be green, if it's lower, it's red.

5. You can run such tests on any other tab, but if you get it to work on one tab, it should be easy enough to implement on the other tabs.

Our goal is to easily switch the connection string properties and all the [url removed, login to view] VBA code to the 2010 version, without having to rebuild the entire document.

Evner: PHP

Se mere: visual basic programming code, visual basic programming 2005, vba work, vba with, vba programming in excel, vba load, vba excel programming, the open 2010, statistical programming, sql programming in vba for excel, programming macros, programming in visual basic 2010, programming in vba, programming in excel vba, programming in excel 2010, programming in excel, programming backgrounds, parallel programming in c, open 2010, get it work

Om arbejdsgiveren:
( 141 bedømmelser ) san francisco, United States

Projekt ID: #3309896

Tildelt til:

scottydel

See private message.

$119 USD in 4 dage
(8 bedømmelser)
2.9

7 freelancere byder i gennemsnit $199 på dette job

vishallx

See private message.

$170 USD in 4 dage
(10 bedømmelser)
4.6
CarlR

See private message.

$170 USD in 4 dage
(50 bedømmelser)
4.5
vw7496552vw

See private message.

$255 USD in 4 dage
(1 bedømmelse)
4.5
vw1380117vw

See private message.

$255 USD in 4 dage
(5 bedømmelser)
3.2
inmumbai

See private message.

$170 USD in 4 dage
(10 bedømmelser)
2.4
melhorinfo

See private message.

$255 USD in 4 dage
(5 bedømmelser)
0.0