En cours

Excel mass update script / software

Hi Freelancers,

I am looking for either an easy to use script or even better a little piece of software where we can select directories with Excel documents in them (2003, 2007 & 2010) which will mass update the connection string properties of the document from one server to another.

So ideally we only need to see two fields;

1) Directories

2) Updated connection string to be changed EG

DRIVER=SQL Server;SERVER=SQLSVR01L;UID=dboreports;PWD=xxxxxx;APP=2007 Microsoft Office system;WSID=ISM0001;Network=DBMSLPCN

If you have any questions let me know, I don't have any preference for platform provided it runs on Windows Server 2003 & Windows Server 2008.

Compétences : Tout va bien, Excel, Architecture Logicielle, SQL

Voir plus : network freelancers app, microsoft office freelancers, microsoft excel software, microsoft excel freelancers, freelancers windows office, freelancers sql server, freelancers directories, driver select, sql software, sql server freelancers, sql freelancers, office freelancers, excel app, better properties, piece software, script excel sql, little sql, microsoft excel script, excel connection, windows script 2008, script software, app excel, driver update, update excel, sql select script

Concernant l'employeur :
( 9 commentaires ) Melbourne, Australia

N° du projet : #2364473

Décerné à :

Nhcuong

Hi, i can do this with VBA for Excel with follow work flow: 1/ Open a Excel file 2/Input all the new connection paramenters: user, password, server, network etc 3/Run a macro, it will prompt user for a folder 4/mac Plus

80 $ AUD en 2 jours
(23 Commentaires)
4.9

3 freelance ont fait une offre moyenne de 50 $ pour ce travail

gangabass

I can do this for you. See PM for details.

40 $ AUD en 1 jour
(96 Commentaires)
5.6
rajeshsaini98

i'm agree with you .i have solution of you [url removed, login to view] also agree with me then my skype id rajeshsaini98

30 $ AUD en 1 jour
(0 Commentaires)
0.0