Hi all

I would like to loop Application.Run
The aim is to run an excel addin called "bbs_remote" which requires 4 parameters i.e. [Class], [Qualifier], [Category], [Identifier]. These are currently named ranges on a sheet. they are strings.
One of the parameters [Qualifier], I want Application.Run to loop through a number of [Qualifier] while keeping the other parameters constant.
Here are 3 examples of [Qualifier]
INT_LPL_BB1_2017
INT_LPL_BB1_2018
INT_LPL_BB1_2019

Here is some code that does not have a loop yet;

Sub Capture_Data()

Dim x As Variant
Dim a As Variant
Dim arrCommodData() As Variant
Dim count As Integer
Dim rowcount As Integer
Dim iCols As Integer
Dim subcount As Integer
Dim thePath As String
Dim strColName As String

x = Application.Run("bbs_remote", 0, [Class], [Qualifier], [Category], [Identifier])
[Data].ClearContents
[Headings].ClearContents

If IsError(x) Then
** *MsgBox "Invalid data specification. *Please check your input and try again."
** *Exit Sub
End If
Any help at all will be much appreciated, thank you!