I'm trying to import a name range from an excel file. I call the DTS
package via VBA and it captures the information I want perfectly. However,
this is only assuming that the workbook I'm calling the package from is the
first workbook open on my desktop. If for some reason it is not when I
call the dts package a copy of the workbook (read only) is generated and
the dts package fails.

Any idea on why this happens or how it may be fixed? This is my first time
working with DTS packages so any help will be greatly appreciated.

Thanks.

I believe the only way around this is to make a copy of the file. What I
believe happens is the driver tries to open the file READ/WRITE which in
this case will not work for you.


--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Jason Mancuso via SQLMonster.com" <forum (AT) nospam (DOT) SQLMonster.com> wrote in
message news:dd7ac96542ad44f0b0274e6bf86d62d2 (AT) SQLMonster (DOT) com...