How to change the default directory
ChDrive "D:\My documents\toto\"
ChDir "D:\My documents\toto\"
--
---
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"Woody" wrote in message
...
Hello,
I tried to change the default directory by the following setting:
ChDir "D:\My documents\toto\"
The I open a dilog box to select a file in this default directory with the
following procedu
Dim oDialog As Office.FileDialog
Set oDialog = XLApp.FileDialog(msoFileDialogFilePicker)
oDialog.Filters.Add "Fichiers Excel", "*.xls"
oDialog.Title = "Sélectionnez le fichier Excel"
oDialog.AllowMultiSelect = False
oDialog.Show
But this dialog remains opened on "My documents" and not on "D:\My
documents\toto\"
What am I missing ?
Thanks for your help
Woody
|