Closed

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, vbscript projects, vbscript pivot connection, check database connection vbscript, check connection vbscript, vbscript for, vbscript, pivot tables, excel pivot, excel database visual basic, simple database visual basic, database projects excel, excel project use database, sql server access excel, simple script excel, update data excel script, simple connection, script excel sql, simple best project, best simple project, excel connection, simple use, simple visual basic database

About the Employer:
( 15 reviews ) Lindlar, Germany

Project ID: #234912

15 freelancers are bidding on average $106 for this job

schandraram

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

$150 USD in 1 day
(55 Reviews)
5.9
expertMan

I can do it.

$149 USD in 3 days
(17 Reviews)
5.6
shmai

Ready to Start. Regards,

$186 USD in 1 day
(6 Reviews)
3.9
momleetech

we can do it

$100 USD in 3 days
(8 Reviews)
3.7
gvyshnya

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)
2.6
Icebear951

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)
2.5
Chishti

Hi,Please see PM thanks

$150 USD in 3 days
(1 Review)
2.4
ashishyahoo

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

$50 USD in 3 days
(1 Review)
1.0
guiqul

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

$80 USD in 3 days
(0 Reviews)
0.0
RASHIDKHAN11111

i Can do it in hours

$125 USD in 3 days
(0 Reviews)
0.0
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 p More

$50 USD in 1 day
(0 Reviews)
0.0
self

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

$100 USD in 3 days
(0 Reviews)
0.0
rkamesh

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)
0.0
Dilip1981

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

$150 USD in 2 days
(0 Reviews)
0.0
Shreesaru

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

$100 USD in 2 days
(0 Reviews)
0.0