>I am running Excel file with some Visual Basic code on it.
>I need to find a command similar to ADIR in foxpro and another one similar to FILE(filename) in FoxPro. Does any one know what is the equivalent in VBA?
The easiest way to implement both is to create an instance of the Scripting.FileSystemObject; use the GetFolder method to get a folder object, and then step through the Files collection of the Folder object to get your ADIR() equivalent; you can use the FileExists method to test for a file.
You can access the content of the help file from
http://msdn.microsoft.com I think.