right, you can create macro's to open any spreadsheets you need that are saved on your system.

for example, rather than keep going to file / open / etc for a file that you use all the time, you can create a macro icon, apply the macro to the button so it opens the file on the click of the said button..


but..


how do you create links to folders? and attatch it to an icon?

 

Dave

You need to first open microsoft power point and make some buttons using the bit on the bottom left

Autoshapes open the list up and create a button

Then right click it and click on the hyper link and select edit hyperlink

Click on where it says other file and find the one that you want

This will now be a MACRO to that file and will open it for you

Right click on the button and CUT

paste it into any MICROSOFT documnet word etc and it will open the file you said

So you could have a word document with loads of buttons to your fave common files or pics etc

Nige

 

ill have a pop at work tomorrow, thanks you big fairy

 

Or, its a billion times easier to create a new module in word/excel whatever and paste the following as a macro:

Option Explicit

Sub test()
Dim davesFolder As FileDialog
Set davesFolder = Application.FileDialog(msoFileDialogFolderPicker)
davesFolder.InitialFileName = "C:\daves_useful_folder\"
davesFolder.Show
End Sub

Cheers.