run vb macro on open

[paddy]

Simple query - I am after the VB code, so that on opening
a spreadsheet a macro contained in the spreadsheet is run
automatically.

To explain further, I have a sreadsheet that has three
query's that refresh via a macro and then the macro
continues and closes the spreadsheet. What I need is the
code to invoke this above macro automatically once the
spreadsheet is opened.

Thanks in advance.