Question about the setlinkondata function RRS feed

  • 問題

  • dear all, 

    i have a question regarding the setlinondata in VB on Excel.
     my codes here are

    sub tester()
    activeworkbook.setlinkondata "MyOption|Stock!'TIM,FITX,0,3,N,0@BidPrice'", "QQ"
    end sub

    sub QQ()
    msgbox "successful"
    end sub

    but it seems this can't work in my excel. it shows that i can't run my macro from 'Book!QQ'
    if someone here can help me out, I appreciate.
    2010年2月25日 上午 04:09