Application Event ??

[ColinKJ]

Hi All,

Anyone know if there is an Application Event that I could use, so that whenever XL is open, irrispective of what workbook (if any) is loaded, I can use a key combination to open a specific workbook without having to use the Open function.

Alternatively, can I create an Application Event.

Regards

ColinKJ

 

[shyrath]

Try adding a macro to the personal.xls

See here for a good tutorial
http://exceltip.com/st/Adding_a_Custom_Keyboard_Shortcut/646.html

To create the Personal Macro Workbook while storing a new keyboard shortcut:

1. From the Tools menu, select Macro, and then Record New Macro.
2. In the Macro name box, insert a name for the macro (no spaces are allowed between characters).
3. In the Shortcut key box, press Shift+ V.
4. Choose Personal Macro Workbook from the Store macro in dropdown list, and click OK.
5. Record anything you like and then stop recording by pressing the Stop Recording icon.
6. Open the VBE (Visual Basic Editor) by pressing Alt+F11.
7. Double-click Module1 under VBAProject (PERSONAL.XLS).
8. In the PasteValues macro, replace the lines recorded with:
Selection.Formula = Selection.Value
This code converts a selected cell's formula to its current value.
9. Click Save.
10. Press Alt+F4 to close and then reopen Excel.
11. To determine if PERSONAL.XLS is open, select Unhide from the Windows menu.
12. To check the keyboard shortcut, select cells containing formulas, and press Ctrl+Shift+V.

 

[shyrath]

Quickly tested this myself and works fine.

Sub Macro2()
'
' Macro2 Macro
' Macro recorded 8-3-2009 by Shyrath
'
' Keyboard Shortcut: Ctrl+Shift+C
'
Workbooks.Open Filename:="C:\Documents and Settings\User\My Documents\$WORK\$ test.xls"
End Sub

 

[ColinKJ]

Thanks shyrath, I'll give it a try and get back to you.

Regards

ColinKJ

 

[ColinKJ]

Many thanks shyrath that works fine.

Regards

ColinKJ