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