In Progress

Simple VBScript which replaces the database connection of pivot table in Excel

An excel workbook contains a pivot table which is connected to a database (SQL Server) as the data source. The workbook is sometimes used on different PCs which each use different databases as the data source for the pivot table. Tables, fields and content are the same in each database. But the database location, name, ODBC connection, etc. are different.

There seems to be no easy way in Excel to just choose a new data source for an existing pivot table if the file is opened on a PC where the previously used data source is not available. So each time I change the PC, I have to go through the whole process of creating the pivot table in order to connect it to the right database.

I am looking for a script which let's me input or choose the new data source and updates the pivot table accordingly. Don't know how it can be done but I am thinking input of the ODBC name should be sufficient because it connects to the correct database on the particular PC. If it works the way I am thinking of, updating the pivot table's data source should only require me a few seconds.

After the auction I will send the excel workbook that contains the pivot table which I want to use. The project is completed when I receive the Excel workbook containing the VB script and was able to use the script to update the database connection on different PCs.

Currently all databases are SQL Server and functionality with SQL Server is essential. It would be nice if the script would also be able to switch to/from MS Access databases (not a must though). The project should be finished within 3 days after the end of the auction. Will pay a tip if it is finished faster.

There are often such occasions when I need a VB script, so future projects are possible.

Thank you very much in advance!

Skills: Visual Basic

See more: vbscript pivot table, vbscript change pivot table data source, vbscript create pivot table, pivot table datasource database vb6, vbscript database connection, excel script database connection, database connection vbscript excel, update workbook connection script, pivot connection excel, excel change data connection script, change excel datasource script, tags script odbc database, change odbc connection pivot table excel, use change data source pivot table, vba change pivot connection, vbscript pivot chart, update excel pivottable server connection, vbscript update odbc, vbscript read pivot table, vbscript database connection asp, update pivottable vba connection, vbscript pivot table data source, vbscript excel pivot, vbscript pivot, excel vbscript database connection

About the Employer:
( 15 reviews ) Lindlar, Germany

Project ID: #233214

5 freelancers are bidding on average $62 for this job

riyoyo

No need to wait for 3 days. It can be solved in just a few hours. I can write a VBA code with a form which will provide you the entry field for data-source detail. So, at first time workbook load, it will check the cur More

$75 USD in 0 days
(11 Reviews)
5.6
momleetech

we can do it

$75 USD in 0 days
(8 Reviews)
3.7
DataQuest

Why not update all the systems to have the same DSN, not difficult, and then no need to worry about changing the workbook?? I can probably have this done in a couple of hours.

$50 USD in 10 days
(1 Review)
1.9
ArunaHM

Hi, I have done this task at my work place and it is a part of regular task. So it is very easy for me to provide you such service. If you want I can send you a screen shot for this task. I would like to work on this More

$60 USD in 1 day
(0 Reviews)
0.0
Elgran

Hi, I have lot of experience in writing scripts in excel. And also i have worked in pivot tables. I can understand your problem and also i can solve the problem. Thanks.

$50 USD in 1 day
(0 Reviews)
0.0