In VB.net, I use the following to return the actual name of a folder where data is kept. Is there an equivalent in VBA? I sure hope so. It would solve some problems for me.
foldernameGD = CStr(getFolderNameGD("O:\Revenue Management\Centralized Revenue Management Service\CRMS Hotels", propertyNo2 & "*"))
In advance, thanks for your help.