Check If File with Key Exsist

Hjemmet

Board Regular
Joined
Jun 20, 2018
Messages
180
I need a Function when i Open My workbook with Lots of Sheet's Controlling Game of Dart's (Round Robin and Cup system by Draw and Seed's Of player...

The function i need is "if file with key in Specific Libary Exits then Open" Workbook

if file not exist Type "masterCode" to open Workbook

Hope that was enough info
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Watch MrExcel Video

Forum statistics

Threads
1,096,440
Messages
5,450,463
Members
405,612
Latest member
cuallaidh

This Week's Hot Topics

Top