Open a workshhet depending on a cell "name"

[tromao]

Hello guys...

Could i get your help please?

My problem:

Need to open a file from a excel worksheet, but the name of that file must be the text inside a cell.

Example:

cell a1=eglc

so the file i need to open is eglc.xls

how can i create that condition?

Thanks

[jasoncw]

Sure, with VBA. Will that file always be in the same directory is the current workbook? If so, you can use this simple procedure:

Please Login or Register  to view this content.

HTH

Jason

[tromao]

For example...

CHECK---AIRPORT ----Takeoff----Landing
Dep------EGLC-------25871
Aircraft Take-off------20070
Arr-------LPFR-------------------XXXXX
Aircraft Landing-------------------015894



For example:I need to check EGLC so the cell below "airport takeoff" must be [eglc.xls]Plan1'!$M$34 so i can take the takeoff value from the eglc.xls file.

is there any chance to make of this [eglc.xls]Plan1'!$M$34 a condition, because i dont have only one airport to check but hundreds always depending on the airport ICAO code.

Thanks for the help, most precious to me.

THANKS