Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-18-2014, 11:18 PM
n00bie-n00b n00bie-n00b is offline Insertbefore an array? help :( Windows 7 32bit Insertbefore an array? help :( Office 2007
Novice
Insertbefore an array? help :(
 
Join Date: Aug 2014
Posts: 17
n00bie-n00b is on a distinguished road
Default

Hi, im sure im annoying you buy this point *soory. your last bit of code works great, but is there a way to swap around the but being connected? ie, have the words ending in consonants to connect to words begining with vowels (the opposite of whats happening now).



Also, could you explain to me how to add more to this code ("au", "ei", etc) i dont understand what the `!^32-^62\?\@` does

thanks for your help

Code:
HTML Code:
.Text = "[wrtpdfghklvbnm" & ChrW(593) & ChrW(596) & ChrW(601) & ChrW(604) & ChrW(618) & ChrW(650) & ChrW(652) & "]" _
      & ChrW(9700) & _
      "[aeiouya" & ChrW(593) & ChrW(596) & ChrW(601) & ChrW(604) & ChrW(618) & ChrW(650) & ChrW(652) & "]"

This is the code i have so far, all of the vowels and cons work, but none of the ChrW characters work.

how can i get the characters to work, but also character combinations like ...

letter "a" on its own and letter "a&ChrW(601)" together?

Last edited by n00bie-n00b; 08-18-2014 at 11:48 PM. Reason: update
Reply With Quote
  #2  
Old 08-19-2014, 12:52 AM
macropod's Avatar
macropod macropod is offline Insertbefore an array? help :( Windows 7 32bit Insertbefore an array? help :( Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,374
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by n00bie-n00b View Post
Hi, im sure im annoying you buy this point *soory. your last bit of code works great, but is there a way to swap around the but being connected? ie, have the words ending in consonants to connect to words begining with vowels (the opposite of whats happening now).
Well, you could swap the terms around...
Code:
    .Text = "[!^32-^62\?\@aeiouyæ" & ChrW(593) & ChrW(596) & ChrW(601) & ChrW(604) & ChrW(618) & ChrW(650) & ChrW(652) & "]" _
      & ChrW(9700) & _
      "[aeiouyæ" & ChrW(593) & ChrW(596) & ChrW(601) & ChrW(604) & ChrW(618) & ChrW(650) & ChrW(652) & "]{1,}"
Quote:
Also, could you explain to me how to add more to this code ("au", "ei", etc)
As I said in my previous post, to explicitly work with specified vowel pairs only, a different approach would be required. At present, the code works with any vowel sequences of any length, but can quite easily be limited to, say, no more than two vowels by nothing more complicated than changing {1,} to {1,2}.
Quote:
i dont understand what the `!^32-^62\?\@` does
That is a wildcard expression telling the Find process to not make matches with characters anywhere in the ASCII 32 to 62 range, or with ? or @ characters.

PS: Since your newest thread is really a continuation of the discussion already underway, I've merged the threads.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
complex, connected, insert, macro, n00b



Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding information from a array into a table jcorti Word VBA 4 01-10-2014 10:58 PM
Insertbefore an array? help :( Convert String Array to Integer Array from a User Input? tinfanide Excel Programming 4 12-26-2012 08:56 PM
Insertbefore an array? help :( Complex array formula andrei Excel 9 02-03-2012 03:40 AM
How to capture start and ending Ref. Nos. in an array KIM SOLIS Excel 5 09-07-2011 07:43 AM
Look up an array based on user input johnsmb Excel 2 01-07-2011 01:12 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:58 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft