AnsweredAssumed Answered

MS Products as 'Reports' - Word/Excel being called from Clarity

Question asked by Dave_3.0 Champion on Jan 22, 2016
Latest reply on Dec 17, 2018 by Dave_3.0

Hello - dunno if this is possible and dunno quite what to "Google" in order to find out...


I have some MS-Office things (Word documents, Excel spreadsheets) that pull data out of Clarity via web-services (Query API) - this all works OK, apart from the fact that the user has to "log into Clarity" from within the Word document and "select" the data somehow that they want to pull out (all powered by VBA macros and the web-services).


My question is, is it possible to host that Word document/Excel spreadsheet somewhere (sharepoint site, random webpage) such that I can open it via a URL and provide parameters to it.


I would like to construct the URL dynamically in Clarity and let users click a Clarity link to seamlessly launch Word/Excel in order to present their data (i.e. without having to prompt them in VBA for various details)