Page 1 of 1
Using VBA Application.run "DBSS"
Posted: Fri Oct 26, 2012 3:21 pm
by 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?
Re: Using VBA Application.run "DBSS"
Posted: Fri Oct 26, 2012 3:48 pm
by 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",...)
Re: Using VBA Application.run "DBSS"
Posted: Fri Oct 26, 2012 5:28 pm
by debraannhall
That is what I was looking for.
Thanks