| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
check if a file is open
nice one
thanks "Patricia Shannon" wrote in message ... There probably aren't enough files to check to worry about it, but it would be a little more efficient to add the "Exit For" as I've indicated in the code below. "C" wrote: thanks for before i know this isnt as complex with the checking who has it open but i have come up with this Dim chkfile chkfile = 0 Update.Hide For Each ws In Worksheets If ws.Name = "revenue schedules 2006.xls" Then chkfile = 1 == exit for End If Next ws If chkfile = 1 Then 'do code Else MsgBox "the Rev Schedules is not open. please open the file and try again" End If C "C" wrote in message ... also i dont always have the path name of the file it moves but the file name is always the same can i check to see if a window is open "C" wrote in message ... Hi bit of a beginner in excel VBA but i am trying to find out if can check to see if a file is open as in IF 'file a is open' THEN Code code code ELSE msg "file a is not open please try again" END IF is this possible and does anyone have any code for this Thanks C |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to check for Open File! | Excel Discussion (Misc queries) | |||
| check if file is already open | Excel Discussion (Misc queries) | |||
| File Open Check | Excel Programming | |||
| check if file already is open | Excel Programming | |||
| How to check Excel file already Open | Excel Programming | |||
![C[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
