Dynamic file names in MS Access 97

I would like to have a macro in my Access 97 database to do the following:

Export tables to [CurrentUser].mbd
Where [CurrentUser] is the system variable.

Thus when user 256 executes this macro, each of the tables in the open database is exported to 256.mbd