Anybody excelling at the trigger function "SetOnLinkData"

cecile

New Member
Joined
Oct 23, 2002
Messages
10
SetOnlinkData allows you to run a macro whenever a DDE data is updated.

This function is very convenient but I could not find a way tp add paramaters to the macro which is triggered.

My code is:

Sub Auto_Open() {
SetOnLinkData("REUTERS|IN!USDJPY=", "UpdateChange")
}


Sub UpdateChange

Set cn as New adodb.Connection
....
with cn
cn.execute("exec MyUpdateProc")
EndSub

and I would like to run Sub

Auto_Open() {
SetOnLinkData("REUTERS|IN!USDJPY=", "UpdateChange('USDJPY')")
}

Sub UpdateChange(ByVal Curr as char)

Set cn as New adodb.Connection
....
with cn
cn.execute("exec MyUpdateProc")
EndSub


The compiler is telling me that the macro [UpdateChange('USDJPY')] does not exist.
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

Forum statistics

Threads
1,144,275
Messages
5,723,448
Members
422,497
Latest member
dougy99

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top