|
-
Checking if a file is open before attempting to open it
Hi,
I have the following short code to auto open a macro file when teh main fiel is is opened.
-----------------------------------------------------------------
Sub Auto_Open()
'
' Auto_Open Macro
Workbooks.Open Filename:="G:\PUBS\PP-MS\INVOICES\SALEMAC.xlm", Notify:= _
False
ActiveWindow.Visible = False
End Sub
---------------------------------------------------
I want to change this code so that it frst checks if teh file is already open, and only open it if it is not. Can anyone help with it?
Thanks.
Talāt
Similar Threads
-
By AM003295 in forum VB Classic
Replies: 9
Last Post: 05-19-2009, 01:59 PM
-
Replies: 1
Last Post: 01-28-2006, 06:59 AM
-
By boomstick425 in forum VB Classic
Replies: 1
Last Post: 01-12-2006, 09:54 AM
-
By Hian Chew in forum VB Classic
Replies: 18
Last Post: 03-07-2001, 12:07 PM
-
By JohnN in forum VB Classic
Replies: 0
Last Post: 01-29-2001, 09:54 PM
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
Forum Rules
|
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL
|
Bookmarks