Populating ComboBoxes

From: Stuart Hodgson (anonymous_at_discussions.microsoft.com)
Date: 04/23/04 

Date: Fri, 23 Apr 2004 02:38:50 -0700

Hi everyone, I'm using code found in this group to
populate the combo box from an external file:

Set sourcedoc = GetObject("c:\filename.doc")

This works absolutely fine, however, I have set up my
forms for an office of people to use and if one person is
already using the system the "filename.doc" is therefore
open and anyone else gets an "open as read only" error
message. I have tried using "Application.DisplayAlerts =
wdAlertsNone" but this doesn't work. Is there a way of
making it opening the file as read only or am I going
about this the wrong way?

Thanks in advance.

Relevant Pages

  • Re: Populating ComboBoxes
    ... to open multiple copies without any problems. ... >populate the combo box from an external file: ... >wdAlertsNone" but this doesn't work. ... >making it opening the file as read only or am I going ...
    (microsoft.public.word.vba.userforms)
  • Re: Copying data from a network file - many problems
    ... memory error if I try to copy everything that is in the external file ... to only select records matching certain criteria (without opening the ... file) (which would return approx 3000 rows) ...
    (microsoft.public.excel.programming)