Taras
asked on
MS excel check if Links exist
On Ms access 2013 form I have a text box where I select one excel workbook Workbook_A file on server folder that has link to another excel workbook_B on another server folder (user has access to both of those folders).
I want with event procedure - click button to check if all links in workbook_A current and if they are exist or are they are broken for any reason?
I want with event procedure - click button to check if all links in workbook_A current and if they are exist or are they are broken for any reason?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Yes it means it has to be open but you can open it without being visible and then close it
ASKER
Thank you very much
ASKER
......
Set wb = ActiveWorkbook
..........