In Excel, how to download documents from embedded links and save them all locally -

-

i have excel spread sheet containing links various ms word , pdf documents held on our sharepoint site. these links in 1 column. extracting data sharepoint burn dvd.

what easiest way of downloading each document locally, collecting them , changing link in excel point @ local file? changed excel sheet , folder of documents burned dvd. excel sheet becoming , index documents.

please feel free post first part of work or further questions on macro.

hope these first hints help,

regards,

max


Comments

Post a Comment

Popular posts from this blog

php - How to build a web site which gives a sub-domain dynamically to every registered user? -

-
possible duplicate: create subdomain upon user registration suppose have site, , wish give sub-domain each registered users. site, http://site.com/ . and test-user user registered on site, , site wants make sub-domain user. like http://test-user.site.com . like http://test-user1.site.com test-user1. i hope understood requirement. how can create sub-domain using sites back-end or dynamically while registering? make dns record bring * requests site ip. set web server handle * requests (thanks @animuson mentioning) check $_server['http_host'] against database. profit!!!
Read more

Delphi Wmi Query on a Remote Machine -

-
we use wmiset wmi queries on remote machines. works in delphi 2007 not available delphi xe. i found code wmi queries previous question use wmi delphi . code snippet provided in answer no. 5 works on local machine, need know if possible execute wmi query on remote machine. even if connect remote machine administrator credentials, eolesyserror: access denied exception. regards, pieter. pieter. before connect remote machine using wmi must enable dcom access specified user in remote machine. read these articles understand , fix problems connecting remote machines using wmi. securing remote wmi connection connecting wmi remotely starting windows vista troubleshooting error code 80070005 - access denied (great page find solution connections problems) additionally here leave more clear code connect wmi in remote machine. check part eoleexception exception processed error code , found cause of issue. program wmiremote; {$apptype console} uses sysutils,...
Read more