Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deploy "Microsoft DTSPackage Object Library"?!
Hello,
I needed to figure out how to have a spreadsheet perform a lot of data processing and then send the data to Sybase. It occurred to me to let Microsot SQL Server DTS bring the data from Excel and then process the data. I found a link on the web that details how to have VB execute a DTS package. http://www.sqldts.com/default.aspx?208 I can create an Excel spreadsheet, create a button, attach the button to a macro and the macro will call DTS. Works great. Question: Since I am a developer with SQL Server loaded as well as Microsoft Excel, I only had to select References and check the "Microsoft DTSPackage Object Library". When I deploy this spreadsheet to the clients, they won't have SQL Server loaded. They might have just the Client connectivity loaded. How do I check for the instance of the object library? If it is not present, how do I load it (from somewhere) to insure that Excel can call DTS? How do you check for the existence and/or load it via code. I apologize if I am in the wrong forum for this question. Thanks. Tony |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Browse a multi-pages "microsoft word document" object in Excel 200 | Excel Discussion (Misc queries) | |||
"Microsoft Visual Basic runtime error '424' object required". | Excel Worksheet Functions | |||
What is Error "Method "Paste" of object "_Worksheet" failed? | Excel Programming | |||
"Library not registered" message accessing an HTMLDocument object | Excel Programming | |||
How to download: "Microsoft Forms 2.0 Library"? | Excel Programming |