Re: check if file already is open
- From: Mats Nilsson <MatsNilsson@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 12 Sep 2005 01:30:03 -0700
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" <MatsNilsson@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:22541DC5-9E2D-47B0-8721-7DCF2E0BD1C8@xxxxxxxxxxxxxxxx
> > 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
>
>
>
.
- References:
- check if file already is open
- From: Mats Nilsson
- Re: check if file already is open
- From: Tom Ogilvy
- check if file already is open
- Prev by Date: ASP & EXCEL2003 - RUN-TIME ERROR 1004 in Export method
- Next by Date: Draw a circle to select a desired collection
- Previous by thread: Re: check if file already is open
- Next by thread: Verifying Printer with Excel VBA
- Index(es):
Relevant Pages
|
