Bookmarking Excel Files from within Excel

[Don]

I have a bunch of files that I frequently need to open from within Excel. Is
there a way to "bookmark" these files say by putting an icon for each file
on the Excel toolbar?

Seems like a very common need so I am hoping there is a solution.

Hitting file, open, navigating to folders, etc gets a little tedious when
you use the same file several times a day. The file drop down menu shows the
last "n" files used, but because I open many files everyday sometimes the
frequently used files do not appear in this list.

Thanks

 

[MIchael]

Add them to the favorites so they are accessed quickly in the explorer
ciao
MIchael

 

[Don]

Okay that would be a little better, but my favorites folder is still pretty
large.

Isn't there a way to click an icon and load a particular file?

I believe that you can create a custom icon that runs a macro, but I don't
know if a macro can open a file.

 

[Gord Dibben]

Don

If you want to go to the bother of having a button for each workbook to
open........

Sub Open_File()
Workbooks.Open Filename:= _
"C:\Program Files\Microsoft Office\Exceldata\12months.xls"
End Sub

Assign to a button on a new Toolbar.

Keep adding code and buttons until you get tired.


Gord Dibben MS Excel MVP