Help- MS Access Macro

[TR_Twiggy]

I don't know if I posted this in the right forum, but I saw another Access post here so I put it here. Here is my problem I am trying to make a macro to export 3 queries from one database where they are setup as a linktable in another database that we use at work. When we used to export it we right clicked the hit export as Excel 97-2000. When I export it as a .xls with the macro the linktable in the other database goes crazy and says it's incompatible. Is there any way I can fix this without relinking all the queries that use these tables cuz that is like 6 queries that I would have to relink.

[TR_Twiggy]

I checked it again after i try to open the query that euses the exported excel file I get this. 'NUN_AGED_BA_M8$' is not a valid name. Make sure that it does not contain invalid characters or punctuation and that it is not too long.
In the macro I have it exporting as NUN AGED BA_M8.xls. Whenever I do it manually it works just fine. Why won't it work with the macro?

[TR_Twiggy]

Anyone please