Hi there
Is there anyone out there that have working sample code of using VBA from Office (Excel/Word/Access, preferably Access)?
My immediate goal is to get started on interacting with PW from my Access DB, and my longterm goal is to be able to load finished reports(PDF,Excel) from Access directly into PW with correct meta data.
I have looked at the : http://communities.bentley.com/products/projectwise/content_management/w/wiki/using-the-projectwise-api-in-vba.aspx but run into several problems. For instance there is no sample of how to declare the aaApi functions from VBA. Also several of the functions/classes mentioned seems to be missing. For example the clsAttribute is undefined, and the function VBStringFromPtrW is also undefined, making the otherwise good example useless to me.
Hope someone can help!
The proejctiwse SDK was not really built with VBA in mind.. the VBA path can be difficult to follow with different data-type pointers etc.
Thinking out of the box - what about building the upload program in C\C++ (=easy SDK use) then call the new application from Access\VBA with a shell command and a path name as a parameter to the file to be uploaded ?