Posted to microsoft.public.excel.programming

Oldjay

external usenet poster

Posts: 337

Close workbook

I want tp close tempdata if it is open

If ActiveWorkbook = "Tempdata.xls" Then
ActiveWorkbook.Close
End If

This dosn't work

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
Hide all Sheets in Workbook then Close Workbook	RyanH	Excel Programming	0	January 29th 08 12:59 PM
Open New Workbook / Save and Close Current Workbook	Joe K.	Excel Programming	1	December 7th 07 08:04 PM
Closing a workbook from a macro doesn't close the workbook	Dave P	Excel Programming	2	July 10th 07 06:16 PM
Help on Workbook close and workbook save events	Adam Harding	Excel Programming	1	September 29th 05 04:12 PM
Close a the current workbook and load another specified workbook	Adrian[_7_]	Excel Programming	4	August 7th 04 05:29 PM

All times are GMT +1. The time now is 05:34 PM.

About Us

"It's about Microsoft Excel"