Skip to Content
Mar 20, 2019 at 08:02 AM

VBA - Bex Web


Good afternoon
There is a vba code, it is necessary that when you run the macro, the page with the report opens and the data changes automatically in the fields on the web page (Bex Web):
Dim IE As Object
Set IE = CreateObject("InternetExplorer.Application")
    IE.Visible = True
    IE.Navigate ' the report link
IE.Document.getElementById("DLG_VARIABLE_vsc_cvl_VAR_2_INPUT_inp").value = "004.2019" line : IE.Document.getElementById("DLG_VARIABLE_vsc_cvl_VAR_2_INPUT_inp").value = "004.2019" - gives an error message. I tried using different methods and through Tag, Name, Forms, etc. Nothing happens. Help please...Regards, Oleg.