Posted to microsoft.public.excel.programming

J_J[_2_]

external usenet poster

Posts: 140

to close a workbook via VBA

I need to know the code to close a workbook which was opened on XL2003 with
the code line below

Workbooks.Open(strFileName1, Editable:=True).RunAutoMacros
Which:=xlAutoOpen

TIA
J_J

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
workbook before close	mohavv	Excel Discussion (Misc queries)	2	November 21st 07 01:27 AM
close only one workbook	bobsmom70601	New Users to Excel	1	March 8th 05 09:43 PM
Close a the current workbook and load another specified workbook	Adrian[_7_]	Excel Programming	4	August 7th 04 05:29 PM
How can I close a workbook using VBA?	Trevor[_4_]	Excel Programming	2	March 2nd 04 01:12 AM
cannot close workbook	chrisneill	Excel Programming	3	July 13th 03 11:10 PM

All times are GMT +1. The time now is 02:40 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us