Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Flowchart wizard (2002, WinNT SP6)

    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

  2. #2
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Flowchart wizard (2002, WinNT SP6)

    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

  3. #3
    Plutonium Lounger
    Join Date
    Nov 2001
    Posts
    10,550
    Thanks
    0
    Thanked 7 Times in 7 Posts

    Re: Flowchart wizard (2002, WinNT SP6)

    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

  4. #4
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Flowchart wizard (2002, WinNT SP6)

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •