How to configure the directory name in vba excel code

[priyaahh]

Hi All, I am using the following line hardcoded in my vba code in excel file. D:/PISL/Input/ My problem is, in the above line instead of giving D: i should give only PISL/Input/, this can exists in any of the drives like c:, d:, e:, etc., Please help how to configure the drive name. Thanks in Advance, Regards,

[Lost User]

priyaahh wrote:

Please help how to configure the drive name.

You could save the driveletter-prefix as a Setting[^]. Once saved, use GetSetting to read the drive and concatenate your directory-string :)

I are Troll :suss: