I'm quite new to VBA and if anyone can help it would be
great. is there a way to create a new module and insert
code into it through the workbook_open code.

something like:

Private Sub Workbook_Open()

create.module1
With module1.add
"Sheets(2).Select"
End With

End Sub

or alternatively a way to import a module from file and
then run it through workbook_open