Forum Discussion
FableoSanca
Jul 29, 2023Copper Contributor
Error on Task object in Excel VBA : Object required
Error on Task object in Excel VBA : Object required Hello I don't understand why the Task object gives me an error, maybe I should add a reference to the excel project, but I haven't found any sugge...
HansVogelaar
Jul 29, 2023MVP
The code that you posted is for Microsoft Project.
If you want to run it from Excel, you will have to create a Project.Application object and open or create a project object.
You cannot simply refer to ActiveProject in Excel VBA because ActiveProject is not an Excel object.
- FabrizioItaliaAug 05, 2023Copper ContributorOk Thanks a lot
Fabrizio