Results 1 to 13 of 13
  1. #1
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    too many line continuations (Word 2000)

    Who ever would have thought ...
    23 seems to be the limit, although I have a sneaking suspicion that the diagnostic might be related to number-of-parameters if not total-character-length of hreaer.
    Attached Images Attached Images
    • File Type: jpg 1.JPG (39.5 KB, 0 views)

  2. #2
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,852
    Thanks
    4
    Thanked 259 Times in 239 Posts

    Re: too many line continuations (Word 2000)

    Whoever would have thought to create a Sub with that many inputs rather than a Function <img src=/S/duck.gif border=0 alt=duck width=23 height=23>

    Perhaps you could try shorter variable names to gain an extra couple of lines in case it is the string length causing the problem.
    Andrew Lockton, Chrysalis Design, Melbourne Australia

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: too many line continuations (Word 2000)

    Yes, there's a limit, and it varies with the version: in Office 95 it was 9, and in Office 97 it was 21 (see XL: How to Continue a Visual Basic Statement from One Line to the Next)

  4. #4
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: too many line continuations (Word 2000)

    >a Sub with that many inputs rather than a Function
    Aaaargh! I have been Found Out! (It was a sub only for as long as I got the parameters in place. It's a function now. Peace and serenity reigns in my household ... <post:=342,195>post 342,195</post:>)

    >in case it is the string length causing the problem
    Thanks, but No Thanks. I'd tried that, briefly, figuring that perhaps the "Too many line continuations" message was related to the traditional "Out Of memory" which some of us remember from the previous millennium; how the stock prices of RAM memory did go up!

    I'm going with the explanation that Hans dredged up for now.

    The function and its cover macro is designed, if I can say that, for an all-singing all-dancing document management system, which can move/copy files, tag them with coded file names etc. hence the large number of parameters. Fed by a GUI, the administrator tests various combinations of parameters, then "freezes" the parameters with a MacroMaker command button that spits out the appropriate hard-wired call to the function, with all relevant parameters set in place as strings.

  5. #5
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: too many line continuations (Word 2000)

    >see XL: How to Continue
    Thanks for dredging this up, Hans.
    I shall spend the rest of my senile life by trying to figure out "Why 21?".(grin)

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

    Re: too many line continuations (Word 2000)

    > Why 21?

    Because it's half of 42.

    StuartR

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: too many line continuations (Word 2000)

    You've stolen my reply! <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>

  8. #8
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: too many line continuations (Word 2000)

    >Because it's half of 42.
    10-4 Good Buddy!

  9. #9
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: too many line continuations (Word 2000)

    >You've stolen my reply!
    There's still half of it left ....

  10. #10
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: too many line continuations (Word 2000)

    Not to worry Chris. Things are improving. I think that you will find Office 2003 will allow 24 continuations, resulting in 25 lines. F.W.I.W.
    Regards
    Don

  11. #11
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: too many line continuations (Word 2000)

    >Office 2003 will allow 24 continuations, resulting in 25 lines
    Oh Good.
    So then Office 2007 will allow 24 continuations, resulting in 25 lines, right?
    (I think that this thread has been continued long enough .....)

  12. #12
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: too many line continuations (Word 2000)

    Can't you group sets of arguments into a user defined type? Or maybe a class?
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  13. #13
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: too many line continuations (Word 2000)

    > Can't you group sets of arguments into a user defined type? Or maybe a class?
    Yes, I can, and do, and have done for over a year now.
    I'm using TYPE structures, especially for GUI forms, and passing data from the INI file into the structure, from the structure to the GUI form, than back again to the INI via the structure. I can thus load the INI file to a structure and pass that structure to the main function/engine, or drive the engine from the GUI.
    All very neat.
    So why 23 (now 25) parameters in a function?
    I was rationalizing four GUI forms, each of which contributed towards the data, each of which (from) had been developed over the past 4 years.
    Listing every piece of data that defined the process was an exercise in clarity. Making every parameter OPTIONAL and then trying to determine a default value was a good exercise in clarity. It was a small step from there to pasting my column of data from a Word table into a function header, ... and here I am.

    FWIW, the rather lengthy function which receives named parameters and coerces every argument into a default, checks for validity etc is a nice (for me) interface between the user-friendly document that lists each parameter, default, action, and the user non-friendly document called my VBA code.

    Years ago I stressed my belief that ALL functions should take two arguments and yield one result; I still feel that that is a good design goal.

Posting Permissions

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