ChangeFileOpenDirectory

From: "Ed" <nospam@xxxxxxxxxx>
Date: Wed, 21 Nov 2007 06:00:18 -0500

I have installations of the identical VBA program on 20 different computers.
I use the following command with some frequency.

ChangeFileOpenDirectory newpath
With Dialogs(wdDialogFileOpen)
.name = "*.doc"
CloseNum = .Show
End With

The command works perfectly on 19. One the 20th it refuses to work. The
MyDocuments folder consistently opens when the section of code is
encountered.

I have doubled the "ChangeFileOpenDirectory newpath" command (I found that
suggestion on a board) but that doesn't work either.

When I step through (debugging) the vba code it works fine, so I know that
the connections are intact.

Any thoughts?

Ed (in Virginia)

.

Follow-Ups:
- Re: ChangeFileOpenDirectory
  - From: Helmut Weber
- Re: ChangeFileOpenDirectory
  - From: Ed

Prev by Date: Re: Detect if text is too long to fit in a cell
Next by Date: Re: document.Merge() gives inconsistent results
Previous by thread: Re: startup folder problem
Next by thread: Re: ChangeFileOpenDirectory
Index(es):
- Date
- Thread

Relevant Pages

Re: ChangeFileOpenDirectory
... The recalcitrant computer ... 'errors' it generated in processing VBA code) that it was going 'too fast.' ... I use the following command with some frequency. ... I have doubled the "ChangeFileOpenDirectory newpath" command (I found that ...
(microsoft.public.word.vba.general)
Re: variable backend location
... I have created the VBA code you mentioned, created the form and the command ... > In the Click event procedure of the button, ... >>just starting to move from macros to VB code, ...
(microsoft.public.access.externaldata)
Re: Why is there no HELP in Access?
... Do you want to import manually or via macro / VBA code? ... if you kinda know the command ... Do Help search on the TransferText action and you'll be in a good starting ...
(microsoft.public.access.gettingstarted)
Re: Word Template Problem - Worked in 2003, not in 2007
... >I have a template that worked fine in Word 2003, ... which then triggers VBA code to run. ... > in their information and click the command button. ... The next person opens a link> to ...
(microsoft.public.word.vba.general)
Re: Word Template Problem - Worked in 2003, not in 2007
... The template was created ... which then triggers VBA code to run. ... in their information and click the command button. ... The next person opens a link to ...
(microsoft.public.word.vba.general)