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;
Code
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
Display More
Any help at all will be much appreciated, thank you!