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

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