Member Avatar for Papa_Don

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

Edited by Reverend Jim because: wrong forum
  • 2 Contributors
  • 2 Replies
  • 306 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by Papa_Don

Recommended Answers

All 2 Replies

Member Avatar for tinstaafl

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

Edited by tinstaafl
Member Avatar for Papa_Don

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.