>I need to figure a way to find out all open tables. Is there a quicker way than going through a for loop and check each work area?

AUsed() will tell you all the tables in the current datasession.

If you need all the tables in all the datasessions, there is no ADataSessions() function so you will need to step through every possible one, try and SET DATASESSION TO it and trap the error telling you it doesn't exist.