Question

How to Setup Connection for Word Macro

  • 13 February 2020
  • 1 reply
  • 216 views

Userlevel 5
Badge +9

We are in Apps10 UPD6 and looking at using the Word Macro functionality (that came out in UPD4) to create our proposal documents for Business Opportunity.

Right now - the GET call is prompting us for a database user ID and password.  We actually use ADFS for our user validation, so users don’t have DB IDs.

Does anyone know how to set this up for system to system authentication so the user running the macro does not have to login?

 

The VB code in the Word macro is below

   ' Make a request for the URL.
   Set objXmlHttp = New MSXML2.XMLHTTP60
   objXmlHttp.Open "GET", strUrl, False
 

Thanks


1 reply

Userlevel 5
Badge +11

Hi,

You still can maintain a database account although you use ADFS. Use database credentials for  Word Macro functionality.
Ask your administrator to provide credentials for database account connected to F1 user.

 

/Savinda

Reply