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