NEED CODE TO EXPORT EXCEL DATA TO PROJECTS

[Rob2015]

When I run the code below on excel it deletes columns and opens Projects for me. What I'm trying to accomplish is to add a code that can export the data from excel to Projects (importing data to line 6 on Projects). Can this be done? See both attachments.

Sub Open_MasterPProject()
'
' Macro2 Macro
'


'
    Application.Run "vba.XLSM!test"
    Application.Run "vba.XLSM!Projects_Open_Projects"
End Sub