AnsweredAssumed Answered

How does #Task handle Multiple Option Selection

Question asked by Derek Eldridge on Apr 3, 2018
Latest reply on Apr 4, 2018 by Derek Eldridge

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

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

 

 

Outcomes