specify an input directory with GetOpenFilename
Give this a shot
'Load the Input Dir InputDirectory = "C:\" 'Save the current Dir for later Clean up CurrentDirectory = CurDir 'Change the Dir to look in ChDir (InputDirectory) 'Load FileNameToOpen FileNameToOpen = Application.GetOpenFilename 'Clean up ChDir (CurrentDirectory) HTH -Merk |
specify an input directory with GetOpenFilename
Dear experts,
I am using in a macro the GetOpenFilename method to open workbooks on which I am then working. Is there a way I can specify in which directory I want it to open (like a sort of "default value" for input boxes)? Many thanks, Valeria |
specify an input directory with GetOpenFilename
It works wonderfully!
Thanks a lot! Valeria -----Original Message----- Give this a shot 'Load the Input Dir InputDirectory = "C:\" 'Save the current Dir for later Clean up CurrentDirectory = CurDir 'Change the Dir to look in ChDir (InputDirectory) 'Load FileNameToOpen FileNameToOpen = Application.GetOpenFilename 'Clean up ChDir (CurrentDirectory) HTH -Merk . |
All times are GMT +1. The time now is 07:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com