MS Planner Integration

[ajoshi76]

Hi,

I am looking for a VBA to integrate excel table and MS Planner - Could one please help?

Thanks and Regards
Ashish Joshi

 

[vletm]

ajoshi76
What kind of VBA are You looking based Your file?
It has one line some kind of data ... what is missing?

 

[ajoshi76]

VBA to upload the data from the excel attached to Microsoft Planner application.

 

[vletm]

ajoshi76
Okay ...
Where could someone else test any code with (Your) Microsoft Planner?
Can Microsoft Planner read Excel-files?

 

[ajoshi76]

The VBA code should be in excel - and when the macro is run - it should have a DB connection to MS Planner application to upload the data from excel to Microsoft planner.

MS planner can read Excel files .

 

[ajoshi76]

The code should be executed via Excel - and then output should be validated and verified in Planner - both are microsoft products .

 

[vletm]

ajoshi76
I cannot use that application.
As You wrote Yourself MS planner can read Excel files
then why You ask something else?
Have You Googled and got eg below?

Forums | Microsoft Power Platform Community

Quickly search for answers, join discussions, post questions, and work smarter in your business applications by joining the Microsoft Dynamics 365 Community.

powerusers.microsoft.com

 

[ajoshi76]

I wanted an automated code - not a manual upload - as it would be a project plan in excel which i wanted to auto sync with Planner. Manual upload doesnt solve my purpose.

 

[Debaser]

Have you looked at Power Automate? I suspect it will be a better option for this than VBA.