VBAInterest
IS-IT--Management
Dear Experts,
I am using LiveLink Enterprise (WebDav view doesnt exist). We have a requirement of downloading approximately 200 files from livelink. The process we follow is to search for an individual file and once the file is searched there is an icon against the resultant file which has the option to download or fetch which downloads the file. Since this is too manual a work and time consuming, we are planning to automate it.
I am using EXCEL 2003 VBA to automate this request. Sheet1 has the 200+ file names that I have to download.
I started off with the work but am struck right at the beginning. I am able to get on to the link, login using our credentials and search for the file too... However, once the search file is obtained I am not able to proceed further since I am not able to capture the Function menu using the VBA code or dont know how to initiate the Functionmenu using VBA. Also, I noticed that there is a node id that is being fetched when the file is downloaded. I am not able to understand where the node id is being fetched.
I Appreciate any help that you can provide me in taking me further with this project.
Thank you,
VC
I am using LiveLink Enterprise (WebDav view doesnt exist). We have a requirement of downloading approximately 200 files from livelink. The process we follow is to search for an individual file and once the file is searched there is an icon against the resultant file which has the option to download or fetch which downloads the file. Since this is too manual a work and time consuming, we are planning to automate it.
I am using EXCEL 2003 VBA to automate this request. Sheet1 has the 200+ file names that I have to download.
I started off with the work but am struck right at the beginning. I am able to get on to the link, login using our credentials and search for the file too... However, once the search file is obtained I am not able to proceed further since I am not able to capture the Function menu using the VBA code or dont know how to initiate the Functionmenu using VBA. Also, I noticed that there is a node id that is being fetched when the file is downloaded. I am not able to understand where the node id is being fetched.
I Appreciate any help that you can provide me in taking me further with this project.
Thank you,
VC