Link to home
Start Free TrialLog in
Avatar of Taras
TarasFlag for Canada

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?
SOLUTION
Avatar of Anastasia D. Gavanas
Anastasia D. Gavanas
Flag of Greece image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Taras

ASKER

Rgonzo does it mean that excel workbook_A file has to be open as in code it says

......
Set wb = ActiveWorkbook
..........
Avatar of Rgonzo1971
Rgonzo1971

Yes it means it has to be open but you can open it without being visible and then close it
Avatar of Taras

ASKER

Thank you very much