dynamic links

I have created a folder with various sub-folders which contain a variety of workbooks on a thumb drive. I have a master workbook in the root folder and would like to create dynamic links to the the workbooks in those sub-folders. The reason for the dynamic links is that when the thumb drive is...

Hello all, I want to ask you if it's possible to have link addresses that can change due to the values found in a cell? For example, I have a lot of similar reports in different folders on drive D, depending on date. For 14th of November, I have: D:\Reports\2016\11\14\20161114.xls For 15th...

Hello All (cliche first time here after lot of searching for help but found nothing), I am looking to make many workbooks to monitor different information for clients that constantly change each month. What we are currently doing is having all the different excel workbooks for each client in a...

I am working on a project that would contain data from multiple sites. On the "Welcome" worksheet (the main page) there is a dropdown menu (form control combo box) that will select a site location (which then prompts a picture of the site to appear) I also want a link to appear that will link...

I come here to ask for some help from my VBA expert's friends. I have about 150 .xls files where I have the measurements of the buildings where I've worked in and I need the data of these 150 workbooks in a single main file where I have monthly measurements with a general report and charts...