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
|