Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening and closing workbook with VBA...
Hello all,
I have a workbook (workbook 1) in which I am performing a vlookup calculation using another workbook (workbook 2). In the macro, I want to open workbook 2, perform the calculation, and then close workbook 2. Anyone have any ideas? Any help is appreciated. Thanks, Trevor |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening and closing workbook with VBA...
Hi Trevor
Start by recording a macro while doing it and see what it gives you. -- HTH. Best wishes Harald Followup to newsgroup only please. "Trevor" wrote in message ... Hello all, I have a workbook (workbook 1) in which I am performing a vlookup calculation using another workbook (workbook 2). In the macro, I want to open workbook 2, perform the calculation, and then close workbook 2. Anyone have any ideas? Any help is appreciated. Thanks, Trevor |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Slow Opening & Odd Closing | New Users to Excel | |||
Closing a workbook upon opening another | New Users to Excel | |||
Event on opening/closing groupings in VBA | Excel Discussion (Misc queries) | |||
closing excel after closing a workbook | Excel Programming | |||
Opening and Closing workbooks | Excel Programming |