Hi,

Can an Excel macro open a certain folder through lookup table?

Like following:
MS Excel table with following data in columns
A B C D
D01 Models 1-12
D02 Models 12-24
....
E01 Models 1001-1122

When cursor is on whatever cell in a row, the macro will take the value from
the leftmost cell (column A) in a row and then use the lookup table to get
the correct hyperlink (path). For this purpose I created a named area table
on an emtpty worksheet tab. Named 'hyper' on Sheet1.

And the lookup table looks like:
Right column is a hyperlink, I want to be opened.

A B
D01 S:\dm_01
D02 S:\dm_02
D03 S:\dm_03
D10 T:\dm_10
D11 T:\dm_11
.......
E01 T:\dm_41

Perhaps it's even possible to use explorer.exe /n with to open a single
pane?

John