Posted to microsoft.public.excel.programming

Trevor[_4_] Trevor[_4_] is offline

external usenet poster

Posts: 9

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Slow Opening & Odd Closing	ohsix	New Users to Excel	1	May 20th 07 05:28 PM
Closing a workbook upon opening another	Dave	New Users to Excel	3	January 3rd 07 09:57 PM
Event on opening/closing groupings in VBA	Dirk Flakowski	Excel Discussion (Misc queries)	3	November 29th 05 03:52 PM
closing excel after closing a workbook	CWalsh[_2_]	Excel Programming	3	January 21st 04 03:33 PM
Opening and Closing workbooks	Jase	Excel Programming	1	October 15th 03 06:28 AM

All times are GMT +1. The time now is 01:15 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us