Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to change the default directory
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to change the default directory
Woody
See answers in microsoft.public.fr.Excel Cordially Pascal "Woody" a écrit dans le message de news: ... Thanks Bob, but with this FileDialog(msoFileDialogFilePicker) dialog, these ChDrive et ChDir settings do not work for me ;-( Any other idea? "Bob Phillips" a écrit dans le message de news: ... 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to change the default directory
Thanks a lot Papou,
I transfer here the french ng answer: It's a property of this dialog : InitialFileName Set oDialog = XLApp.FileDialog(msoFileDialogFilePicker) oDialog.InitialFileName = "D:\My documents\Toto\" Woody "papou" a écrit dans le message de news: ... Woody See answers in microsoft.public.fr.Excel Cordially Pascal "Woody" a écrit dans le message de news: ... Thanks Bob, but with this FileDialog(msoFileDialogFilePicker) dialog, these ChDrive et ChDir settings do not work for me ;-( Any other idea? "Bob Phillips" a écrit dans le message de news: ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change File Open default directory from My Documents | Setting up and Configuration of Excel | |||
change directory to list default | Excel Discussion (Misc queries) | |||
Change current directory to the directory that the workbook loads from! | Excel Programming | |||
Force use of the Default Directory | Excel Programming | |||
Set Default Directory | Excel Programming |