| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
check if file already is open
Hi all,
In a vba routine a specific workbook has to be opened, but if it´s already open (by another user) it shouldn´t be opened as read-only. Instead i will interrupt the routine and give a msg "the file is already opened by another user, the routine is interrupted". I cant find a method to check if the file is open. I have a similar question when updating PowerPoint slides from Excel. In that case I will check if a specific power-point is opened. Thanks in advance Regards Mats ESI Update |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
check if file already is open
http://support.microsoft.com?kbid=138621 XL: Macro Code to Check Whether a File Is Already Open http://support.microsoft.com?kbid=291295 XL2002: Macro Code to Check Whether a File Is Already Open http://support.microsoft.com?kbid=213383 XL2000: Macro Code to Check Whether a File Is Already Open http://support.microsoft.com?kbid=184982 WD97: VBA Function to Check If File or Document Is Open -- Regards, Tom Ogilvy "Mats Nilsson" wrote in message ... Hi all, In a vba routine a specific workbook has to be opened, but if it´s already open (by another user) it shouldn´t be opened as read-only. Instead i will interrupt the routine and give a msg "the file is already opened by another user, the routine is interrupted". I cant find a method to check if the file is open. I have a similar question when updating PowerPoint slides from Excel. In that case I will check if a specific power-point is opened. Thanks in advance Regards Mats ESI Update |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
check if file already is open
Hi Tom,
Thanks for your help. It seems to work in my routines. Regards, Mats -- ESI Update "Tom Ogilvy" wrote: http://support.microsoft.com?kbid=138621 XL: Macro Code to Check Whether a File Is Already Open http://support.microsoft.com?kbid=291295 XL2002: Macro Code to Check Whether a File Is Already Open http://support.microsoft.com?kbid=213383 XL2000: Macro Code to Check Whether a File Is Already Open http://support.microsoft.com?kbid=184982 WD97: VBA Function to Check If File or Document Is Open -- Regards, Tom Ogilvy "Mats Nilsson" wrote in message ... Hi all, In a vba routine a specific workbook has to be opened, but if it´s already open (by another user) it shouldn´t be opened as read-only. Instead i will interrupt the routine and give a msg "the file is already opened by another user, the routine is interrupted". I cant find a method to check if the file is open. I have a similar question when updating PowerPoint slides from Excel. In that case I will check if a specific power-point is opened. Thanks in advance Regards Mats ESI Update |
| Reply |
| 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) | |||
| How to check Excel file already Open | Excel Programming | |||
| Check file open status | Excel Programming | |||
| check if a file exists / is open | Excel Programming | |||
Hybrid Mode
