| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check for open workbook
How do I check to find out if Tempdata.xls is open and if it is close it?
|
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VBA to check is someone else has a workbook open | Excel Discussion (Misc queries) | |||
| Check if workbook is already open... | Excel Programming | |||
| Check if workbook open | Excel Discussion (Misc queries) | |||
| How check if workbook open? | Excel Programming | |||
| Check for open workbook | Excel Programming | |||
Linear Mode
