Flowchart wizard (2002, WinNT SP6)

Topic

New Reply

Help please on flowchart wizard anyone.
Having used the flowchart wizard to set out a flowchart according to data in an excel workbook, the shapes and processes appear on the page starting from the centre out.
Irrespective of where the data lies on the spreadsheet (i.e. sorted in ascending or reverse order) the flowchart still appears from the centre out on the drawing page.
I have even fathomed out that to position a shape I need to state shape.cells(“PinX”).Formula = “4 in” etcetera but when I use this within the sub off Shape.added I still end up with the wizard determining the final layout. My current alternative is to have the template contain a command button which realigns all shapes after the page has been created.
Does anyone have alternative method for creating the flowchart from code to extract Excel data, or perhaps a solution to the wizard positioning?
TIA
Alan Edwards
Cheshire
UK

Reply | Quote

Replies

Can’t believe it’s got the lounge speechless. It must be a first.
I even trekked through VB lounge to no avail.
But in the meantime, I resorted to good old legwork and a constant supply of rocket fuel caffeine.
I didn’t solve how the flowchart wizard brings the data into the flowchart (i.e. how it decides which is first) but I did solve the positioning by sending each objects PinY value to an array and then counting the occurences of that value in the array. If anyone is interested I’ll share the info and code but it seems very lonely out here.
I thought I had it cracked, but then……. how does VB decide on which shape comes next when I use the code?:e.g.
For each shape in activepage.shapes
msgbox shape.name
next
will present the shapes names not in the same order as in the excel worksheet, and not back to front, nor reverse, nor alphabetical, nor numerical, nor ascending, nor descending, blah blah blah…..
Please someone help, I refuse to give up on this and I’m getting a reputation as a clone of Dr Evil after refusing to help the MD to add a new folder in his outlook account.

Alan…maniacal laughter sound effect…..
Cheshire
UK

Reply | Quote

Alan,

I can offer sympathy, but no help.

I use Visio 2000, and I don’t believe it has a flowchart wizard, just shapes and connectors! I suspect there may not be many loungers using Visio 2002.

StuartR

Reply | Quote

Unfortunately I work in an environment where they say sympathy is a wasted emotion. Did your beard grow that fast before you worked with MS products?
Thanks anyway, it’s nice to know there’s others with similar problems. Part of the problem lies not just within the flowchart wizard (that is the means to an end of importing information) but within the next step of using VBA to reposition the shapes on the page.
If anyone can please try a logical explanation as to how and why VBA decides which shape to report on in which order I’d much appreciate it. I think that once I understand that principle it will make the customised positioning of any of the shapes a lot easier.

FYI.
– the shapes are named in a list as PRO1;PRO2;PRO3;PRO4;PRO5 etcetera (no more than 5 on a line).
– when imported they lie sequentially on the page, one after the other left to right 1;2;3;4;5
– on reformatting the page using the for each shape in activepage.shapes…..next sequence, the shapes are moved up the page ordered randomly such as 5;2;3;4;1
– any suggestions as to why it selects shapes in that order?
Alan (my order for laser guided sharks in in the post)
Cheshire
UK

Reply | Quote