Macro Recorder is your friend.


Gord Dibben MS Excel MVP

On Thu, 29 Oct 2009 09:58:01 -0700, TS wrote:

I have not been able to create a macro to open a seperate workbook
I am in workbook A and would like to run a macro that will open workbook B