I have a data set in a range, A3:B104.
Using the following code, I can assign that data set to an array.
I need to save a copy of the workbook with a filename of the values found in the array, but combined.
So basically whatever is in A3 & B3 needs to be the file name of the copy, then A4 & B4, then A5 & B5, etc.
I am having difficult combining my array data points to a single string so that the end result is as I stated above.
Once I can get it combined, I can get the rest, but this step is causing me some headache ......
I am currently researching, studying, and trying to learn everything I can on VBA arrays, but I don't think I have gotten there yet.
Any assistance, hint, advice, etc, is appreciated. I feel like my head is going to explode as I try and wrap my brain around this!!


-Spydey
Using the following code, I can assign that data set to an array.
Code:
Public Sub ItemArray()
Dim rg As Range
Set rg = ThisWorkbook.Worksheets("Summary").Range("A3:B104")
Dim Tracking As Variant
Tracking = rg.Value
Dim i As Long, j As Long
For i = LBound(Tracking) To UBound(Tracking)
For j = LBound(Tracking, 2) To UBound(Tracking, 2)
Next i
Next j
End Sub
I need to save a copy of the workbook with a filename of the values found in the array, but combined.
So basically whatever is in A3 & B3 needs to be the file name of the copy, then A4 & B4, then A5 & B5, etc.
I am having difficult combining my array data points to a single string so that the end result is as I stated above.
Once I can get it combined, I can get the rest, but this step is causing me some headache ......
I am currently researching, studying, and trying to learn everything I can on VBA arrays, but I don't think I have gotten there yet.
Any assistance, hint, advice, etc, is appreciated. I feel like my head is going to explode as I try and wrap my brain around this!!



-Spydey