Check for open workbook

[Oldjay]

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

 

[Dave Peterson]

I'd just try to close it:

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

 

[Tom Ogilvy]

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

 

[Oldjay]

Thanks

I'd just try to close it:

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