Simple VBScript which replaces the database connection of the pivot tables in an Excel workbook

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

I am looking for a script which let's me input or choose the new data source and updates the pivot tables accordingly. Best would be if I was able to just input the ODBC name of the new database.

After the auction I will send the excel workbook that contains the pivot tables 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. There are often such occasions when I need a VB script, so future projects are possible.

Skills: Visual Basic

See more: simple connection vbscript, vbscript simple database, simple vbscript connection, create database connection vbscript access project, vbscript projects, vbscript pivot connection, check database connection vbscript, excel vba switch database connections, vbscript update excel odbc connection, check connection vbscript, vbscript for, vbscript, sql odbc, Simple projects, pivot tables, MS Excel projects, excel with sql server, excel PIVOT, database sql, excel database visual basic, simple database visual basic, database projects excel, visual basic database excel database, excel project use database, sql server access excel

About the Employer:
( 15 reviews ) Lindlar, Germany

Project ID: #234912

15 freelancers are bidding on average $106 for this job


Hello Please see PMB for details of my bid. Thank you

$150 USD in 1 day
(55 Reviews)

I can do it.

$149 USD in 3 days
(17 Reviews)

Ready to Start. Regards,

$186 USD in 1 day
(6 Reviews)

we can do it

$100 USD in 3 days
(8 Reviews)

Dear sir, I will be happy to complete your project. I possess 12-year experience with VB/VBA/VBS. Please view PM for more details.

$50 USD in 2 days
(3 Reviews)

Hi mpt, This is a simple task I can easilly create a solution for, I have extensive experience with visual basic and VB script within Microsoft Office. Pleas check PM for further details. Regards, Icebear951

$55 USD in 3 days
(4 Reviews)

Hi,Please see PM thanks

$150 USD in 3 days
(1 Review)

Dear Sir, I am ready for this. Kindly See PMB. Ashish

$50 USD in 3 days
(1 Review)

I can do it. Hope have a chance. Thanks.

$80 USD in 3 days
(0 Reviews)

i Can do it in hours

$125 USD in 3 days
(0 Reviews)

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 p More

$50 USD in 1 day
(0 Reviews)

Hi, we can develop a script to perform this task Please check PM for detail

$100 USD in 3 days
(0 Reviews)

Hi, I have read throught the requirements and I can address the same within the time constraints(2 days). I have sufficient knowledge of MS Excel, VBA, VB Script, SQL Server 2005 and Access to complete the project with More

$100 USD in 2 days
(0 Reviews)

Hi, We are able to accept your assignment. Thanks.

$150 USD in 2 days
(0 Reviews)

I have extensive experience in VBA,VB and MS office.I am interested.

$100 USD in 2 days
(0 Reviews)