Post reply

DTS export Excel 2003 to Excel 2007

  • January 11, 2015 at 10:13 am

    #293635

    All,

    I have DTS packages which are created from VB. The ranges are scoped to the sheet. I'm in the process of upgrading to Excel 2007.

    I create the range from VB and it seems that Excel requires Sheetname!RangeName rather in 2007 rather than Sheetname$RangeName as the syntax.

    The problem is that the DTS package thinks that the ! is an invalid character but if i use $ then the DTS package can't find the range (presumably because it passes the request to Excel and Excel wants the ! character).

    Are there any fixes or workarounds?

    Thanks

    Andrew

  • January 11, 2015 at 12:08 pm

    #1769321

    Something else is going on there. I'm using EXCEL 2010 and the "$" still works just fine.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply