This Excel file is a community project and is not officially supported.
Tested on: Windows 10, Excel 16.0, VBA 7.1
Using following librarys: Visual Basic For Applications, Microsoft Excel 16.0 Object Library, Microsoft Forms 2.0 Object Library, Microsoft Scripting Runtime, Microsoft WinHTTP Services, version 5.1
Press ctrl + b for OpenProject synchronization (download, upload ect.) Press ctrl + n for additional filter and sort options (depends on selected worksheet)
https://www.openproject.org/synchronize-excel-openproject/
Basics (Download, Update, Upload):
https://www.youtube.com/watch?v=ZPK-l-e-lKI
Custom Queries:
https://www.youtube.com/watch?v=86X334cg808
Hierarchy:
https://www.youtube.com/watch?v=17yqO0uXE5k
Relations:
https://www.youtube.com/watch?v=y7QBspWlQho
Basics (Download, Update, Upload):
https://www.youtube.com/watch?v=kL4u7ew0yHk
Custom Queries:
https://www.youtube.com/watch?v=Fs-luE7gSXA
Hierarchy:
https://www.youtube.com/watch?v=SaCD8B9-4tM
Relations:
https://www.youtube.com/watch?v=wjTdXBMsrwk
You can activate the debugging function in the user form:
You'll get a log file in your downloads folder then. (C:\Users[user name]\Downloads with the name "OpenProjectExcelLog")
