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 : platform freelancers, office for freelancers, network of freelancers app, network of freelancers, network freelancers, microsoft office freelancers, microsoft excel software, microsoft excel freelancers, it network freelancers, freelancers windows office, freelancers sql server, freelancers excel, freelancers directories, driver select, software for freelancers, sql software, sql server freelancers, sql freelancers, in office freelancers, excel with sql server, excel to sql, excel to app, excel app, excel $2-30, better properties

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