Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Programming / August 2006

Tip: Looking for answers? Try searching our database.

Concatenate arrays?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
JGJP - 17 Aug 2006 03:31 GMT
Thank you to all who have helped me on this project so far. One more
question...

I have a ridiculously long array -- so long Word can't handle it.

I tried

Group1 = Array ( "A", "B", "C", "D")
Group2 = Array ( "E", "F", "G", "H")
GroupAll = Group1 & Group2

but it didn't like that... I also tried

GroupAll = Array (Group1, Group2)

No dice. What do I try now?

Thanks

JPJP
Doug Robbins - Word MVP - 17 Aug 2006 04:27 GMT
How long is ridiculously long?  If this is associated with your population
of combobox issues, are the number of entries too long for the method that I
suggested?  If so, there are probably too many selections for your users to
handle, let alone Word and you should try and split the number of items into
more categories and have the user first pick a category, then and item from
that category and then a sub-item from the item that they have picked in the
category.

For the guy whom I was helping in the link to which I directed you, a
modification of that method was use to deal with 4 or 5 levels of selection,
though, not because of the total number of items, but because of the desire
to categorise them at a number of levels.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Thank you to all who have helped me on this project so far. One more
> question...
[quoted text clipped - 16 lines]
>
> JPJP
JGJP - 17 Aug 2006 12:56 GMT
Doug,

Too long is really just longer than Word will accept. I don't really
have a choice about breaking it up into categories because I'm making
it for someone else. It's not really that they have too many choices --
there were 24 - but there were too many characters. When I split it
into two lines, it accepted it. So is concatenation not feasible?

JGJP

> How long is ridiculously long?  If this is associated with your population
> of combobox issues, are the number of entries too long for the method that I
> suggested?
....
--
> Doug Robbins - Word MVP
>
> "JGJP" <jeanne.goodman@gmail.com> wrote in message
> > I have a ridiculously long array -- so long Word can't handle it.
...
> > JPJP
Jonathan West - 17 Aug 2006 13:19 GMT
You can split a line of code into two lines, like this

Group1 = Array ( "A", "B", "C", "D", _
            "E", "F", "G", "H")

By splitting into as many lines as you require using the line continuation
character, you can put many more terms into the array.

Make sure always that there is a space before the line continuation
character.

Signature

Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org

> Doug,
>
[quoted text clipped - 19 lines]
> ...
>> > JPJP
JGJP - 17 Aug 2006 15:02 GMT
Silly me! I forgot about that! Thank you!

JG

> You can split a line of code into two lines, like this
>
[quoted text clipped - 13 lines]
> Please reply to the newsgroup
> Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.