Check for open workbook
 

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

Check for open workbook
 

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

Check for open workbook
 

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?

Check for open workbook
 

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