Skip to main content
Question

How to Setup Connection for Word Macro

  • February 13, 2020
  • 1 reply
  • 228 views
J
Sidekick (Customer)
Forum|alt.badge.img+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

Savinda Suvimal
Hero (Employee)
Forum|alt.badge.img+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


Terms & ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings