• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

MS Planner Integration

ajoshi76

Member
Hi,

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

Thanks and Regards
Ashish Joshi
 

Attachments

  • Dummay.xlsx
    10.9 KB · Views: 6
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 .
 
The code should be executed via Excel - and then output should be validated and verified in Planner - both are microsoft products .
 
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?

 
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.
 
Have you looked at Power Automate? I suspect it will be a better option for this than VBA.
 
Back
Top