using Excel commands in Visio VBA

[shlomof]

hello,
I've been trying for quite a while finidng a solution for the following problem, also using this forum, but perhaps I didn't understand some of the expenations.

I have a visio drawing. I'm trying to export some of it's data to excel file.

I succeeded in getting into that data and even openinig an excel file through visio VBA. the problem is I can't seem to find a way to copy that data to excel cells. I understand I need to define a range somehow, but defining a range deosn't exist in visio VBA.

what am I missing?

thanks,
Shlomo

[aledlund]

Are you opening an Excel object (application) and then executing Excel commands against it (your correct in that Visio doesn't understand Excel)?
There's example code over here http://www.visguy.com/2009/04/08/path-analysis-in-visio/
al

[shlomof]

Are you opening an Excel object (application) and then executing Excel commands against it (your correct in that Visio doesn't understand Excel)?
There's example code over here http://www.visguy.com/2009/04/08/path-analysis-in-visio/
al

I did help. I appreciate it!