Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I perform tasks on a closed Workbook
I was wondering if I had to open up a workbook in order to extract data,
filter, sort, delete rows etc.? I already use the workbook().Worksheets() notation to deal with open workbooks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I perform tasks on a closed Workbook
Well I dont believe there is any way you can do data manipulation while
the workbook is closed...but you could have your macro do the opening of the file...so you dont have to open up the workbook...would that help? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can i use one workbook to perform instructions i another | Excel Discussion (Misc queries) | |||
Value from a closed workbook | Excel Discussion (Misc queries) | |||
copy worksheet from closed workbook to active workbook using vba | Excel Worksheet Functions | |||
Getting value from closed workbook | Excel Programming | |||
Using a macro to perform a TASK on another workbook | Excel Programming |