Hi,

I'm fairly new to VB and need to create a macro which will open another
workbook and more specifically a sheet within it depending on its
contents.

I'll try to be a bit clearer. Say cell "A1" contained the name of the
sheet in another workbook, can I get a macro to read the contents of
"A1" and open that specific sheet?

As I said I'm fairly new to this, so the actual code to do it would
excellent.

Thanks