Using VBA Application.run "DBSS"

[debraannhall]

I am trying to write code that will send data to TM1 based on selections in a userform. I want to send the word "term" or "TR" based on the selection box in the userform. I tried the syntax
Application.Run ("DBSS",cell reference for the word "term",cube,book,........)
Is that the correct syntax?

[qml]

Welcome to the forum.

I suspect a problem with the part >>cell reference for the word "term"<<. It's not entirely clear how this translates to your actual VBA code, but the following example might give you an idea of what should work.

Code: Select all

Dim strValueToSend As String
strValueToSend = MyUserForm.MyComboBox.Value
Application.Run ("DBSS",strValueToSend,"cube","element1",...)

[debraannhall]

That is what I was looking for.

Thanks