In, 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.


I think the Dir function, which has wildcard search capabilities, should do the job you want. For more invlolved Drives, Files and Folders access you'll probably need the File System Object(FSO).

tinstaafl, I'll do some reading and give that a try. I hope that works.

Thanks for the help.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.