Hi !

I have stored procedure for cube processing made in DTS. For some reason I
want to execute procedure from within Excel with one button. I've tried
unsuccesfully to record a macro to do this. Does anybody knows the VBA code
who can do that.
(Excel 2002, 2K, OLAP)

any idea appreciated
Regards,
Vlado Kaligari

(sorry for english)

You can run a DTS package by forking out a new process with the command line
"dtsrun" -- see BOL for the various options you have available.
--
Dave Wickert [MS]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Vlado" <vkaligari (AT) tis (DOT) hr> wrote

Vlado

I know how to do it for excel on Office 2000 and XP, send me
and email to ronnetp (AT) panamhosting (DOT) com

and I will send you and example.

Regards

************************************************** ********************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...