Thanks Paul
The sample shows some way to deal with my problem. Again, thanks
Yanto
----- Paul Clement wrote: ----
On Sun, 25 Apr 2004 23:06:03 -0700, "Yanto" <an*******@discussions.microsoft.com> wrote
¤ hi
¤ Can somebody help me with this issue
¤ I'm exporting my data from Analysis Service to excel files using ADOMD.
¤ I got hundreds of excel files that need to be inserted with cube data retrieved from ADOMD connection.
¤ Each of the files would have a pre-defined location where i should start inserting data, for example "R3C4"(each file would be in different cell)
¤ I need to open the existing file, adds data to it, save changes, and closes
¤ I've tried so many ways to deal with problem, but still didn't work. Can anyone show me how to do this?
¤ Thank
You may want to look at some of the MS KB examples that use automation
HOWTO: Automate Excel from Visual Basic .NET to Fill or to Obtain Data in a Range by Using Array
http://support.microsoft.com/default...4&Product=vbNE
HOWTO: Automate Microsoft Excel from Visual Basic .NE
http://support.microsoft.com/default...2&Product=vbNE
Paul ~~~
pc******@ameritech.ne
Microsoft MVP (Visual Basic