LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 553
Default Problems Loading Large String Array into Array variable

I am trying to load a very large string array into an array variable. I am
having problems as I have too many line continuations (i.e. lines which end
with "_"). Is there a bettter way to do this. I want to keep the list in my
VBA code as opposed to puttng it in a text file.

TempArray =
Array("A","ABLE","ABOUT","ABOVE","ACCORDING","ACCO UNT","ACROSS","ACT","ACTION","ACTIVITIES","ACTIVIT Y","ACTUALLY","ADDED","ADDITION","ADDITIONAL","ADM INISTRATION","AFTER","AGAIN","AGAINST","AGE","AGO" ,"AHEAD","AID","AIR","ALL","ALMOST","ALONE","ALONG ","ALREADY","ALSO","ALTHOUGH","ALWAYS","AM","AMERI CA","AMERICAN","AMONG","AMOUNT","AN","ANALYSIS","A ND","ANOTHER","ANSWER","ANTI","ANY","ANYONE","ANYT HING","APPARENTLY","APPEAR","APPEARED","APPROACH", "ARE","AREA","AREAS","ARMS","ARMY","AROUND","ART", "AS","ASK","ASKED","ASSOCIATION","AT","ATTACK","AT TENTION","AUDIENCE","AVAILABLE","AVERAGE","AWAY"," B","BACK","BAD","BALL","BASED","BASIC","BASIS","BE ","BEAUTIFUL","BECAME","BECAUSE","BECOME","BED","B EEN","BEFORE","BEGAN","BEGINNING","BEHIND","BEING" ,"BELIEVE","BELOW","BEST","BETTER","BETWEEN","BEYO ND","BIG","BILL","BLACK","BLOOD","BLUE","BOARD","B ODY","BOOK","BORN","BOTH","BOY","BOYS","BRING","BR ITISH","BROUGHT","BROWN","BUILDING","BUILT","BUSIN ESS","BUT","BY","C","CALL","CALLED","CAME","CAN"," CANNOT","CANT","CAR","CARE","CARRIED","CARS","CASE ","CASES","CAUSE","CENT","CENTER","CENTRAL","CENTU RY","CERTAIN","CERTAINLY","CHANCE","CHANGE","CHANG ES","CHARACTER","CHARGE","CHIEF","CHILD","CHILDREN ","CHOICE","CHRISTIAN","CHURCH","CITY","CLASS","CL EAR","CLEARLY","CLOSE","CLOSED","CLUB","CO","COLD" ,"COLLEGE","COLOR","COME","COMES","COMING","COMMIT TEE","COMMON","COMMUNIST","COMMUNITY","COMPANY","C OMPLETE","COMPLETELY","CONCERNED","CONDITIONS","CO NGRESS","CONSIDER","CONSIDERED","CONTINUED","CONTR OL","CORNER","CORPS","COST","COSTS","COULD","COULD NT","COUNTRIES","COUNTRY","COUNTY","COUPLE","COURS E","COURT","COVERED","CUT","D","DAILY","DARK","DAT A","DAY","DAYS","DE","DEAD","DEAL","DEATH","DECIDE D","DECISION","DEEP","DEFENSE","DEGREE","DEMOCRATI C","DEPARTMENT","DESCRIBED","DESIGN","DESIGNED","D ETERMINED","DEVELOPED","DEVELOPMENT","DID","DIDNT" ,"DIFFERENCE","DIFFERENT","DIFFICULT","DIRECT","DI RECTION","DIRECTLY","DISTANCE","DISTRICT","DO","DO ES","DOING","DONE","DONT","DOOR","DOUBT","DOWN","D R","DRIVE","DUE","DURING","E","EACH","EARLIER","EA RLY","EARTH","EAST","EASY","ECONOMIC","EDUCATION", "EFFECT","EFFECTIVE","EFFECTS","EFFORT","EFFORTS", "EIGHT","EITHER","ELEMENTS","ELSE","END","ENGLAND" ,"ENGLISH","ENOUGH","ENTIRE","EQUIPMENT","ESPECIAL LY","ESTABLISHED","EUROPE","EVEN","EVENING","EVER" ,"EVERY","EVERYTHING","EVIDENCE","EXAMPLE","EXCEPT ","EXISTENCE","EXPECT","EXPECTED","EXPERIENCE","EX TENT","EYE","EYES","F","FACE","FACT","FAITH","FALL ","FAMILY","FAR","FARM","FATHER","FEAR","FEDERAL", "FEED","FEEL","FEELING","FEET","FELT","FEW","FIELD ","FIGURE","FIGURES","FILLED","FINAL","FINALLY","F IND","FINE","FIRE","FIRM","FIRST","FISCAL","FIVE", "FLOOR","FOLLOWED","FOLLOWING","FOOD","FOOT","FOR" ,"FORCE","FORCES","FOREIGN","FORM","FORMER","FORMS ","FORWARD","FOUND","FOUR","FREE","FREEDOM","FRENC H","FRIEND","FRIENDS","FROM","FRONT","FULL","FUNCT ION","FURTHER","FUTURE","G","GAME","GAVE","GENERAL ","GENERALLY","GEORGE","GET","GETTING","GIRL","GIR LS","GIVE","GIVEN","GIVES","GLASS","GO","GOD","GOI NG","GONE","GOOD","GOT","GOVERNMENT","GREAT","GREA TER","GREEN","GROUND","GROUP","GROUPS","GROWING"," GROWTH","GUN","H","HAD","HAIR","HALF","HALL","HAND ","HANDS","HAPPENED","HARD","HAS","HAVE","HAVING", "HE","HEAD","HEAR","HEARD","HEART","HEAVY","HELD", "HELL","HELP","HER","HERE","HERSELF","HES","HIGH", "HIGHER","HIM","HIMSELF","HIS","HISTORY","HIT","HO LD","HOME","HOPE","HORSE","HOSPITAL","HOT","HOTEL" ,"HOUR","HOURS","HOUSE","HOW","HOWEVER","HUMAN","H UNDRED","HUSBAND","I","IDEA","IDEAS","IF","ILL","I M","IMAGE","IMMEDIATELY","IMPORTANT","IN","INCLUDE ","INCLUDING","INCOME","INCREASE","INCREASED","IND EED","INDIVIDUAL","INDUSTRIAL","INDUSTRY","INFLUEN CE","INFORMATION","INSIDE","INSTEAD","INTEREST","I NTERNATIONAL","INTO","INVOLVED","IS","ISLAND","ISS UE","IT","ITS","ITSELF","IVE","J","JOB","JOHN","JU ST","JUSTICE","KEEP","KENNEDY","KEPT","KIND","KNEW ","KNOW","KNOWLEDGE","KNOWN","L","LABOR","LACK","L AND","LANGUAGE","LARGE","LARGER","LAST","LATE","LA TER","LATTER","LAW","LAY","LEAD","LEADERS","LEARNE D","LEAST","LEAVE","LED","LEFT","LENGTH","LESS","L ET","LETTER","LETTERS","LEVEL","LIFE","LIGHT""LIKE ","LIKELY","LINE","LINES","LIST","LITERATURE","LIT TLE","LIVE","LIVED","LIVING","LOCAL","LONG","LONGE R","LOOK","LOOKED","LOOKING","LOST","LOT","LOVE"," LOW","LOWER","M","MADE","MAIN","MAJOR","MAKE","MAK ES","MAKING","MAN","MANNER","MANS","MANY","MARCH", "MARKET","MARRIED","MASS","MATERIAL","MATTER","MAY ","MAYBE","ME","MEAN","MEANING","MEANS","MEDICAL", "MEET","MEETING","MEMBER","MEMBERS","MEN","MERELY" ,"MET","METHOD","METHODS","MIDDLE","MIGHT","MILES" ,"MILITARY","MILLION","MIND","MINUTES","MISS","MOD ERN","MOMENT","MONEY","MONTH","MONTHS","MORAL","MO RE","MORNING","MOST","MOTHER","MOVE","MOVED","MOVE MENT","MOVING","MR","MRS","MUCH","MUSIC","MUST","M Y","MYSELF","N","NAME","NATION","NATIONAL","NATION S","NATURAL","NATURE","NEAR","NEARLY","NECESSARY", "NEED","NEEDED","NEEDS","NEGRO","NEITHER","NEVER", "NEW","NEXT","NIGHT","NO","NON","NOR","NORMAL","NO RTH","NOT","NOTE","NOTHING","NOW","NUCLEAR","NUMBE R","NUMBERS","OBTAINED","OBVIOUSLY","OF","OFF","OF FICE","OFTEN","OH","OLD","ON","ONCE","ONE","ONES", "ONLY","OPEN","OPENED","OPERATION","OPPORTUNITY"," OR","ORDER","ORGANIZATION","OTHER","OTHERS","OUR", "OUT","OUTSIDE","OVER","OWN","P","PAID","PAPER","P ART","PARTICULAR","PARTICULARLY","PARTS","PARTY"," PASSED","PAST","PATTERN","PAY","PEACE","PEOPLE","P ER","PERFORMANCE","PERHAPS","PERIOD","PERSON","PER SONAL","PERSONS","PHYSICAL","PICTURE","PIECE","PLA CE","PLACED","PLAN","PLANE","PLANNING","PLANS","PL ANT","PLAY","POINT","POINTS","POLICE","POLICY","PO LITICAL","POOL","POOR","POPULATION","POSITION","PO SSIBLE","POST","POWER","PRESENT","PRESIDENT","PRES S","PRESSURE","PRICE","PRINCIPLE","PRIVATE","PROBA BLY","PROBLEM","PROBLEMS","PROCESS","PRODUCTION"," PRODUCTS","PROGRAM","PROGRAMS","PROGRESS","PROPERT Y","PROVIDE","PROVIDED","PUBLIC","PURPOSE","PUT"," QUALITY","QUESTION","QUESTIONS","QUITE","R","RACE" ,"RADIO","RAN","RANGE","RATE","RATHER","REACHED"," REACTION","READ","READING","READY","REAL","REALLY" ,"REASON","RECEIVED","RECENT","RECENTLY","RECORD", "RED","RELIGION","RELIGIOUS","REMEMBER","REPORT"," REPORTED","REQUIRED","RESEARCH","RESPECT","RESPONS IBILITY","REST","RESULT","RESULTS","RETURN","RETUR NED","RIGHT","RIVER","ROAD","ROOM","RUN","RUNNING" ,"S","SAID","SALES","SAME","SAT","SAW","SAY","SAYI NG","SAYS","SCHOOL","SCHOOLS","SCIENCE","SEASON"," SECOND","SECRETARY","SECTION","SEE","SEEM","SEEMED ","SEEMS","SEEN","SELF","SENSE","SENT","SERIES","S ERIOUS","SERVED","SERVICE","SERVICES","SET","SEVEN ","SEVERAL","SHALL","SHE","SHORT","SHOT","SHOULD", "SHOW","SHOWED","SHOWN","SIDE","SIMILAR","SIMPLE", "SIMPLY","SINCE","SINGLE","SITUATION","SIX","SIZE" ,"SLOWLY","SMALL","SO","SOCIAL","SOCIETY","SOME"," SOMETHING","SOMETIMES","SOMEWHAT","SON","SOON","SO RT","SOUND","SOUTH","SOUTHERN","SOVIET","SPACE","S PEAK","SPECIAL","SPECIFIC","SPIRIT","SPRING","SQUA RE","ST","STAFF","STAGE","STAND","STANDARD","START ","STARTED","STATE","STATEMENTS","STATES","STAY"," STEP","STEPS","STILL","STOCK","STOOD","STOP","STOP PED","STORY","STRAIGHT","STREET","STRENGTH","STRON G","STUDENT","STUDENTS","STUDY","SUBJECT","SUCH"," SUDDENLY","SUMMER","SUN","SUPPORT","SURE","SURFACE ","SYSTEM","SYSTEMS","T","TABLE","TAKE","TAKEN","T AKING","TALK","TAX","TECHNICAL","TELL","TEMPERATUR E","TEN","TERM","TERMS","TEST","TH","THAN","THAT", "THATS","THE","THEIR","THEM","THEMSELVES","THEN"," THEORY","THERE","THEREFORE","THERES","THESE","THEY ","THING","THINGS","THINK","THINKING","THIRD","THI RTY","THIS","THOSE","THOUGHT","THREE","THROUGH","T HROUGH","THROUGHOUT","THUS","TIME","TIMES","TO","T ODAY","TOGETHER","TOLD","TOO","TOOK","TOP","TOTAL" ,"TOWARD","TOWN","TRADE","TRAINING","TREATMENT","T RIAL","TRIED","TROUBLE","True","TRUTH","TRY","TRYI NG","TURN","TURNED","TWENTY","TWO","TYPE","TYPES", "U","UNDER","UNDERSTAND","UNDERSTANDING","UNION"," UNITED","UNIVERSITY","UNTIL","UP","UPON","US","USE ","USED","USING","USUALLY","VALUE","VALUES","VARIO US","VERY","VIEW","VOICE","VOLUME","WAITING","WALK ED","WALL","WANT","WANTED","WAR","WAS","WASHINGTON ","WASNT","WATER","WAY","WAYS","WE","WEEK","WEEKS" ,"WELL","WENT","WERE","WEST","WESTERN","WHAT","WHA TEVER","WHEN","WHERE","WHETHER","WHICH","WHILE","W HITE","WHO","WHOLE","WHOM","WHOSE","WHY""WIDE","WI FE","WILL","WILLIAM","WINDOW","WISH","WITH","WITHI N","WITHOUT","WOMAN","WOMEN","WORD","WORDS","WORK" ,"WORKED","WORKING","WORKS","WORLD","WOULD","WOULD NT","WRITING","WRITTEN","WRONG","WROTE","YEAR","YE ARS","YES","YET","YORK","YOU","YOUNG","YOUR","YOUR E")

Thanks

EM

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Named array value in a string variable cubbybear3 Excel Programming 3 November 14th 07 04:22 PM
how to parse string into array or variable? Susan Excel Programming 8 April 3rd 07 08:14 PM
Passing string as array variable (Pivot VBA) klingongardener Excel Discussion (Misc queries) 2 December 23rd 06 07:58 PM
Can't programmatically set a large array string to a range. Lu Excel Programming 0 January 4th 06 01:56 AM
Loading Excel Array from VB Array Faster ExcelMonkey[_3_] Excel Programming 3 January 22nd 04 02:49 AM


All times are GMT +1. The time now is 05:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"