S
singeredel
I have created shortcut keys to run simple VBA code to access specific
directories. Can anyone tell me why sometimes these shortcut keys will open
the appropriate directory, and many times I get the default directory. It
drives me crazy, particularly when I am running code to access a specific
directory to do something and it brings up the wrong (default) directory.
Here is a sample of the code which is assigned to a shortcut key:
ChangeFileOpenDirectory ("C:\Roberts\Word Templates\Other
Addresses")
Dialogs(wdDialogFileOpen).Show
Sometimes it shows the open dialogue box for the the directory listed, and
sometimes it shows the default directory shown in Tools, Options, "File
Locations". This happens more times than I can count. I have many such
shortcut keys to access various directories, and it happens all the time.
Thanks.
directories. Can anyone tell me why sometimes these shortcut keys will open
the appropriate directory, and many times I get the default directory. It
drives me crazy, particularly when I am running code to access a specific
directory to do something and it brings up the wrong (default) directory.
Here is a sample of the code which is assigned to a shortcut key:
ChangeFileOpenDirectory ("C:\Roberts\Word Templates\Other
Addresses")
Dialogs(wdDialogFileOpen).Show
Sometimes it shows the open dialogue box for the the directory listed, and
sometimes it shows the default directory shown in Tools, Options, "File
Locations". This happens more times than I can count. I have many such
shortcut keys to access various directories, and it happens all the time.
Thanks.