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

[Mal Farrelle]

I just saw this - Yes it can be done. Almost anything can be if you ignore the doubters. Is this still a requirement?

I'm not sure I understand the requirement to add to row 6 - can you please clarify? Are WO names in the Project file unique? Will all WOs have a single assigned resource? Do you really need to use VBA, rather than copy/pasting the data? Could new data simply be appended at the end of the Project file?