VBA Excel, User input from (Excel add-in) as Parameter in Power Query Editor RRS feed

  • Question

  • Hi I am looking for an Excel add-in solution where the user can manually enter a value. This value needs to become the input for a Power Query Editor Parameter. Can you help me with this?

    The current request is for the first part where the user puts in a value in a textbox/form. This value needs to be used to set the new Current Value of the Parameter in the Power Query Editor (see picture 1)

    Picture 1. Parameter in the Power Query Editor

    Some background information: The final solution must include an downloadable Excel add-in where the user can pass their Username and Password for web access credentials. (see picture 2)
    Here the user can specify the data credentials for the Data Source Settings in the Power Query Editor. See picture two.

    Picture 2. Power Query Editor Datasource Settings – Basic Web Access Credentials

    Friday, December 18, 2020 2:35 PM