We are trying to create a spreadsheet that will upload files to a ProjectWise folder and the CreateDocument code found at the link below looks like it would do exactly what I need, but I'm not sure how or if you can access the ProjectWise API using VBA in Excel.
You should be able to access the ProjectWise APIs using VBA as you would any other native code based API, but unfortunately, I don't have any experience doing so with VBA. Perhaps someone else in the community might be able to provide some advice.
Looking at your description of what you are attempting to do, i.e. upload files, create documents codes, from data in a spreadsheet, have you considered using PowerShell to accomplish this?
PWPS_DAB has Cmdlets that will do the tasks you mention, and of course Microsoft provides PowerShell Cmdlets to manipulate Excel. Perhaps that approach might be a consideration for a solution to your requirements?
Dan WilliamsSolution ConsultantBentley Systems, IncorporatedPortland, OR, USA (Pacific Time UTC-08:00)
Answer Verified By: Brett Mattas
I invite you to have a look here: https://communities.bentley.com/products/programming/projectwise_programming/f/projectwise-programming---forum/197663/problem-using-the-projectwise-sdk-with-vba-in-microsoft-access
There you will find explanations about VBA and Excel code