Can anyone help point me in the right direction here.

In the #Task application, I've selected "Options" and filled out a bunch of "Members". It's set to multiple selection so in the application I can select multiple file types to save to.

What I can't figure out, is how #Task passes these options to the macro. Is it a comma separated string, an array, or whatever?

I've tried to handle them as a string like this with no luck. They will export if I select one at a time. But when I select multiple, it will only save using one of the selected.

****************

Dim Extension As String

Extension = "%STR_Extension%"

'Index string to array

myArray = Split(Extension, ", ")

'Run for each extension selected

For Each i In myArray

myArray_Ext = i

myArray_Ext_Trim = Mid(myArray_Ext, Len(myArray_Ext) - 4, 4)

boolstatus = swModel.SaveAs3(FileLocation & "\" & NewFileName & myArray_Ext_Trim, 0, 0)

Next

****************

I also Tried like this as an array:

****************

Dim Extension As Variant

Extension = Array("%STR_Extension%")

myArray = Extension

'Run for each extension selected

For Each i In myArray

myArray_Ext = i

myArray_Ext_Trim = Mid(myArray_Ext, Len(myArray_Ext) - 4, 4)

boolstatus = swModel.SaveAs3(FileLocation & "\" & NewFileName & myArray_Ext_Trim, 0, 0)

Next

****************