PDA

View Full Version : NEED CODE TO EXPORT EXCEL DATA TO PROJECTS



Rob2015
08-16-2015, 05:34 PM
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
09-17-2015, 08:47 AM
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?