Check for open workbook

's Computer Specifications

How do I check to find out if Tempdata.xls is open and if it is close it?

's Computer Specifications

I'd just try to close it:

on error resume next 'in case it isn't open
workbooks("tempdata.xls").close savechanges:=true 'false???
on error goto 0

Oldjay wrote:
>
> How do I check to find out if Tempdata.xls is open and if it is close it?

--

Dave Peterson

's Computer Specifications

On error Resume next
workbooks("Tempdata.xls").Close SaveChanges:=False
On Error goto 0

--
Regards,
Tom Ogilvy

"Oldjay" wrote:

> How do I check to find out if Tempdata.xls is open and if it is close it?

's Computer Specifications

Thanks

"Dave Peterson" wrote:

> I'd just try to close it:
>
> on error resume next 'in case it isn't open
> workbooks("tempdata.xls").close savechanges:=true 'false???
> on error goto 0
>
>
>
> Oldjay wrote:
> >
> > How do I check to find out if Tempdata.xls is open and if it is close it?
>
> --
>
> Dave Peterson
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA to check is someone else has a workbook open	Jim K.	Microsoft Excel Misc	2	29th Aug 2008 04:32 PM
Check if workbook is open...	John	Microsoft Excel Programming	2	10th Jun 2008 10:04 PM
If Then to check if a workbook is open	=?Utf-8?B?U2hhd24=?=	Microsoft Excel Misc	5	25th Nov 2006 04:29 PM
How check if workbook open?	=?Utf-8?B?SWFuIEVsbGlvdHQ=?=	Microsoft Excel Programming	7	14th Apr 2006 08:54 PM
Check for open workbook	georgio	Microsoft Excel Programming	2	20th Nov 2004 11:03 PM