Accessing Excel worksheet cells from Visio VBA

[Jason V]

I want to get information from an excel worksheet, say a shape name to drop,
how can I get this from the cell or acces a variable in an excel macro that
has that value? Thanks

 

[Al Edlund]

I'd start learning to program excel in vba over here,

http://msdn2.microsoft.com/en-us/library/aa167927(office.11).aspx

when you're ready to program visio come-on back,


al

 

[Jason V]

Al, this code is almost exactly what I needed. The only twist is that I don't
want to create a new workbook or open an existing workbook but I want to
connect to an already open workbook. When I try using the set command to
activeworkbook and activeworksheet I get an object variable or with block
variable not set.
Any ideas how to declare and set to an already open excel file?

 

[Al Edlund]

Jason,
that's probably more appropriately asked in the Excel forums. As I remember
I think excel can open multiple iterations of the application (visio only
opens one copy). So the question is attaching to the correct excel and then
check it's open workbooks. If that is the problem then you would have to
check the system for running processes, not a beginners level of question.
al