Create Planner Tasks with VBA
Would like to be able to automate the creation of tasks for projects with a template concept using VBA.
We create similar tasks for projects consistently. I'd love to be able to hit a button from Access, Excel or even PowerApps to create the ~15 tasks each time we create a project - rather than creating an Excel file and copy and pasting each one.
You can do this with Flow/Automate, but I found out it only works with .xlsx file types and not .xlsm hence why I would like to be able to do it with VBA.
Maybe you could use Automate? I use it to create a project in Access. It automatically creates a task in Planner, folder with subfolders in Sharepoint and OneNote page for notes.
Manuel Scholz commented
WOULD BE AWESOME!!!
it will be very usefull
Erica Ingram commented
i have an access database i made and use for my business and i would LOVE to be able to auto-create planner buckets with static tasks within a plan for it. Then i could customize the information in it automatically.