Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
call new workbook
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
call new workbook
'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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
call new workbook
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I call up a line of code that references a cell/range in theactive workbook workbook where I am running my macro from? | Excel Programming | |||
How do I call number values form one workbook to another workbook | Excel Worksheet Functions | |||
need macro to call a workbook w/o the actual name of the workbook | Excel Programming | |||
Call subroutine from another workbook | Excel Programming | |||
Call function from one workbook that resides in another workbook m | Excel Programming |