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

'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

DIM wb as WorkBook
SET wb = Workbooks.Add()

you can now control the workbook using the variable

eg save is
wb.SaveAs {params}
wb.Close {params}

DIM ws as Worksheet
set ws = wb.ActiveSheet

and so on



"Kirsty" <(E-Mail Removed)> wrote in message
newsC5FD7A1-3E77-429E-990B-(E-Mail Removed)...
> 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