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