SQL Server Performance

Addig NAmed Range Dynamically

Discussion in 'SQL Server DTS-Related Questions' started by dineshasanka, Aug 31, 2005.

  1. dineshasanka Moderator

    Excel_WorkBook.Names.Add "ImportT1able", sActualLocationOfData supposed to add a Named range to the excel fill. But It doesn't? what can be the reason<br /><br />I think I have missed out very minor this [<img src='/community/emoticons/emotion-6.gif' alt=':(' />!]<br /><br />
    dineshasanka, Aug 31, 2005
    #2

  2. dineshasanka Moderator

    DONE!!

    Excel_WorkBook.Names.Add "ImportTable", "=$H$14:$K$43", True

    is working
    dineshasanka, Sep 1, 2005
    #2

Share This Page