VBA and Visio

[Harlequin007]

Guys

I know there's a Visio forum and I've searched both the forum and other groups in earnest to get an answer to this and hope this willl be the best place.

In essence:

I am trying to link and excel workbook into Visio. However, when I use the standard menu commands I get mixed results. Some rows, some columns, not an entire named range.

Can I do this more easily using VBA...?

I simply need to import a named range from an Excel workbook on the network. Having interactivity would be a bonus, having the ability to check the excel file out and open it exclusively would also be a bonus.

Thanks in advance guys.

----------------------------
Cogito Ergo Sum

http://www.discworks.co.uk

----------------------------