Atlas and VBA

Can you pull data directly from Atlas 3.5 for AX 4.0 by using VBA excel macros? So rather than having to log into Atas excel, you can login into Atlas and pull data from standard excel. If you can, can someone provide examples of VBA code? Thanks