airport

Hi all, I need to solve an Airport Gate Assignment Problem using Excel. The output should include flight number, its respective gate and the time duration for which the gate will be occupied (A picture of which how the output should look like is shown below). Input parameters will be Flight...

Dears, I've the following Macro which is responsible for finding the airport into a TXT. file. It's working perfectly, when the airport is found the macro returns the airport information, at the first line. Sub FindAirportDep() Dim fn As String, txt As String, delim As String, a() As String...

Dears, How can I search for a value in a TXT file and return its correspondence in an Array? In my Excel Spreadsheet, on cell A1, the user will type the airport code, like SBKP for example. It's always a 4 digit string. Then, the VBA code will check if there is the airport SBKP into my TXT...