fazz2g
09-21-2015, 09:48 AM
Hi all
I'm trying to make some changes to some VBA someone has created, in a nutshell a spreadsheet creates a project plan in Excel and then with a press of a button it exports this data in Project creating milestones, dates, etc.
It works but it doesn't always work, for instance when creating a project, it breaks when creating the project or when creating the indents/outlines for tasks. But after pressing the button a few times it works. Also I have been trying to add a new button to update an existing project file with just the dates from the spreadsheet instead of creating a new each time the macro is run. I tried to use fileopen to get the path of the file but having real trouble in resolving various errors with 'type mismatch' amongst other things. Alas at least I got the file to open :S.
I am currently running the excel document in 2010 and using Project 2013.
The macro button is found in the 'Gate 2' tab.
Would really like to make some progress and some hints and tips on increasing my knowledge in VBA. Thanks in advance.
I'm trying to make some changes to some VBA someone has created, in a nutshell a spreadsheet creates a project plan in Excel and then with a press of a button it exports this data in Project creating milestones, dates, etc.
It works but it doesn't always work, for instance when creating a project, it breaks when creating the project or when creating the indents/outlines for tasks. But after pressing the button a few times it works. Also I have been trying to add a new button to update an existing project file with just the dates from the spreadsheet instead of creating a new each time the macro is run. I tried to use fileopen to get the path of the file but having real trouble in resolving various errors with 'type mismatch' amongst other things. Alas at least I got the file to open :S.
I am currently running the excel document in 2010 and using Project 2013.
The macro button is found in the 'Gate 2' tab.
Would really like to make some progress and some hints and tips on increasing my knowledge in VBA. Thanks in advance.