Results 1 to 8 of 8

Thread: VBA Macros in NeoOffice

  1. #1
    Draw the Drapes Recognized Member rubah's Avatar
    Join Date
    Dec 2004
    Location
    Now Destiny is done.
    Posts
    30,655
    Blog Entries
    21
    Contributions
    • Former Administrator
    • Former Cid's Knight

    Default VBA Macros in NeoOffice

    Supposedly neooffice calc (the mac brother to openoffice) is supposed to be able to run vba macros now. Well I tried one and it kinda went into a loop and didn't want to stop until I force-quit the program :]

    I'm not too bothered about not being able to run macros in Neooffice for a couple of reasons (computer lab downstairs with office03, don't have anymore assignments that involve them), but the not being able to terminate an endless loop kinda bothers me. Am I missing some aspect of 'LOL WE CAN RUN MOST VBA MACROS NOW' or was I just trying to do some obscenely obscure function like I don't know, if then, while wend, etc?

  2. #2
    Old school, like an old fool. Flying Mullet's Avatar
    Join Date
    Apr 2003
    Location
    Napping in a peach tree.
    Posts
    19,185
    Articles
    6
    Blog Entries
    7
    Contributions
    • Former Administrator
    • Former Cid's Knight
    • Former Senior Site Staff

    Default

    Is this a tried-and-true macro that you're testing? i.e. it doesn't behave this way when executed in other office environments.
    Figaro Castle

  3. #3
    Draw the Drapes Recognized Member rubah's Avatar
    Join Date
    Dec 2004
    Location
    Now Destiny is done.
    Posts
    30,655
    Blog Entries
    21
    Contributions
    • Former Administrator
    • Former Cid's Knight

    Default

    or maybe I just forgot how to use it So let's explore the possibility of having a stop button somehwere so I don't have to always force-quit?

  4. #4
    Hypnotising you crono_logical's Avatar
    Join Date
    May 2001
    Location
    Back in Time
    Posts
    9,313
    Contributions
    • Former Administrator
    • Former Cid's Knight

    Default

    ctrl-break or escape works nice to stop endless loops in vba macros in excel itself, did you try that?
    Problems playing downloaded videos? Try CCCP


  5. #5
    Draw the Drapes Recognized Member rubah's Avatar
    Join Date
    Dec 2004
    Location
    Now Destiny is done.
    Posts
    30,655
    Blog Entries
    21
    Contributions
    • Former Administrator
    • Former Cid's Knight

    Default

    I was pounding on esc and don't have a break button

  6. #6
    Hypnotising you crono_logical's Avatar
    Join Date
    May 2001
    Location
    Back in Time
    Posts
    9,313
    Contributions
    • Former Administrator
    • Former Cid's Knight

    Default

    Break usually shares the Pause button on normal PCs, I dunno about for mac keyboards though
    Problems playing downloaded videos? Try CCCP


  7. #7
    Draw the Drapes Recognized Member rubah's Avatar
    Join Date
    Dec 2004
    Location
    Now Destiny is done.
    Posts
    30,655
    Blog Entries
    21
    Contributions
    • Former Administrator
    • Former Cid's Knight

    Default

    no more most helpful ciddie for YOU munty >:[

  8. #8
    Hypnotising you crono_logical's Avatar
    Join Date
    May 2001
    Location
    Back in Time
    Posts
    9,313
    Contributions
    • Former Administrator
    • Former Cid's Knight

    Default

    I didn't get it last time either, I don't think
    Problems playing downloaded videos? Try CCCP


Posting Permissions

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