efusaschi
06-16-2016, 06:34 AM
Hello everyone, I'm newcomer.
Tried to look for a similar case as mine, but I couldn't find any threads.
So, this is my problem.
I'm using MSOffice 365 version 2016 together with MSProject 2010.
The following code is in an Excel macro.
" Dim aTaskList As Tasks
Dim aWorksheet As Worksheet
Set aWorksheet = Workbooks("SRLog_template.xlsx").Worksheets(1)
' This works fine
aWorksheet.Cells(3, 2) = ActiveProject.StatusDate
' This doesn't !
Set aTaskList = ActiveProject.Tasks
"
When I run this macro everything is ok until the last codeline, where I get:
Runtime error -2147319779 (8002801d)
Automation error
Library not registered
Anyone helping me??
Thank you in advance
Tried to look for a similar case as mine, but I couldn't find any threads.
So, this is my problem.
I'm using MSOffice 365 version 2016 together with MSProject 2010.
The following code is in an Excel macro.
" Dim aTaskList As Tasks
Dim aWorksheet As Worksheet
Set aWorksheet = Workbooks("SRLog_template.xlsx").Worksheets(1)
' This works fine
aWorksheet.Cells(3, 2) = ActiveProject.StatusDate
' This doesn't !
Set aTaskList = ActiveProject.Tasks
"
When I run this macro everything is ok until the last codeline, where I get:
Runtime error -2147319779 (8002801d)
Automation error
Library not registered
Anyone helping me??
Thank you in advance