Terminé

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

en 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

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% AUD en 2 jours
(23 Commentaires)
4.9

3 freelance font une offre moyenne de $50 pour ce travail

gangabass

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% 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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(0 Commentaires)
0.0