'To open new workbook
Workbooks.Add

'To open existing workbook
workbooks.Open "<filename"
--
If this post helps click Yes
---------------
Jacob Skaria


"Kirsty" wrote:

I am trying to have my macro open a workbook during the run.
I recorded the macro, and opened the workbook, however, when I now run the
workbook, this is not working. Can anyone help me with how to open a new
workbook during a macro