Action: Trying to "send" Excel data to a web page that the user sees / uses with the vba code event.
Problem: I can open the window with get, or I can xmlhttp with a message and get a response variable, but not what I don't need. I need the POST login information (service account) from the baked vba code on the POST button and open a browser.
The web page is behind Spring Security and the service account credentials should not be known to the user, they are hidden in the / vba protected workbook. I need to send them to the address.
-> How to open and send at the same time?
What I need is the equivalent of an excel HTML form message with
target=_blank
in vba. Is it possible?
I tried both
ShellExecute
functions and
xmlhttp
.
?