Issue skiping characters by Regular Expressions searching Word

When using Regular Expression search using VBA script in Excel to search Word 
document, "-" character in the word document gets skiped (substituted with "" 
empty character). 

Here is the string in Word: <DE4.0><SWR4.4.l‑CE6:A>

Here is the snipet of VBA code used:

  With Selector.Find
    .text = "\<DE?*^13" 
    .Replacement.text = ""
    .Forward = True
    .Wrap = wdFindzz
    .Format = True
    .MatchCase = False
    .MatchWholeWord = False
    .MatchAllWordForms = False
    .MatchSoundsLike = False
    .MatchWildcards = True
  End With
  While Selector.Find.Execute
    s = Selector.text
  Wend

The search find the string in the Word and here is the resulting string in 
the VBA: <DE4.0><SWR4.4.lCE6:A>



As you can see the "-" hyphen character is missing in the resulting string 
and I can't understand why and how to fix it.



Can someone help me with this?

Thanks

Alex
0
Utf
4/1/2010 12:46:01 PM
excel.programming 6508 articles. 2 followers. Follow

0 Replies
819 Views

Similar Articles

[PageSpeed] 2

Reply:

Similar Artilces:

Format issues
I have created a template in word which I call through a VB script from excel. The excel data is populated in the word every time I run this script. Everything works fine and the data get populated. I have a header in the template which is represents one of the fields in the excel sheet. The header shows the correct linked value for the first 10 pages but then on shows the variable name instead of the value. I have no idea why it does that? can someone help The code is as follows: For iCurrentRow = 1 To iLastRow If ActiveSheet.Range("B" & iCurrentRow...

search headers of all emails
Need to search for an IP address. Can I search all the headers to see if the IP address is one of the mail servers or originating IP addresses etc? If so, How? "Dog Lover" <Dog18*3@test.com> wrote in message news:GNGdnb4od9-jXJXeRVn-3w@comcast.com... > Need to search for an IP address. Can I search all the headers to see > if the IP address is one of the mail servers or originating IP > addresses etc? > > If so, How? > Define a rule that used the "with <specific words> in message header" clause to look for a particular string, like ...

Auto Search When File Opens
Is there a way to configure a spreadsheet so it automatically comes up with the FIND tool as soon as the sheet opens? Thanks, Mark Is there a specific group of text that you want to find? A macro could be written to find it. Otherwise, try CONTROL F. "markmidwest" wrote: > Is there a way to configure a spreadsheet so it automatically comes up with > the FIND tool as soon as the sheet opens? > > Thanks, > Mark You can have a macro run each time that the workbook opens: Option Explicit Sub auto_open() Worksheets("sheet1").Select 'open to...

Outlook issues after Exchange migration
We recently migrated Exchange 5.5 mailboxes to Exchange 2003 on a new domain. This was performed with the exmerge utility in a 2 step process. Now there are 2 issues with Oulook: 1) When a user types a recipient name into the address field, the name autocompletes as normal. But when the mail is sent, a message returns saying it is undeliverable. However, if the user goes into the Contacts folder and from there selects the same user to send a message to, it is successful. 2) If a user shares a calendar, specifying the user with whom to share and the level of permissions, all users in ...

Taskbar issue
Hello All I'm hoping someone can help me with this long-standing problem with both XP and Vista on separate laptops and every computer I've had (except I think Win98). I'm thinking there may be no solution, but what it's worth a try. With both of my machines, I have the taskbar (as well as other toolbars) set out to maximum size - typically half the screen - and to auto hide. (This makes a great program and file launcher) The issue is that the operating system decides it wants open the taskbar on its own from time to time on its own. Various things prompt this, ma...

DST issue
I entered the catalog item: <Feature Name="Item" CatalogItemId="Item:MS:sysgen_timesvc_dst" /> and confirmed that the device has the registry key: HKLM\Software\Microsoft\Clock\AutoDST = 1 But the device still does not automatically adjust for DST. I set the timezone to Pacific, set the time to 3/14/2010 at 1:59AM, waited for one minute...and the time changed to 2:00AM instead of 3:00AM. What am I missing? Thanks. which OS version are you using? have you updated it with the relevant qfes which deal with the changing in DST starting day? -...

Outlook/EX Email Issue
I'm running Windows XP with XP Professional. I cannot send email but I can recieve it using Outlook. There error says that Outlook was unable to access the SMTP server. I cannot access my email at HOME through the web email. What I can do is send/recieve email using Outlook Express AND I can access my email through my web email client outside my home. My ISP (SBC) says its not them and I'm somewhat inclined to agree with them? They say I could have a corrupted kernel32.dll file. I have turned off my Norton, deleted my account and set up a new one and re-installed XP professiona...

Possible Report Issue
Hi. I'm working on a database for a safety audit. The auditors would like to be able to use some of the tables and subtables as a sort of checklist for the audits. The table/subtable structure is as follows: Topic -->Subtopic -->ProgramArea -->ProgramRequirement I decided to create a report that will output that data. However, the report is only outputting information if there are ProgramRequirements already entered for a given ProgramArea. Is there a way to get it to output the ProgramArea and ProgramRequirement even if blank? Or am I going about th...

Attachments in Outlook Express not there !
The problem I am having seems to be slightly different from lost attachments. The emails are shown in the mail Inbox screen, and where there is an attachment, there is a paper clip in the paperclip column . So far so good. However, when I open the e-mail, sometimes there is an actual attachment (paperclip shown in the top bar) , and some times not. If there is an attachment, then this can be opened and all is normal. However, when there is no paperclip, I don't know what has happened to the attachment. It is worth noting that it does not seem to be a size issue because big attachments (6 M...

Word 2000 and Outlook 2007 conflict
We decided to upgrade one of our computers to Outlook 2007. We are still using Word 2000. Now when ever I open Word it will not close. Now it is interferring with my shut down mode. Any ideas? EggHeadCafe - Software Developer Portal of Choice Dr. Dotnetsky's Cool .NET Tips and Tricks # 6 http://www.eggheadcafe.com/tutorials/aspnet/eefc01ed-5683-42dd-8fd4-e7deac3123b2/dr-dotnetskys-cool-net.aspx <Jeneal McKinley> wrote in message news:2009112311126headquarters@gomaytag.com... > We decided to upgrade one of our computers to Outlook 2007. We are still > using Word 2...

Extender Install Issues
GP 8.0 Extender install - I'm encountering the following: *Login to GP brings up screen: "Great Plains Extender needs to finish installing. This may take a few minutes". It has an OK button and clicking on this gets you into GP but it comes up everytime. How can we stop this from popping up all the time. *When creating a new Extender Window and I get select the Form, I get the following error: "A remove range operation on table 'PT_User_Defined_Window_Keys' failed accessing SQL data." Procedure or function zDP_EXT40101L_1 has too many arguments spec...

Inking Feature for Microsoft Word for Mac
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I have recently purchased a MacBook Pro, and I am trying to get used to the software differences between Mac and PC. On my PC, I was an avid user of the inking features in OneNote and Word. (They allowed me to take notes and draw diagrams in class with my Wacom Tablet.) Is there any software for Mac that offers the inking and drawing features of OneNote for PC? It's a feature of OS X, not the individual apps. When you install a compatible tablet, Ink will be available in System Preferences. See Mac Hel...

Adobe issues
We are running GP 9.0, using Windows 7, just installed Adobe 8.0 and are unable to send documents to PDF from GP - the PDF option remains grayed out. We have folowed the KB articles that are available, no success. Do we need to install Adobe 9.0 due to running Windows 7? Is GP 9.0 compatible with Adobe 9? Thank you for any assistance.. Hi Susan, I have a client using Adobe 9 on Windows 7. However, they are on GP 10.0 It is working succesfully. -- Geoff James "Susan" wrote: > We are running GP 9.0, using Windows 7, just installed Adobe 8.0 and are ...

Issue with formula is Pivot table
I have the following formula in a pivot table: =IF(ISBLANK(Qtr[-1]),IF(ISNUMBER(Qtr[-2]),(Qtr[-2]*-0.08)+Qtr[-2], "),IF(ISBLANK(Qtr[-2]),0,Qtr[-1])) First to the issues that I am experiencing. First, the formula wa originally added as the one below but then updated to the formula abov to correctly reflect what I was trying to accomplish. =IF(ISBLANK(Qtr[-1]),IF(Qtr[-2]<>0,(Qtr[-2]*-0.08)+Qtr[-2], "),IF(ISBLANK(Qtr[-2]),0,Qtr[-1])) This issue is the original formula appears in the very first cell o the pivot table and then periodically through out the column. So, yo see ...

PDF to word on Mac?
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Recently I turn to use Mac OS and download some free ebooks as reference for my work. These ebooks are in PDF format and I have installed Adobe reader for Mac to view them. It works well but what makes me confused is that when I copy the contents to my word document (office 2008) but only find they are all messed up, it is a hard work to reformat it. I have Acrobat in my windows PC but they could be used on Mac. Have you come across that problem? Plz give me a hand, I hate to do this manual work. PDF to DOC format ...

Outlook Web Access OWA Issue - Login Prompt for Images
Dear Outlook 2003 / Exchange 2003 Users, Starting over the last two weeks (possibly after an update on the Exchange server), all of my users are starting to encounter the same issue when using Outlook Web Access (using IE6 on XP Pro systems). We have images in our signature block, and now when someone replies using Webmail to an e-mail originally sent via Outlook 2003, a login prompt appears for each image in the e-mail. Every time you cancel the login box, a red x image box appears, until all of the images that should be there are represented by the red x boxes. For the record, this has w...

Hyperlink Issue #2
I have an issue with hyperlinks. When you click on the hyperlink on a webpage it returns an error stating that the the "item could not be created". Outlook 2000/Windows 2000 ...

Update Issues
Has anyone experienced any problems with XP Pro updates sent in Feb.? My Lenovo T61p has performed flawlessly for 2+years but suddenly started turning off and now stays on but freezes-up. I can’t detect a virus and seems like the Feb. updates are all that has changed. I plan to uninstall them….between freeze-ups, unless someone has a better thought. Thanks >Has anyone experienced any problems with XP Pro updates sent in Feb.? My >Lenovo T61p has performed flawlessly for 2+years but suddenly started turning >off and now stays on but freezes-up. I can�t detect a ...

embed .wav to word doc
how can you embed a .wav into a word doc such that it plays when the doc is opened? ...

~ issue
I am currently using Outlook Express 6 and have noticed that for the second time (did a format the first time thinking I had a virus!) that when I have downloaded the 330994 April 2003, Security update for Outlook Express 6 SP1 that anytime I make a change to my address book and reboot I get an icon on my desktop that is named "~" and it basically is my entire address book. Has anyone else experienced this problem and how do I remedy it? Thank you for any help! Sue In reviewing the Outlook Express newsgroups, this is reported as a known issue w/ no fix from Microsoft (report...

Importing multiple identities from Express to Outlook
Help! I have been able to import everything from my main identity from Outlook Express to Outlook, but cannot figure out how to import from my other identity. Please Help! Thanks! bay157 <bay157@discussions.microsoft.com> wrote: > Help! I have been able to import everything from my main identity > from Outlook Express to Outlook, but cannot figure out how to import > from my other identity. Please Help! Thanks! Make the other identity the main identity and then you'll be able to import that. Remember to export mail mesasges from Outlook Express. Do not import m...

Multiple Outlook Mailboxes issues with 3.0
I have a large number of users who have more than one outlook mailboxes, When I open an email from one of the addtional mailboxes, I get an error message that tells me "Only Items in the default Outlook store can be promoted to Microsoft CRM." Does anyone know if this can be worked around?? ...

Outlook 2002 with Word 2000 as email editor??
Has anyone found a patch or other means to use Word 2000 as an email editor with Outlook 2002? I updated to Outlook 2002 in order to install the ActiveSync and now I can't use Word 2000 as my email editor (selection is grayed out in Outlook's options). I've searched but have found no answers, only other people who had the same problem. Any help would be greatly appriciated. -Gary Gary wrote: > Has anyone found a patch or other means to use Word 2000 > as an email editor with Outlook 2002? I updated to Outlook > 2002 in order to install the ActiveSync and now I can&...

chkdsk issue
Whenever I run chkdsk /r, it finds quite a few errors and corrects them. An example is a lot of orphaned files. Then, if I run it again right away, it does the same thing and finds the sa,e orphaned files. What causes this and how can I correct it? Thank you. On 14 May 2010, five256@NOwhere.com wrote in microsoft.public.windows.vista.general: > Whenever I run chkdsk /r, it finds quite a few errors and corrects > them. An example is a lot of orphaned files. Then, if I run it > again right away, it does the same thing and finds the sa,e > orphaned files. What causes...

RSS Sync issue
Hi, I discovered that Outlook is not syncing all my RSS-Feeds. When i tried to export into an OPML list, the same issue which are not synced are not exported as well. Anyone idea ? Thanks Hans ...