Group,

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.

Don

Recommended Answers

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).

Jump to Post

All 2 Replies

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 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.