What's changed in vba in Word 2007?

Tutorials Win: Microsoft Windows Forum

- Previous
  - 1
    - Styles help I was working with Russ on this but I had a family emergency and gone for 5 days. I have the following macro but canâ??t get it to work right. When I run the macro for example it converts "^dLISTNUM 24 \l 2" to the word "Heading 2". It doesn't see that as an Outline Number style and make it â??1.2â??. Dim SearchRange As Range Set SearchRange = ActiveDocument.Range SearchRange.TextRetrievalMode.IncludeFieldCodes = True With SearchRange.Find .Forward = True .Wrap = wdFindStop .ClearFormatting .Format = True .Text = "^dLISTNUM ^#^# \l ^#" .Replacement.Text = "" While .Execute SearchRange.Text = "Heading " & SearchRange.Characters.Last.Previous SearchRange.Select Selection.Style = ActiveDocument.Styles("Heading " & _ SearchRange.Characters.Last) SearchRange.SetRange Start:=SearchRange.End, _ End:=ActiveDocument.Range.End Wend End With LEU Tag: What's changed in vba in Word 2007? Tag: 101790
  - 2
    - MI5 Persecution: Stasi 21/4/96 (16220) Subject: Chief Constable Alderson Condemns "Stasi" MI5 Newsgroups:uk.misc,uk.politics,uk.media,uk.legal,soc.culture.british Organization: Toronto Free-Net Summary: Keywords: John Alderson, former Chief Constable of Devon and Cornwall, had the following to say about the expansion of the Security Service's powers, in a recent magazine article; "It is fatal to let the secret service into the area of ordinary crime. MI5 is not under the same restraints as the police. They infiltrate organisations, people's jobs and lives. They operate almost like a cancer." "At the moment the acorn of a Stasi [the former East German communists' secret service] has been planted. It is there for future governments to build on." The message is clear. Criminal subversion and criminal harassment by an unpoliced minority not subject to the law, "infiltration of people's jobs and lives" is with us today. 16220 Tag: What's changed in vba in Word 2007? Tag: 101788
  - 3
    - MI5 Persecution: Leant On 7/4/96 (14706) From: Green <Green@guidion.demon.co.uk> Newsgroups: uk.misc,uk.politics,alt.politics.british,soc.culture.british Subject: Re: MI5 Persecution: Why Aren't the British Police Doing Their Job? Reply-To: Green@guidion.demon.co.uk Date: Sun Apr 7 21:13:30 1996 In article <DpIE0r.736.0.bloor@torfree.net> bu765@torfree.net "Mike Corley" writes: > Last Easter (1995) I went into the local police station in London and spoke to > an officer about the harassment against me. But I couldn't provide tangible > evidence; what people said, in many cases years ago, is beyond proof, and > without something to support my statements I cannot expect a police officer to > take the complaint seriously. This in itself dos not suggest that the police have it in for you. The old bill operates on extremely tight spending limits forced on them by that pillock Michael Howard, and without evidence, they often have higher priorities than chasing something that cannot go to court. I doubt that the police are actually being leant on, but they probably realise that if they looked into this, they would be leant on hard. The met always stays away from anything that looks like it has Defence, Security or secret service interest already, because they realise that they are below these government agencies in the general pecking order. This attitude was made clear in a TV show where a left wing comedian heckled some aristocratic Tory candidate in a local election. The police officer gave the comic a ticking off, even though you could see that this young copper sympathised with the comedian, and regarded the Tory as an upper-crust wanker. He said, and I quote "I'm giving you the ticking off and not him because he's a Lord and I'm a Police Constable." If I walked into my local nick and complained that MI5 were snooping on me, they would show me the door without even looking at my evidence, because that bored desk seargant with only five years to go before he retires doesn't want to start fucking about with somebody who has incurred the wrath of Stella Rimington. He would rather deal with the lost dogs and driving licence producers, eat his cheese and pickle sandwiches and piss off home at the end of his shift than have some high ranking spook having a go at his boss and getting him a bollocking. In short, you have earned much sympathy but little surprise. Just remember that saying about the enemy of your enemies. Have a nice day. ******************************************* QUOTE OF THE DAY****************** * You have just read the opinons of : * "Common sense is merely the set * * * of prejudices a person acquires* ========================================================================= Subject: Re: MI5 Persecution: Why Aren't the British Police Doing Their Job? Newsgroups: uk.misc,uk.politics,alt.politics.british,soc.culture.british Followup-To: uk.misc,uk.politics,alt.politics.british,soc.culture.british References: <DpIE0r.736.0.bloor@torfree.net> Organization: Toronto Free-Net Distribution: >This in itself dos not suggest that the police have it in for you. >The old bill operates on extremely tight spending limits forced on >them by that pillock Michael Howard, and without evidence, they >often have higher priorities than chasing something that cannot go >to court. I think the police know well what's going on. It is up to them to do something about it. They know I've made a complaint at a police station. I could probably do more to try to help myself (I think someone suggested making a written complaint to the chief constable) but even then I nthink they would not take action. > >I doubt that the police are actually being leant on, but they probably >realise that if they looked into this, they would be leant on hard. >The met always stays away from anything that looks like it has Defence, >Security or secret service interest already, because they realise that >they are below these government agencies in the general pecking order. > So we have a situation where the security service breaks the law, everyone knows MI5 breaks the law, and the police won't investigate crimes that would otherwise earn a jail sentence. Oh good, I'm really glad the UK is a democracy. (<sarcasm>, for those of you who didn't catch that) >If I walked into my local nick and complained that MI5 were snooping on me, >they would show me the door without even looking at my evidence, because >that bored desk seargant with only five years to go before he retires >doesn't want to start fucking about with somebody who has incurred the >wrath of Stella Rimington. He would rather deal with the lost dogs and >driving licence producers, eat his cheese and pickle sandwiches and piss >off home at the end of his shift than have some high ranking spook having >a go at his boss and getting him a bollocking. In this case I think it is 'high-ranking' police officers who are aware of the persecution, they know a complaint has been made, and they're doing nothing. What is more, I don't think there is anything I can do that would make them take action, both because they may be being 'leant on' and through the wider view that it could be deleterious to the state to have a persecution by state organs exposed. They're wrong in taking that point of view, because sooner or later this will all out anyway, and they it will be n years of police inaction (n>=6) that will be questioned. > >In short, you have earned much sympathy but little surprise. Just remember >that saying about the enemy of your enemies. > >Have a nice day. 14706 Tag: What's changed in vba in Word 2007? Tag: 101787
  - 4
    - MI5 Persecution: Shoot to Kill 4/4/96 (13192) Newsgroups: uk.misc,uk.politics,alt.politics.british,soc.culture.british From: jbaker@pobox.com (Jill Baker) Subject: Re: MI5 Persecution: How and Why Did it Start? Reply-To: jbaker@pobox.com Date: Thu Apr 4 05:03:01 1996 jbaker@pobox.com (Jill Baker) wrote: >bu765@torfree.net (Mike Corley) wrote: >>Why would >>the security services expend hundreds of thousands of pounds and more than fiv >>years of manpower to try to kill a British citizen? Because ... >So why didn't they just shoot you dead? >It would have been a lot cheaper. Please make the effort to respond to this point Mike. It was a serious question. Jill (my opinions are entirely my own, no-one else's) ================================================================= Subject: Re: MI5 Persecution: How and Why Did it Start? Newsgroups: uk.misc,uk.politics,alt.politics.british,soc.culture.british Followup-To: uk.misc,uk.politics,alt.politics.british,soc.culture.british References: <Dp5IAr.1EB.0.bloor@torfree.net> Organization: Toronto Free-Net Distribution: jbaker@pobox.com (Jill Baker) wrote: >bu765@torfree.net (Mike Corley) wrote: >>Why would >>the security services expend hundreds of thousands of pounds and more than fiv >>years of manpower to try to kill a British citizen? Because ... >So why didn't they just shoot you dead? >It would have been a lot cheaper. I think there are two reasons nobody has taken physical action as opposed to verbal; a) A lot of people "know". Perhaps you the reader might not know, but lots of people in the media etc do. Remember, I was born in the UK and lived there until a couple of years ago. I don't think these people would condone state-sponsored murder of someone who might be seen on a good day as one of their own. b) Rather than doind anything directly, they're going for spying, verbal harassment, media harassment, every form of persecution short of the physical. Because as soon as anything turns physical, the police become involved; and unless it turns physical, the police can shrug and say 'not our problem'. So they persecute you and try to get you to react, either by hitting one of them (in which case I clearly find myself in the wrong as far as the police are concerned), or by trying to harm myself (in which case they can pretend they weren't responsible). It's a pretty unproductive form of harassment actually, because if you don't react then they're wasting they're time. Or perhaps they're just cheap bullies and trying to wreck someone's life, without any ulterior motive? 13192 Tag: What's changed in vba in Word 2007? Tag: 101786
  - 5
    - MI5 Persecution: Email Cruelty 11/3/96 (11678) From: D.S.Toube@qmw.ac.uk (David Toube) Newsgroups: uk.misc,uk.politics,uk.legal,uk.media,soc.culture.british Subject: Re: Why Censorship Must Not Be Allowed on Uk.* Reply-To: D.S.Toube@qmw.ac.uk Date: Mon Mar 11 11:47:13 1996 A OSHINEYE <TA5330@QMWCC7.qmw.ac.uk> wrote: :D.S.Toube@qmw.ac.uk (David Toube) wrote: :>I would also be very pleased if Mike Corley would not mailbomb me :>via my university account with messages entitled 'This Is What :>You Get For Censorship', thus closing down the entire college :>email system. :> :>Although it does not personally inconvenience me, it is rather :>dull for the college. :When did this happen? BTW you can always use Pegasus Mail to send all :email from Corley's address back to him and see how he likes it. :--Ade : This weekend. The result, Mike Corley will be gratified to hear, was that all users of the college system were prevented from using email. I suspect that there is no stopping Mike Corley. If mail is automatically returned to him, he will return it back to you tenfold. If he is thrown off his account, as he surely will be, he will find another one. I do not care whether Mike Corley has an email account or not. It is a matter of supreme indifference to me whether his fanciful account of persecution is aired or not. If he thinks that he has been persecuted by M15 and Chris Tarrant, then that is a matter for him. But there is a world of difference between repeatedly spamming usenet - which is unacceptable - and setting up a Web Site containing his post, which is entirely acceptable. Then it will be possible to choose whether or not to partake of his fantasy. However although I would not like to see the censorship of posts because they demonstrate evidence of mental illness, I suspect that Mike Corley will inevitably be censored by his ISP following a number of complaints of usenet abuse and mailbombing. ---- David Toube Lecturer in Law QMW, University of London WWW: http://www.qmw.ac.uk/~ugtl027/index.html David Boothroyd's British Elections Home Page WWW: http://www.qmw.ac.uk/~laws/election/home.html 11678 Tag: What's changed in vba in Word 2007? Tag: 101785
  - 6
    - MI5 Persecution: Jeff Rooker MP 5/3/96 (10164) From: rael@midnight.org (Rael A. Fenchurch) Newsgroups: uk.misc,uk.politics,uk.media,uk.legal,alt.politics.british Subject: Re: Persecution in the U.K. Date: Tue Mar 5 04:37:52 1996 Mike, >"go away" replies, and one from a Labour MP saying he was aware of my situation >but wouldn't help me because he regarded me as the "bad guy". Gee thanks, they >do this and then offload the shame they should feel onto you by telling you "oh >but it's your fault". It's a mad world. Do you happen to have a copy of this MPs letter? After all, a scanned copy of it would lend great weight to your case here. At the moment, you've offered us nothing in the way of evidence, which is one of the main reasons we all think you've truly gone fishing. So? Rael... ----------------------------------------------------------------------------- --- Rael A. Fenchurch (rael@midnight.org, http://www.midnight.org/rael/) --- --- "I don't think compassion's the language of our time" --- --- "Doubt or Die" --- ----------------------------------------------------------------------------- ========================================================================== From: Andy Howard <andy@kiss100.demon.co.uk> Newsgroups: uk.misc,uk.politics,uk.media,uk.legal,alt.politics.british Subject: Re: Persecution in the U.K. Reply-To: andy@kiss100.demon.co.uk Date: Tue Mar 5 06:06:15 1996 In article: <DnrMsq.239.0.bloor@torfree.net> bu765@torfree.net (Mike Corley) wr I got a few > "go away" replies, and one from a Labour MP saying he was aware of my situatio > but wouldn't help me because he regarded me as the "bad guy". Which Labour MP Mike? > -- --------------------------------------------------------------------------- | Andy Howard EMail andy@kiss100.demon.co.uk | | My opinions, not my employer's (Jolly nice people though they are). | | If my employers shared my opinions... Well, frankly I'd be amazed | --------------------------------------------------------------------------- ==================================================================== Subject: Re: Persecution in the U.K. Newsgroups: uk.misc,uk.politics,uk.media,uk.legal,alt.politics.british,soc.culture.br$ Followup-To: uk.misc,uk.politics,uk.media,uk.legal,alt.politics.british,soc.culture.b$ References: <DnFtLs.E37.0.bloor@torfree.net> <4h45nq$87o_002@leeds.ac.uk> <4h6gkb$ivc$ Organization: Toronto Free-Net Distribution: Mike Corley (bu765@torfree.net) wrote: : >Do you happen to have a copy of this MPs letter? After all, a scanned : >copy of it would lend great weight to your case here. At the moment, : >you've offered us nothing in the way of evidence, which is one of the : >main reasons we all think you've truly gone fishing. So? : The letter was by email, not on paper. (In addition to snail-mailing, I : emailed all the relevant addresses I could find.) I'll see if I can find : it, I keep a record of most of this correspondence so I may still have it. I'm afraid I don't have a copy of the correspondence. In future I will keep useful letters, so with luck there may be a "next time". The MP was Jeff Rooker, Labour MP. Having looked again at the Labour web page I find he doesn't have an address listed, but I have a record of his address as having been jeff.rooker@geo2.poptel.org.uk. I don't know where I got the address from. I'm so disorganised! ==================================================================== Newsgroups: uk.misc,uk.politics,uk.media,uk.legal,alt.politics.british From: J.J.Smith@ftel.co.uk (John J Smith) Subject: Re: Persecution in the U.K. X-Nntp-Posting-Host: death-on-the-rock.ftel.co.uk Message-ID: <Dnw49L.D1H@ftel.co.uk> Sender: smid@death-on-the-rock.ftel.co.uk (RFC931) Organization: Fujitsu Telecommunications Europe Ltd References: <DnFtLs.E37.0.bloor@torfree.net> <DnrMsq.239.0.bloor@torfree.net> <Dnsrnu.Jr1.0.bloor@torfree.net> <DntKEo.86E.0.bloor@torfree.net> Date: Thu, 7 Mar 1996 09:12:56 GMT Lines: 54 In article <DntKEo.86E.0.bloor@torfree.net>, Mike Corley <bu765@torfree.net> wrote: >Mike Corley (bu765@torfree.net) wrote: >: >Do you happen to have a copy of this MPs letter? After all, a scanned >: >copy of it would lend great weight to your case here. At the moment, >: >you've offered us nothing in the way of evidence, which is one of the >: >main reasons we all think you've truly gone fishing. So? > >: The letter was by email, not on paper. (In addition to snail-mailing, I >: emailed all the relevant addresses I could find.) I'll see if I can find >: it, I keep a record of most of this correspondence so I may still have it. > >I'm afraid I don't have a copy of the correspondence. In future I will keep >useful letters, so with luck there may be a "next time". Don't believe you. Because that might be proof, and we just *cant* have that. >The MP was Jeff Rooker, Labour MP. Having looked again at the Labour web page I >find he doesn't have an address listed, but I have a record of his address as >having been jeff.rooker@geo2.poptel.org.uk. I don't know where I got the >address from. I'm so disorganised! I did Email this MP yesterday. This is what I wrote: Smid>I am sorry to bother you, but there is a person with a known Smid>personality disorder on the internet usenet, claiming that you Smid>as an MP have backed up his claims that he is being persecuted Smid>by MI5. Smid>His name is Mike Corely, and posts from canada (email address Smid>available if you require). Smid> Smid>He claims that you have told him that his claims that the Smid>"television is watching him", are justified, yet cannot find the Smid>email in which he did so.. Smid>I'd be interested in what you have said to him, because we have Smid>had a long term battle to convince him that he really is schizophrenic Smid>and that Chris Tarrent, MI5 and Martin Lewis from News On Ten are Smid>persecuting him... If you do have the original Email, then that'd Smid>be nice... Smid>If you nothing of this subject, it would not suprise me, however. His reply, surpise, suprise was: MP>No idea what you are on about. I am getting really sick of some of MP>the junk on E mail. I just dump it so he may have contacted MP>but as to an answer I 've better things to do. Your move, Mike. Smid 10164 Tag: What's changed in vba in Word 2007? Tag: 101784
  - 7
    - MI5 Persecution: Flight or fight 7/1/96 (8650) From: huge@axalotl.demon.co.uk (Hugh Davies) Newsgroups: uk.misc Subject: Re: persecution rant (re-post) Reply-To: huge@axalotl.demon.co.uk Date: Sun Jan 7 04:43:41 1996 Yo, Mike, Happy New Year! Haven't you killed yourself yet? In article <DKMIs5.158.0.bloor@torfree.net>, bu765@torfree.net (Mike Corley) wri >For anyone who hasn't yet read this, There is no-one in the known Universe who hasn't read this at least 5 times. >and really really wants to then here No-one wants to read it, Mike. It's drivel. >is the article that was posted last year in this newsgroup.... Over and over and over and over and over and over and over and over again.... -- Regards, Huge. ================================================== Subject: persecution rant (re-post) Newsgroups: uk.misc Organization: Toronto Free-Net Summary: Keywords: >Yo, Mike, Happy New Year! Haven't you killed yourself yet? But I can't, you see then I wouldn't know how things would turn out ("we're only doing this because we don't know how it's all going to end" - logic error in line 100) >There is no-one in the known Universe who hasn't read this at least 5 times. It doesn't seem to have done a whole lot of good since the good old persecution stuff is still going on. Over Christmas I was flying BA and got hassled by a couple of people on the flight (sounds like something you've heard before, doesn't it?). All the usual stuff about the town I'd been staying, "he doesn't know who we are", self-justification that we're doing it because he's a "nutter" etc. Real friendly like. Also a fairly obvious wind-up and attempt to get some reaction. I think they're trying quite hard to get a reaction. If I hit someone on a flight over the Atlantic, am I actually breaking any laws, and if so whose? Is a BA aircraft British territory subject to British laws while it's in mid-flight? It is really tempting to "reply" and that's obviously what they want, so who am I to refuse a blow to the head for people who ask for it so consistently? 8650 Tag: What's changed in vba in Word 2007? Tag: 101783
  - 8
    - MI5 Persecution: Dihydrocodeine 26/11/95 (7136) From: michaelm@easynet.co.uk (michaelm@easynet.co.uk) Newsgroups: uk.misc,uk.media,uk.politics,alt.politics.british,alt.radio.uk Subject: Re: Britain's Shame (repost) Date: Sun, 26 Nov 1995 09:19:13 GMT Organization: ------------ Lines: 89 Message-ID: <817374781.20251@michaelm.easynet.co.uk> References: <DIM34L.755.0.bloor@torfree.net> NNTP-Posting-Host: michaelm.easynet.co.uk X-NNTP-Posting-Host: michaelm.easynet.co.uk X-Newsreader: Forte Free Agent 1.0.82 bu765@torfree.net (Mike Corblymee) wrote: | In June 1990 a horrifying campaign of harassment was initiated in London by | what are believed to be elements of the security services. The harassment has | continued for over five years, starting from the broadcast and print media, | and encompassing abuse through set-up situations and by people in public | places. It has been brought to the attention of the police and they are aware | what is happening, but are not taking any action to prevent it. <whopping great snip of 884 lines> corley, you puzzle me! i've narrowed your possible motives down to one or more of the following: 1) you work on behalf of the british government with a hidden agenda of furthering the largely right wing (most to hide) censorship brigade's cause, "a drug-crazed psycho posting dangerous nonsense - how very very sad - but in the public interest,we must act." draft internet (censorship) bills rolling off hm govt's banders at this very moment, I don't doubt it! 2) you work for the daily mail which has started to feel the "internet pinch" as it suddenly clicks in the chronically adled minds of yet more and more of their readers - that shudder-inducing realisation that the entire editorial staff at the mail are scaremongering, imbecilic, blood-leeching , totalitarian twats - can any else sense a coordinated campaign on its way ??- "Mail urges (their) government to act - internet safety endangered by uncontrolled surfing lunatics - boys hands blown off by internet maniacs - net porn responsible for 392323rd rape " .net porn responsible for 392324th rape " .net porn responsible for 392325th rape " .net porn responsible for 392326th rape " .net porn responsible for 392327th rape " net porn responsible for 392328th rape " .net porn responsible for 392329th rape " <yawn> .net porn responsible for 392330th rape " .net porn responsible for 392331st rape " .net porn responsible for 392332nd rape " net porn responsible for 392333rd rape " <yawn> .net porn responsible for 392334th rape " .net porn responsible for 392335th rape " .net porn responsible for 392336th rape " .net porn responsible for 392337th rape " net porn responsible for 392338th rape " etcetera, straight from the old nag's mouth.. lee-potter (and english), take particular note.. (how ever you two common ********* managed to avoid encarceration for what was, quite evidently,wilful contempt of court in the regina v taylforth & knights case, is frankly beyond me.. those dreaded and now all too familiar words "endemic corruption" were muttered by at least one Q.C. >3) you (at least) believe there's (some) substance to your claim(s) and you >have a genuine axe to grind. If so, bloody well go for it, but scrape the >heavy layer of steaming dung off the top (that's assuming you're even >capable of distinguishing fantasy from reality.) 4) you (as an email address) are serving as some bizarre "educational" programme orchestrated by the psychiatric industry - ever keen to justify enforced electrical lobotomies, electroshock and dwugs .All poised for the echo? - "corley frigging well needs lobotomising" 5) you're just clinically insane with absolutely no comprehension or insight into the consequences you will possibly face as a result of repeatedly posting what, certainly on the face of it, looks like complete and utter bullshit. 6) you're some weirdo prankster(s) - probably a group of student psychiatrists having a cheap crack whilst high as kites on pilfered dihydrocodeine. 7) You are infact working for the ss yourself, gauging public awareness of the extent and methods of bugging - infinity transmitters, microwave surveillance devices, satellite tracking equipment, 'chipping' of black crims, say no more. 8) You're fuelling the central usenet administration committee, who, it is believed, are keen to see the introduction of a wide-reaching framework of self-created powers relating to posting cancellation. (see the 'son of RFC1036') my bet's on (5) - but just fuck off corley- irritate the lard-arsed canucks instead. The cia's financing of "professor" cameron's brain-washing experiments in montreal.. would be a good starting point ... or perhaps "professor" watts and his widely admired masterful double eye-jabbing trick - a couple of wallops with an icepick. such a waste of perfectly edible four year old hispanics !!!!.. Perhaps the old marylebone rd posse could fill us in with a few more facts on this one...?? You are all on the .net now ????? A very warm welcome :-) ... christmas rapidly approaching.. >business booming?? Do we all get a look in at flotation ??!! ====================================================== From: Gulliver <kst2co@herts.ac.uk> Newsgroups: uk.misc,uk.media,uk.politics,alt.politics.british,alt.radio.uk Subject: Re: Britain's Shame (repost) Date: Sun, 26 Nov 1995 18:25:32 +0000 Organization: University of Hertfordshire Lines: 12 Message-ID: <Pine.SUN.3.91.951126182156.16879B-100000@altair.herts.ac.uk> References: <DIM34L.755.0.bloor@torfree.net> <817343873snz@objmedia.demon.co.uk> NNTP-Posting-Host: altair.herts.ac.uk Mime-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII In-Reply-To: <817343873snz@objmedia.demon.co.uk> Actually, upon thinking about Mike's story it reminds me of someone I heard about who suffered from a persecution copmlex. He was an immigrant from some Eastern Bloc country who believed that 30 years after he emigrated the KGB were still after him. He would blame them if he had difficulty unlocking his car for instance (he reckoned they were putting something into the locks!). Something is very wrong, probably in Mike's head but what the hell, loonies make life more fun! -- Angus Gulliver ======================================================= Subject: Castrate the depraved MI5 buggers now Newsgroups: uk.misc Organization: Toronto Free-Net >Something is very wrong, probably in Mike's head but what the hell, >loonies make life more fun! Something is very wrong when the security services abandon their usual target of politicians and the well-known, to pursue the hitherto unknown nonentities such as myself. >corley, you puzzle me! Why? Because of my pathological truthfulness? >3) you (at least) believe there's (some) substance to your claim(s) and you >have a genuine axe to grind. If so, bloody well go for it, but scrape the >heavy layer of steaming dung off the top (that's assuming you're even >capable of distinguishing fantasy from reality.) Bloody well go for it I will. I think the "standard spiel" is quite studded with facts actually. There's plenty of "meat" there if the appropriate people can be motivated to get their act together and pursue the case. >my bet's on (5) - but just fuck off corley- irritate the lard-arsed canucks >instead. The cia's financing of "professor" cameron's brain-washing the lard-arsed canucks (?) are irritating me, but you don't want to hear about that >business booming?? Do we all get a look in at flotation ??!! 7136 Tag: What's changed in vba in Word 2007? Tag: 101782
  - 9
    - A content control like MS's citation, bibliography, TOC, etc.? In Word 2007, inserting a bibliography, citation or table of contents adds content controls that have features I'd like to use too. But I don't see how. Insert a bibliography or table of contents, click in it, and you'll see commands where the title would be. Add a citation, click in it, and you'll see a drop-down list in which the entries are commands. Is there a way for us to create such high-powered content controls, too? I didn't see documentation on how to add commands to content controls, so I thought I'd use Visual Studio to peek at those super controls and see what's going on. But the ContentControls collection doesn't see them. John Tag: What's changed in vba in Word 2007? Tag: 101781
  - 10
    - MI5 Persecution: A new Kafka? 3/10/95 (5622) Newsgroups: uk.misc,soc.culture.british,uk.media,uk.politics From: jackson@soldev.tti.com (Dick Jackson) Subject: Re: What it's like to be watched by the security services Message-ID: <1995Oct13.225312.6514@ttinews.tti.com> Sender: usenet@ttinews.tti.com (Usenet Admin) Nntp-Posting-Host: soldev Organization: Citicorp-TTI at Santa Monica (CA) by the Sea References: <DFy9tB.3JK.0.bloor@torfree.net> <813188298snz129.os2.7@blackcat.demon.co.uk> <DGE7uJ.8tF.0.bloor@torfree.net> Date: Fri, 13 Oct 1995 22:53:12 GMT Lines: 34 In article <DGE7uJ.8tF.0.bloor@torfree.net> bu765@torfree.net (Mike Corley) writes: > >Strangers in the street have recognized me on sight many times, and shown >awareness of the current thread of abuse. To give you one example, in 1992 >I was seriously ill, and a manager at work somewhat humouroursly said that >"it wasn't fair" that people were bullying me. A few days later, I >attended for the first time a clinic in London as an outpatient, and on my >way out was accosted by someone who asked if "they had paid my fare", with >emphasis on the word "fare". He repeated the word several times in this >different context; that they should have paid my "fare", each time >emphasising the word. > >For two and a half years from the time their harassment started until >November 1992 I refused to see a psychiatrist, because I reasoned that I >was not ill of my own action or fault, but through the stress caused by >harassment, and that a lessening of the illness would have to be >consequent to a removal of its immediate cause, in other words a cessation >of harassment. I also reasoned that since they were taunting me with jokes >about mental illness, if I were to seek treatment then the abusers would >think that they had "won" and been proved "right". <I've deleted a lot, but I think this gives the idea> I have so far not contributed to this tread, it has been unpleasant in my opinion. However, I was struck by the resemblance of the above passages to the writing of Franz Kafka. Viz. while from an objective viewpoint it seems to refer to a abnormal world, in a strange way it does resonate strongly at other levels. Mr. Corley, have you tried to write for publication? I honestly think it might lead somewhere positive. Dick Jackson (serious for a change and expecting to get beaten up) 5622 Tag: What's changed in vba in Word 2007? Tag: 101780
  - 11
    - MI5 Persecution: Do they fear truth? 3/10/95 (4108) From: flames@flames.cityscape.co.uk (Peter Krüger) Newsgroups: uk.misc,soc.culture.british,uk.politics,alt.politics.british Subject: Re: What it's like to be watched by the security services Date: 3 Oct 1995 15:38:20 GMT Organization: Steinkrug Publications Lines: 66 Message-ID: <44rldc$nrm@news.cityscape.co.uk> References: <DFus24.HxB.0.bloor@torfree.net> NNTP-Posting-Host: aa040.du.pipex.com X-Newsreader: WinVN 0.92.6+ In article <DFus24.HxB.0.bloor@torfree.net>, bu765@torfree.net (Mike Corley) says: > >It completely mystifies me how it can be done. One night in June 1992 I >was in a bed-and-breakfast in Oxford (some hard facts now, you?ll be >bored of the generalisations). I booked the B&B from the office phone. >So if they had the office bugged, or the phone system bugged, they could >have heard the call. If it was as late as 1992 then there was already a system available to feed digital video out of a domestic TV via the mains. Each raster of video was preceded by a sixteen bit address which identified the television set. All that was needed was a decoder box plugged into the mains somewhere between your room and the grid transformer. The signal was decoded and then fed down to the phone line. They probably even had a PC which enabled them to see the picture as well. By 1992 the technology had moved on from slowscan to near real time video with the advent of devices from Brooktree and Harris etc. >the newsreader reacted. Breathed deeply, as if in psychological relief. Maybe, or perhaps as if in:- sci.psychology.announce sci.psychology.consciousness sci.psychology.journals.psyche sci.psychology.journals.psycoloquy sci.psychology.misc sci.psychology.personality sci.psychology.psychotherapy sci.psychology.research sci.psychology.theory >I can't describe to you what goes through your mind when you know >someone on TV is "seeing" you the viewer. You?re doing OK so far. >Your instinct is to switch the TV off, to change channel, Not much point unless you switch off the TV at the mains >like an ostrich, Looks like Ostrich farming is going to catch on in the UK as you may have seen in some of the other uk newsgroups >The one time I did directly ask someone in the company who knew what was >going on, first he spewed wool about, "well we have to think what is >reality and what is proof anyway", then went into barefaced denial liar >mode. It opens your eyes, if they can't say out loud what they keep >saying in a disguised fashion, they must fear exposure, they must fear >the truth. wool_ barefaced_ denial_ liar_ eyes_ fashion_ fear_ exposure, How is your mother these days Mike? And BTW - How is the thesis coming along? Peter Kruger ------------------------------------------------------------ http://www.gold.net/flames/ flames@flames.cityscape.co.uk 4108 Tag: What's changed in vba in Word 2007? Tag: 101779
  - 12
    - MI5 Persecution: Grievous Bodily Harm 2/10/95 (2594) From: jeibisch@revolver.demon.co.uk (James Eibisch) Newsgroups: uk.misc,soc.culture.british,uk.politics,uk.media,rec.arts.tv.uk.misc Subject: Re: Auntie gets it in the emails Reply-To: jeibisch@revolver.demon.co.uk Date: Mon Oct 2 19:44:19 1995 lig0007@queens-belfast.ac.uk (TOM OATES) wrote: >However, I'm pleased to say that, in the past couple of days, Mike Corley has >stopped doing it and he appears (I say this cautiously) to be acting more >reasonably. True, his postings are still based on paranoid delusions. >However, so long as he doesn't go back to his old practices of multiple, >identical, unreadable postings, I'm sure that most people on this newsgroup >are willing to put up with him. Time to come out of the woodwork of this thread (or variations thereof)... I find it annoying that discussion of Mike's situation is spread over multiple threads - it makes it hard to follow, and especially to follow up. If it could be consolidated into one thread on relevant newsgroups (I'm reading this on uk.media btw). I'm a little surprised with the volume of abuse Mike has received, but believe strongly in freedom of speech if such a thing were to exist, which clearly includes abuse as much as anything. One thing which has been missing from this discussion is this simple prognosis: that maybe Mike is right and that, despite his admitted mental condition, there really is a campaign against him organised by now-influential ex-students of his university. Does anyone remember the TV series GBH, a fictional account of security service and governmental power games? Fictional, certainly, but one of the most powerful pieces of TV drama I've seen in many years, fascinating and quite believable, even. The fact is, as Mike has pointed out (oh, so many times :-), that the security services _do_ have the influence, contacts, resources, and time to conduct such a campaign of surveillance and even psychological terror if they so chose. If they have this power, then they will surely use it We still don't have all the facts from Mike, and the most pertinent here I think would be about his time at university - the people who took against him, the ringleaders. We need to know far more about Mike: his political and social affiliations, put in context with his univeristy years, the enemies he made, the reasons people ganged up on him at the very early stages. I don't subscribe to conspiracy theories generally, but I know there is far more that goes on in the universities, old boy's clubs, civil and secret services and Parliament than is ever made public. Mike, I leave it to you to construct a _single_ thread in a relevant newsgroup about this topic and keep to this thread to give us new information and answer questions about your situation. Ignore the 'Mike Corley is a nutter' posts unless they are relevant. Give us more detail. Who knows? It may be true, stranger things have happened. _ James Eibisch ('v') N : E : T : A : D : E : L : I : C : A Reading, U.K. (,_,) http://metro.turnpike.net/J/jeibisch/ ======= ------------------------------- Tue, 03 Oct 1995 04:01:34 uk.misc Thread 3 of 14 Lines 58 Re: Auntie gets it in the emails Respno 16 of 16 J.J.Smith@ftel.co.uk John J Smith at Fujitsu Telecommunications Europe Ltd In article <812677261.12841@revolver.demon.co.uk>, James Eibisch <jeibisch@revolver.demon.co.uk> wrote: >lig0007@queens-belfast.ac.uk (TOM OATES) wrote: >One thing which has been missing from this discussion is this simple >prognosis: that maybe Mike is right and that, despite his admitted >mental condition, there really is a campaign against him organised by >now-influential ex-students of his university. We're trying to find this out on uk.misc. He's posted some *new* *huge* replies (which I'd have to give up my day job to reply to), detailing some things like: a) Mike Corley is *not* his real name b) Exactly what the "abuse" is (it seems be such things, as taking completely unrelated newspaper articles, striving to make them a disgusting insult, then redirecting against himself). c) How he came to the conclusion. I think he's doing rather better nowadays.. >Does anyone remember the TV series GBH, a fictional account of security >service and governmental power games? Fictional, certainly, but one of >the most powerful pieces of TV drama I've seen in many years, >fascinating and quite believable, even. This would be a point, apart from the fact that this was directed against someone of political importance. I don't believe Mike is... >The fact is, as Mike has pointed out (oh, so many times :-), that the >security services _do_ have the influence, contacts, resources, and time >to conduct such a campaign of surveillance and even psychological terror >if they so chose. If they have this power, then they will surely use it >at some point against some people. It appears he has formed the Security Service conclusion, because they are the only ones capable of doing it. A "searching for an enemy capable of it". >We still don't have all the facts from Mike, and the most pertinent here >I think would be about his time at university - the people who took >against him, the ringleaders. We need to know far more about Mike: his >political and social affiliations, put in context with his univeristy >years, the enemies he made, the reasons people ganged up on him at the >very early stages. I'm beginning to think that we never will get all the facts from Mike. We may, however, get enough... >Mike, I leave it to you to construct a _single_ thread in a relevant >newsgroup about this topic and keep to this thread to give us new >information and answer questions about your situation. Ignore the 'Mike >Corley is a nutter' posts unless they are relevant. Uk.misc, me boy... Smid ========================================================== From: flames@flames.cityscape.co.uk (Peter Kr|ger) Newsgroups: uk.misc,soc.culture.british,uk.media,uk.politics,alt.politics.british,alt.conspiracy Subject: Re: What it's like to be watched by the security services Date: Tue Oct 3 15:41:54 1995 In article <44rrrh$t6v@news.ox.ac.uk>, idaniel@jesus.ox.ac.uk (Illtud Daniel) says: > >And what do you mean when you state that the symptoms are too >'textbook'? Are the textbooks wrong? I think what is meant by 'textbook' is that some of the symptoms of 'illness' displayed in the posts seem to have been lifted from textbooks describing mental instability and personality disorders. I must admit I haven't seen Mike's postings before has he only just started posting again? Peter Kruger ------------------------------------------------------------ http://www.gold.net/flames/ flames@flames.cityscape.co.uk 2594 Tag: What's changed in vba in Word 2007? Tag: 101778
  - 13
    - MI5 Persecution: Goldfish and Piranha 29/9/95 (1080) I just thought I'd let you know what I've been reading into the "Crusader" spam. I don't want to post this to usenet because somebody might try to tie that in to my posts in some way (someone already has, in uk.misc). First of all, I'd like to ask you to believe that my phone line in my apartment is bugged, and has been for many months. I have moved a couple of times this year, but "they" have faithfully been on my trail. Anyway, let's suppose my phone line is bugged. Now, when I talk to my internet service provider, it's over a SLIP (now PPP) connection. So if you wanted to bug what was said, either you'd listen in over the line and have to decode the transmission, or you could go to the service provider (more difficult) and ask them to decode a particular user's connection. OK, so now they're listening to everything I do over my SLIP/PPP connection. A couple of months ago I was messing around with faking articles through nntp servers and through anonymous remailers. I chose a nice inconspicuous newsgroup for my little tests, something no-one would ever notice. Guess which newsgroup I chose??? Yes, _FISH_!!! or rec.aquaria to be precise And guess what articles I tried to post? Goldfish, Koi carp and, you'll never guess... PIRANHA!!! The goldfish article and the Koi went through, but the piranha didn';t appear. by now you probably think this is too silly for words. But if you look in the papers a few eeks ago you will find John Major, Tonny Blair and Paddy Ashdown sharing a "private joke" about Major's sunburnt goldfish. We haven't had anything about Koi yet (they must be too dull ). Now, sent by someone who clearly knew what they were doing (they chose an Italian backbone site for their launch point) we have many thousands of messages to people all over the globe. All about piranha, and with the punchline "that gives you something to think about, doesn't it?" The way it works is that they're trying to kill two birds with one stone again. I don't knoiw why they should be against these national alliance people, but my interpretation is that they simultaneously try to discredit them, and stem the flow of Corley articles. ================================================================= In article <DFnE55.8tF.0.bloor@torfree.net>, Mike Corley <bu765@torfree.net> wrote: > >John J Smith (J.J.Smith@ftel.co.uk) wrote: > >: b) we do know who you are. Or are you someone else we don't know about? >: You are currently known as "That bloody persistant net nutter, who's >: expanding from uk.misc to the rest of the world". > >I think the point I was trying to make is that I could tell you things >from my personal life, at home and at work, which would add credibility >to my story. But if I named people, then (a) they would object violently >to being included in this shenanigans, and (b) I would be revealing my >identity which would be bad for my personal life and my work life. Of >course some people in my personal life, and at work, do know who "mike >corley" is. But at least we're observing a studied silence for now. :People can always be called "MR X", to save them being named. : :I'm completely perplexed as to what you mean by b). Revealing identity? :To who? And why would this be bad for any part of your life when you :already have a less than respectful reputation here? I'll just enumerate one or two things that I can still remember. Sometime around August/Sept 1992 I was living in a house in Oxford, and coming out of the house was physically attacked by someone - not punched, just grabbed by the coat, with some verbals thrown in for good measure. That was something the people at work shouldn't have known about... but soon after a couple of people were talking right in front of me about, "yeah, I heard he was attacked". Again, one I went for a walk in some woods outside Oxford. The next day, at work, someone said "you know he went to the forest yesterday". I don't want to put details on usenet of what happened because to do so would be to risk it happening again. If you put ideas in peoples' heads then you can find them reflecting back at you, and I don't want that. Also I can't remember that much from three years ago. From november 1992 I started taking "major tranquilizers" and just blotted the whole thing from my mind. >This is a feature time and time again, that the security services >(presumed) get at you by manipulating other people around you to get at >you. If you have their contacts, manpower, resources and technology then >you can do that sort of thing. :But why? Are you a threat? They pretend they "have" to get at me. After the first few weeks they had to find a reason to spy and abuse. You can't abuse someone unless they're in the wrong in some way. What I did "wrong" was to be ill. So it became "nutter" and "monster" and "he's going to attack us" coupled with "ha ha ha, he can't do anything to defend himself, it was so funny". That obvious contradiction within their propaganda is something they blithely ignore. :So, the Security Services never *actually* appear, and you assume that :they get someone else to do your dirty work. This is a bit of a big :logical step, here: That person doesn't like me, or is causing me trouble, :it's not because they've got problems themselves, it must be the "Security :Services". Yes. Because people are infallible. Or is there more? A single source is indicated because of the range of harassment. BBC + Capital + manipulated_public_at_large + set_up_situations, what does that add up to? Add in the technology to carry out the covert spying and the manpower and knowhow to follow you around for five years without being spotted. It smells very much of the security services, because there is no other organization (to my knowledge) which does the things I've seen these people do. Remember, they have deliberately chosen the softest of soft targets to victimize. They purposely chose a mentally ill person who they thought would be likely to kill himself anyway, so that they could get away with murder. And in all likelihood it will have started as a personal vendetta by someone. Who could that be? I don't know, but I can give you some clues. The first possibility (deep breath) is that someone from my college set me up. Six years ago I graduated from university in the UK, during the last year there I was steadily getting more and more ill. I know that I was talking in my sleep; although I don't know what I was saying, it got me a reputation, and if someone from my college talked afterwards to the "wrong" people then that could be the reason for all that has followed. I think that's the strongest contender for source. Directly beneath my room lived another bloke who frequently had his friends round late at night, after the time that I went to sleep. So they could have heard what I was saying in my sleep, and that could have got me the reputation for "talking to myself". What I don't know is why that should have rebounded a year after I left. You'd think it would have happened sooner; it's a bit odd to wait for a year and then start abuse. That leads me to question what in particular happened around May/June 1990 for them to start then. >What I don't know is how it looks from the other side, from the side of >the people who are being manipulated to get at me. On a couple of >occasions I have challenged people to tell the truth of the matter, but >they have alwats ducked the challenge. :Have you ever considered the possibility, that you have made a mistake, and :the people don't know what you are talking about? Yes. I am currently considering the possibility that some people around me know only what is being posted on Usenet, and have not been "contacted" by "them". But I _know_ that others have been contacted. :What words? Are they in common use? Could they be a catchphrase of a :popular comedian?: "Nice to see you, to see you nice"? In England the all-time No. 1 is "nutter". Easter this year, returning home from Clapham police station to report five years of harassment ("we're not saying it's happening and we're not saying it isn't happening"), another "not happening" incident of harassment when a cowardly little slut did her country proud by yelling "nutter, nutter, nutter" in the face of the hated enemy. What can you do about that? You can't yell abuse back in their face, because they know they're supported by their peers, by the media, by the murderers in the security forces. You can't put them down when the fascist establishment is on their side. You can't hit them, because they would deny their abuse, they would deny knowing anything, and bring charges against the "nutter" who attacked them "at random". >You know, you're >passing saomeone, they're hardly going to construct an argument for your >benefit, so they work a word of abuse into the conversation which they >can giggle at. :Abuse such as what? We're all adults here, we can take it. Is this abuse :aimed at you? How can you tell it is? I think I've said already what the words are. Thing is, at any given time the language is consistent. In January everyone's calling you X, then a few weeks later people stop calling you X and start calling you Y. You can tell it's aimed at me, because when people repeatedly say the same words are you walk past, then laugh, you would have to be hard of understanding not to recognize it. >Or they repeat something that's been said somewhere else... the PE thing >being a case in point. PE says it, then other people pick up the refrain. :Remind me who PE is again. PE = "Private Eye" >: >To give you an example, which I mentioned in another posting. In around >: >October 1992, Private Eye ran a cover with the heading "Major's support >: >lowest ever", with John calling to Norma on the cover "come back, Norma". >: >Only one obvious interpretation to that, isn';;t there? I certainly >: >thought so when I saw that cover. Wrongo!! Down the pub with people from work >: >Simon says to phil, "don';t you think it's wrong then?" phil says, "well >: >private eye are usuallyright"..."hislop strikes again.. > >: Erm. Mike? Heeeelllllooo? What are you on about. What is the other >: interpretation then? Norma having an affair? Seems a bit wrong, with the >: heading "Majors support Lowest ever"... > >No, this one isn't obvious , it really does need to be explained. I >certainly didn't understand it when I first saw it. You see, the kernel >of vitriol is in the words "come back". At the time, the themes of >abuse were centred around interpretations of those two words (stretch your >mind a little bit, I don't have to spell it out for you, surely). :You did in your mail item. : :You seem to be scouting about something called a "Double Entendre". The :inference being "Come" = Ejaculation, "Back" = Anus (not the first part :of the body I would have went for, I would have foolishly gone for "Back", :silly old me). : :You see to have picked a sodomy double entendre out of a Private Eye :headline. They are everywhere. The English language has much double :meaning in it, and if you put your mind to it, you could pull a double :entendre out of a randomly chosen page of the bible. So what? >The point is that when Simon pointed it out to Phil, he did recognise >what it meant after a moment's thought... and so did I... and so did the >people who repeated it several times later... so however murky it may >seem to you, that is the meaning they intended it to have... I still don't really know if the meaning was intended when that headline was written, or if it was simply "found" after the fact. The reason I think it might be the former is that I got quite a lot of abuse along the lines of "sound-alike" or "double-entendre" at work, in particularly from Steve. So "double" inevitably came to mean split-personality, "two people in one"; "back" inevitably came to mean "backside", "come" inevitably meant you-know- what, "split" (well, we'd better split now) again you can guess, "bent" (of a similar bent), the list goes on forever. These aren't "nice" double- entendres intended for comedy, they're nasty words to humiliate and cause pain. If I could turn the clock back three years then I would sue my former employers for harassment and I would almost certainly win. I had to take pills after a year of Oxford, so they wouldn't be able to lie their way out of it. Actually, I could still take them to court - the main obstacle being that three years after the fact is a bit late and much of what happened, the details that would be necessary for a case to go to court, has just been obliterated by time. : Smid ============================================== From: flames@flames.cityscape.co.uk (Peter Kr|ger) Newsgroups: uk.misc,soc.culture.british,alt.conspiracy,uk.media,uk.legal Subject: Re: Mike Corley - a (helpful) suggestion Date: Mon Oct 2 05:43:42 1995 In article <812551172snz@objmedia.demon.co.uk>, Snail <snail@objmedia.demon.co.uk> says: >Indeed, I feel that my Usenet access is censored simply because I don't want >to download groups he is partaking in, because of his behaviour. > >I wasn't that bothered, but I am starting to get seriously pissed off >with him. Which takes a lot. Hi Snail This person Corley seems quite interesting for three reasons. I put the following at the end of a post in another thread just to see if he was reading any other threads in uk.media. It seems he is probably not. ----------------------------------------------------------------------- Heres an interesting little story from back in the early days of CCD technology. There was this miniature camera which was designed to fit behind the infrared receiver lens of the remote control system (just beside the IR sensor itself) the camera clocked out the data in 256 lines of 256 pixels from a Fairchild chip and fed it out, a line at a time, into the VBI within the TV set itself. The signal could be picked up remotely from a standard license detector van from where it was stripped out of the surrounding RF signal and relayed back to the TV station where it was displayed as a slowscan monochrome image in a corner of the news readers monitor. 1080 Tag: What's changed in vba in Word 2007? Tag: 101777
  - 14
    - Print 2 Separate Documents Duplex Is there a way to send to separate one page documents to a duplexing printer, and send some kind of code so the printer knows to print the second single page document on the back side of the paper? Tag: What's changed in vba in Word 2007? Tag: 101774
  - 15
    - controling a never ending loop code Hi, I have code that I want to put into a loop. In essence, this loop could be never ending (and that is what I want to actually happen). However in reallity I want to be able to stop and start the loop at will. So really i think I need a non-modal form with 2 buttons (stop and start). Now doing the start button is easy, but what code would I need in the stop button to stop the 'start' code from running? Hope that makes sense and thanks for any help/pointers. Steve. Tag: What's changed in vba in Word 2007? Tag: 101770
  - 16
    - InsertFile (include text) or AddFromFile (master) We need to print and send some standard information with each proposal that we send out. So our people open the proposal, print it, then open the information document, print that out, then possibly a third document, and print that out. I'd like to set up a template so they open a blank document, just click a button that says "Include file" that runs a macro that lets them select each file, then links it to the document. If I use InsertFile, I lose the formatting. I can't change all the source documents to have a section break at the beginning. I thought of using Master Documents (ONLY FOR PRINTING!), figured I would use AddFromFile method with READONLY = TRUE to protect the included documents. But setting READONLY = true doesn't seem to protect the documents from being modified, so I'm afraid it won't keep them from getting corrupted. I don't really care what happens to the master document as long as the source documents stay safe. Any idea? Or should I just give up? Tag: What's changed in vba in Word 2007? Tag: 101765
  - 17
    - dropdown list in Word 2000 Is there a limit to the number of items that can be listed in a dropdown list; can a Word dropdown list be created from an Excel list? Tag: What's changed in vba in Word 2007? Tag: 101761
  - 18
    - Reason for not including images in .rtf I am trying to display some HTML body in a richtextbox. Therefor I convert the *.html file to *.rtf using the wordobject ------------------------------------------------------------------------------ 'body html is a plain html file 'savertf is the path & file to save to Dim savertf As String = sLocalpath & lbl_ourref.Text & ".rtf" Dim objWord As New Word.Application With objWord .DisplayAlerts = Word.WdAlertLevel.wdAlertsNone .Documents.Open(Bodyhtml) 'savehtm) .ActiveDocument.SaveAs(savertf, 6) .ActiveDocument.Close() .Quit() end with --------------------------------------------------------------------------------- I've noticed that when using Word(2003) to save .html as .rtf-file Word sometimes includes the images in the .rtf-file, but other times it does not. I've tested this with 'www.google.com' (images are included) and 'www.forkyou.nl' (images are not included) The actions taken are identical in Word('Open File'--'Save File As (RTF)' Does anyone know the reason why this difference occurs, or a way to always include the images in the RTF?? Tag: What's changed in vba in Word 2007? Tag: 101747
  - 19
    - Find out which type of footer is used on the current page in a given section Hi all, I am writing some code that places a picture in a document. This works perfect. I only have one question. I am setting the width of the picture to a fixed number. Then I want to check if the hight of this picture still fits on the current page. If it doesn't, I need to calculate the maximum possible height and change the width accordingly. I know I can use the Information(wdVerticalPositionRelativeToPage) to find out on what the top position is of my picture relative to the top of the page. This document has multiple sections with different for primary - and first pages. Some footers have a style with spacebefore to make the space on the page smaller then other pages. Therefor I can't just use the bottom margin of the current section. I need something like the vertical position of the selection relative to the bottom of the page but AFAIK there's no property to get this info. I can find out on which section I am working with the information property but I can't seem to figure out on which sectionpage I am working. I need this in order to find out how much space is available on the current page (pageheight - (top margin + bottom margin + space before on current footer)). Does anybody have a clue on how to solve this or perhaps a suggestion for another technique that may lead to the same results? TIA, Renate Tag: What's changed in vba in Word 2007? Tag: 101746
  - 20
    - Filling a protected form I have a protected form that I wish to fill in using VBA but I keep get the message that I am trying to type into a protected area. I can manually type text into this form so why can't I do the same in VBA When I record a macro as I type into the form I get something like Sub Macro2() ' ' Macro2 Macro ' Macro recorded 22/06/07 by Fred Schreuder ' Windows(1).Activate Selection.TypeText Text:="Consignee" Windows(2).Activate End Sub but if I then try to run the macro I get an error about a protect area. I am not trying to bypass any protection I just want to be able to automatically fillin the form as I would do when I type in the data. Can some please tell me if this is possible with trying to unprotect the document. thanks Fred Tag: What's changed in vba in Word 2007? Tag: 101742
  - 21
    - Multiple text selection in Word Hi everyone! I have a small problem; please help me to solve it if somebody knows. I have to find and select all occurrences of any string in Word document. I'm working with Word document by OLE. The sample code is : If (oWord_FoundRange.Find.Execute("Any string", , , , , , True)) Then oWord_FoundRange.Select End If oWord_Document.Activate But it selects only the first occurrence of searching string. I have to highlight all occurrences. In addition, I have not to change the document, colors etc. On other words, I have to simulate the same behavior like check box of the Word 2003 of the Find window "Select all elements, found in". Please, help me! Thanks! Igor. Tag: What's changed in vba in Word 2007? Tag: 101741
  - 22
    - Bizarre table behaviour - can you explain? Hi, This is Word 2002... but I'd be surprised if it was unique to Word 2002... Fed up with the DocumentMap not handling tables, I wrote my own outliner that selectively shows and hides rows... worked a treat. Then I discovered I needed some extra columns - but I've no screen estate left, so I thought why not use a similar trick to show/hide one of a pair of columns (well, alternate between v. small and "normal" width :) Works OK BUT... I only need one column of the pair at a time, so I set up a double-click show/hide routine. First, I hide a column by setting the font to hidden and then setting the width to something small, then I show the other column by first setting the width to "normal" AND ONLY THEN un-setting the font hidden attribute. ***** THE WEiRD BIT ****** What is weird is that when a previously "hidden" column is shown the text ALWAYS appears in the "narrow" column (thereby causing the row height to go crazy) even though I set the width first, before I unhide the text (it does sort itself out a moment later, but it's hell on the eyes and it takes time...) Turning off screenupdating for the duration doesn't help, and no amount of extra DoEvents calls or explicit repaginates will stop it... (all desperate measures I admit...). WHY? More to the point, can I stop it? Thanks Julian PS I have just "purged" the template and reimported all modules, so I'm confident there are no lurking corruptions... Here's the code that does the business... Sub toggleColumns(ByRef selDoc As Document, ByRef selCell As Cell) Dim aCol As Column Dim aCell As Cell Application.ScreenUpdating = False Set aCol = selCell.Range.Columns(1) showHideColumn aCol:=aCol, show:=False ' First hide a column If selCell.ColumnIndex = scratchColIdx Then Set aCol = selCell.Range.Rows(1).Cells(structureColIdx).Column ElseIf selCell.ColumnIndex = structureColIdx Then Set aCol = selCell.Range.Rows(1).Cells(scratchColIdx).Column End If showHideColumn aCol:=aCol, show:=True ' then show the other one Application.ScreenUpdating = True End Sub Sub showHideColumn(ByRef aCol As Column, ByVal show As Boolean) Dim aCell As Cell Dim oldSel As Range If aCol Is Nothing Then Exit Sub Set oldSel = Selection.Range aCol.PreferredWidthType = wdPreferredWidthPoints Select Case show Case True aCol.Select aCol.PreferredWidth = InchesToPoints(3.01) Selection.Font.Hidden = False Case False aCol.Select Selection.Font.Hidden = True aCol.PreferredWidth = InchesToPoints(0.01) End Select oldSel.Select End Sub Tag: What's changed in vba in Word 2007? Tag: 101736
  - 23
    - Automate bookmark naming of formfields I have a macro that adds a row (with formfields) to a 3 column table. Is there a way I can take care of the naming convention for the formfields? Eg. When the macro is used the first time....the first row is inserted with 3 formfields - Column1 formfield would have a bookmark name: text1 Column2 formfield would have a bookmark name: text2 Column3 formfield would have a bookmark name: text3.... If the macro is used again...the second row is inserted with 3 formfields - Column1 formfield would have a bookmark name: text4 Column2 formfield would have a bookmark name: text5 Column3 formfield would have a bookmark name: text6....and so on... All help is appreciated! Tag: What's changed in vba in Word 2007? Tag: 101731
  - 24
    - printing VB macros Is there any way (i.e., a macro or builtin) to print all the macros in a VB project? Or to copy them to a Word file? (Particularly where there are many modules and itâ??s a bit of a pain to copy and paste all the modules into Word manually.) Iâ??m using Word 2003 at the office, but Word 97 at home. Tag: What's changed in vba in Word 2007? Tag: 101729
  - 25
    - Converting numbered list to text How can I convert the numbers in a numbered list to text by code? I can't use copy and paste as text because I can't lose the format of the text. Tag: What's changed in vba in Word 2007? Tag: 101726
- Next
  - 1
    - Not able to jump to bookmark Hello ! I want to generate an automated invoice in Word with data from Access. VBA in Access triggers the function, calls Word and should jump to certain bookmarks and enter text. (please see the code fragments below) Jumping to bookmarks works perfectly well in Word and with Word macros. But calling the code from Access returns several errors when trying to jump to a bookmark. Everything else (entering text, etc.) works ! The errors tell me "Runtime error 5102" and "Runtime error 5101". Would be great if anyone could help me with this issue ! Thanks in advance ! Best, Konstantin Here is the code: (it's not finished yet !) Sub CreateInvoice(company_id As Integer, date_start As Date, date_end As Date) Dim db As Database Dim wdobj As Object Dim rst As Recordset Dim sqlCompanyAddress As String Set db = CurrentDb() Set wdobj = CreateObject("word.application") With wdobj .Visible = True .Documents.Add Template:="C:\Templates\Invoice.dot", _ NewTemplate:=False, DocumentType:=0 sqlCompanyAddress = "SELECT " & _ "tblCompany.Company, tblAddress.Department, tblAddress.Street, " & _ "tblAddress.PostCode, tblAddress.City, tblCountry.Name " & _ "FROM tblCountry INNER JOIN " & _ "(tblCompany INNER JOIN tblAddress ON tblCompany.ID = tblAddress.Company_ID) " & _ "ON tblCountry.ID = tblAddress.Country_ID " & _ "WHERE (((tblAddress.BillingAddress)=True))" Set rst = db.OpenRecordset(sqlCompanyAddress) .selection.Goto What:=wdGoToBookmark, Name:="address" .selection.TypeText rst!company & Chr(13) & rst!Department & Chr(13) & rst!Street & _ Chr(13) & Chr(13) & rst!PostCode & " " & rst!City If rst!Name <> "Deutschland" Then .selection.TypeText = Chr(13) & rst!Name End If End With End Sub Tag: What's changed in vba in Word 2007? Tag: 101724
  - 2
    - Problems unprotecting template, running a macro and reprotecting Good morning, I have a template that contains 3 macro buttons. I have the template password protected but I would still like users to be able to use the macro buttons. I keep running into two problems: 1. The macro buttons do not work at all when the template is password protected 2. If I protect the form and then save it and reopen it the macro buttons again do not work. But if I reopen the document and then reprotect it (with out a password) the macros work fine. Here are the macros I am trying to run: A) Option Explicit Sub add_page() If ActiveDocument.ProtectionType <> wdNoProtection Then ActiveDocument.Unprotect Password:="summer" End If Selection.EndKey Unit:=wdStory ActiveDocument.AttachedTemplate.AutoTextEntries("AddTable").Insert _ Where:=Selection.Range, RichText:=True ActiveDocument.Fields.Update ActiveDocument.Protect Type:=wdAllowOnlyFormFields, _ NoReset:=True ActiveDocument.Bookmarks("Notes2").Range.Fields(1).Result.Select End Sub B) Sub Information() If ActiveDocument.ProtectionType <> wdNoProtection Then ActiveDocument.Unprotect Password:="summer" End If frmInformation.Show If ActiveDocument.ProtectionType = wdNoProtection Then ActiveDocument.Protect Type:=wdAllowOnlyFormFields, _ NoReset:=True End If End Sub C) Sub FormsSpellCheck() ' If document is protected, Unprotect it. If ActiveDocument.ProtectionType <> wdNoProtection Then ActiveDocument.Unprotect Password:="summer" End If ' Set the language for the document. Selection.WholeStory Selection.LanguageID = wdEnglishUS Selection.NoProofing = False ' Perform Spelling/Grammar check. If Options.CheckGrammarWithSpelling = True Then ActiveDocument.CheckGrammar Else ActiveDocument.CheckSpelling End If ' ReProtect the document. If ActiveDocument.ProtectionType = wdNoProtection Then ActiveDocument.Protect Type:=wdAllowOnlyFormFields, _ NoReset:=True End If End Sub Any guidance would be greatly appreciated! Warm Regards, SMOO Tag: What's changed in vba in Word 2007? Tag: 101721
  - 3
    - Timer Control for Word VBA I would like to add a timer control to my Word Macros... similar to the Timer Control in VB6. Is there a control available for Word VBA? And if so... what is the reference or component that needs to be added? Thanks Tag: What's changed in vba in Word 2007? Tag: 101719
  - 4
    - TextBox.Value Format Hi, I have a textbox (txtPhone) that I want to have the end user enter the phone number into. What I want to do is have the 10 numbers display back to the user like: ###-###-#### or (###) ###-#### or ###.###.#### (which I can do, no problem) ... My problem is, if the user goes back to modify the number on the form before they hit "continue" I can NOT get the 10 numbers to be stored again by themselves. If I do myphone = Val(txt.Phone.value) myphone = "0" ... how do I get the txtPhone.Value to be stored as ########## and display as something else (similar to a mask). Here is my code: If Not IsNumeric(txtPhone.Text) Then If txtPhone.Text = "" Then Exit Sub Else MsgBox ("Please type numbers only") txtPhone.Text = "" cancel = True End If ElseIf txtPhone.Text = "" Then 'txtPhone = "###-###-####" Then txtPhone.Text = "" ElseIf txtPhone.TextLength <> 10 Then MsgBox ("Phone Numbers should be 10 digits") cancel = True Else txtPhone.Text = Right(Format(txtPhone.Text, "(###) ### ####"), 15) End If Thanks, Elaine Tag: What's changed in vba in Word 2007? Tag: 101713
  - 5
    - RoutingSlip Object and ActiveDocument.HasRoutingSlip In Word 2007 these are listed as hidden. What is the replacement for these objects and properties? What is the replacement for these or is there a way to still access these members? -- Dave B Tag: What's changed in vba in Word 2007? Tag: 101711
  - 6
    - how to disable track change Hi everyone, We have a very large template with many customized toolbars and functions. Sometimes users turn on the track change which creates a lot of problem in the template. My question is how can I disable track change command in reviewing toolbar , in tool menu and also on the buttom of the page ( grayed out TRK ). Thank you so much for any help :) Tag: What's changed in vba in Word 2007? Tag: 101705
  - 7
    - search macro hi i want a macro that when run i can give a sritng to search the nacro will fund the strung and after will contunue best regards nyydo Tag: What's changed in vba in Word 2007? Tag: 101704
  - 8
    - Limitation of size or number of procedures in dot-file ? Hi NG I'm using XP/Word 2003 and working on a project, in which a dot-file is growing up to 3.6 mb now. After inspection of former subs, it seems, that some changes are not made. My question is, is there a limitation in size or numbers of procedures in a dot-file ? best greets Tag: What's changed in vba in Word 2007? Tag: 101692
  - 9
    - Library Not Registered Hi, I am working office automation application and in machine i have Office 2007. While running my application i got the following error messages Error 1: Library not registered. (Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED)) Error 2: Word could not fire the event Both are sporadic. Can anybody give some idea why these error messages i am getting? Note : I installed PIA in my machine Thanks Vijay Tag: What's changed in vba in Word 2007? Tag: 101686
  - 10
    - Is there a practical limit to how many characters in a string variable? I've got the Word 2000 Developer's Handbook. It says a string variable can hold up to 2 billion characters. Looking at a document I've got now, that translates into about 4400 pages like this one. But is that a _practical_ limit? Will I crash and burn if I begin to approach a certain percentage of that size? Or can I take it right up to 1.99 billion with no issues? Ed Tag: What's changed in vba in Word 2007? Tag: 101685
  - 11
    - Tray 3 not recognized in HP color Laserjet 4700 We were having HP color Laserjet 4600 before. We have a custom code written in VBA within GreatPlains (Dynamics Version 9.0) to launch Crystal Reports which uses Crystal Viewer control. When the users click a button on Sales Screen to print an invoice, it gives a drop down with values 'Prelimanary', 'Final'. When the user picks 'Prelimanary' the report has to print to the default tray (TRAY 2). When the user picks 'Final' it has to print from 'TRAY 3'. The code used says If frmTray.strValue = "Preliminary" Then 'Tray 2 CRReport.PaperSource = 2 Else 'Tray 3 CRReport.PaperSource = 11 End If This code used to work perfectly with HP Color Laserjet 4600 with PCL 5 driver. Now we just changed the printer to HP Color Laserject 4700 with PCL 5 driver. Suddenly it stopped functioning. It is not able to pick up from the TRAY 3. I pulled the HP Color Laserject 4700 Software Technical Reference and looked for the media source commands and used the numbers assigned for the trays. Whatsoever I do it is not recognizing. Any help from anybody is really appreciated. Looking forward to get some responses.... Tag: What's changed in vba in Word 2007? Tag: 101683
  - 12
    - Shortcuts How do I access a file with a short cut? Say I have a fax form saved in my documents and I want to access it by simply typing fax and hitting enter... Tag: What's changed in vba in Word 2007? Tag: 101668
  - 13
    - Find Corrupted word document Hi, I am working on the Word automation and every time i am opening and closing word document. if there is any Corrupted document its opening a dialog box saying that this document is corrupt anad want to repiar? is there any way to force dont show the dialog box and just repair the document with out promting the dilaog box. I already the OpenandRepair paramete as True but still it poping the dialogbox this is how i am passing parameters objDoc = wordApp.Documents.Open(ref Source, ref missing, ref missing, ref falseObject, ref missing, ref missing, ref trueObject, ref missing, ref missing, ref missing, ref missing, ref falseObject, ref trueObject, ref missing, ref missing, ref missing); Any help would be appriciated. Thanks Vijay Tag: What's changed in vba in Word 2007? Tag: 101667
  - 14
    - Comment block of code? Is there a way to comment an entire multi-line block of VBA code? If I have 10 lines I want to comment, it's frustrating to have to insert an apostrophe in front of each one. Thanks. Tag: What's changed in vba in Word 2007? Tag: 101666
  - 15
    - Verifying Digital Signatures in Word 2003 without opening the docu I'm trying to validate that a document has been digitally signed by a user on upload to a server, so I want to check and validate the signature at upload. But I can't find a way to validate the sig other than opening up the document. So, is it possible? Or should I look at using some other program to do the signatures? Tag: What's changed in vba in Word 2007? Tag: 101663
  - 16
    - Deleting current footer and replacing Hello, I've recently dug into Word interop using c#. The first thing I would like to see accomplished is to change the current footers of a huge pile of .dots. I've now succeeded in opening the Word Application and a Document in the background and setting the focus on the footer of the document. using: WordDocument = WordApplication.Documents.Add(ref TemplatePath, ref Missing, ref Missing, ref Missing); // select de footer WordApplication.ActiveWindow.ActivePane.View.SeekView = Word.WdSeekView.wdSeekCurrentPageFooter; Next step would be to delete the current footer and replace it by: VoettekstImage = WordApplication.Selection.HeaderFooter.Shapes.AddPicture(LogoLocatie, ref WordFalse, ref WordTrue, ref Missing, ref Missing, ref Missing, ref Missing, ref Missing); Works, more or less, but some strange things occurs, sometimes the current footer text doenst get deleted at all, sometimes it pastes the image so far down only a small part of it is visible. What I eventually would want to achieve is loading the picture into the footer by using INCLUDEPICTURE, but when I try to do this using: WordApplication.ActiveWindow.Selection.Fields.Add(WordApplication.ActiveWindow.Selection.Range, Word.WdFieldType.wdFieldEmpty, "INCLUDEPICTURE ""C:\\mijnmap\\bedrijfslogo.png"" ", ref missing) I get a literal, not a Field. So my question in short; How can I change the current footer into a Field which let a picture include, any help would be greatly appreciated! Regards. Tag: What's changed in vba in Word 2007? Tag: 101659
  - 17
    - InsertAfter function question Hi All, For the range object in VBA, there are insertafter and insertbefore function that insert text in front or behind the a particular range. My Question is, when I try to insert text behind the range using insertafter function. The inserted text carry the style and formatting from the original range. Eg. "This is a sentence" Assume the word "is" is my range and is red in color. when I use insertafter function (myrange.insertafter(" not")) The new inserted word " not" become red too. In this case, I know the inserted word is " not" and is red in color. So I look for any red " not" and change it back. However, in some cases, I dont know the orignal style of the text, so I can't change it back. Is there any way that I can insert text after the range without carrying range style?? I'm not very sure if it's the problem of "paragraph style" and "character style". P.s also, I dont get this problem while i insert text before the range using "insertbefore" funciton. Why is that?? Many thanks Tag: What's changed in vba in Word 2007? Tag: 101653
  - 18
    - IF statement, unprotect document only if protected Hi i was wondering if anyone change help me. My code currently works on a protected word document. I want the code to also execute if the document is unprotected already. Would anyone know the if statement whereby if it is protected then unprotect it else just carry on through the macro Sub ChangeField() ' ' ChangeField Macro ' Macro recorded 19/06/2007 by ododd ' ActiveDocument.Unprotect Password:="password" ActiveWindow.View.ShowFieldCodes = Not ActiveWindow.View.ShowFieldCodes Selection.Find.ClearFormatting Selection.Find.Replacement.ClearFormatting With Selection.Find .Text = "FORMTEXT" .Replacement.Text = "Title" .Forward = True .Wrap = wdFindContinue .Format = False .MatchCase = True .MatchWholeWord = True .MatchWildcards = False .MatchSoundsLike = False .MatchAllWordForms = False End With Selection.Find.Execute Replace:=wdReplaceAll ActiveWindow.View.ShowFieldCodes = Not ActiveWindow.View.ShowFieldCodes ActiveDocument.Protect Password:="protect", NoReset:=False, Type:= _ wdAllowOnlyReading, UseIRM:=False, EnforceStyleLock:=False CommandBars("Task Pane").Visible = False ActiveWindow.ActivePane.VerticalPercentScrolled = 0 Dim answer answer = MsgBox("Fields have now been updated", 65, "Document Control") End Sub Tag: What's changed in vba in Word 2007? Tag: 101652
  - 19
    - shortcut How can I substitute a symbol for a word? I want to be able to type a symbol to automatically replace a long word I must use frequently. Tag: What's changed in vba in Word 2007? Tag: 101650
  - 20
    - Word XP 2002 returns Illegal Function Call when setting wdUserTemplatesPath I've got the strangest problem going on right now in Word 2002. I'm trying to set the User Templates Path with VBA. I call a function that gets the UserName. I then insert it into a string and use that to set the path. Here's a bit of the code: Options.DefaultFilePath(Path:=wdWorkgroupTemplatesPath) = "V:\Reference \Templates\" Options.DefaultFilePath(Path:=wdStartupPath) = "C:\Documents and Settings\" & GetUserName _ & "\Application Data\Microsoft\Word\STARTUP\" Options.DefaultFilePath(Path:=wdUserTemplatesPath) = "C:\Documents and Settings\" _ & GetUserName & "\Application Data\Microsoft\Templates\" I can successfully run this once. But the next time I run it, I get: Run-time Error '4101' Illegal Function Call on the 3rd line, wdUserTemplatesPath. I've truncated the string to Options.DefaultFilePath(Path:=wdUserTemplatesPath) = "C:\Documents and Settings\" _ & GetUserName & "\Application Data\Microsoft\" and it works perfectly every time. As soon as I add "Templates\" to the line, it crashes after the first run. In Word 2003, this isn't a problem, and both of the other strings (WorkgroupTemplatesPath and StartupPath) don't have this problem. I've tried adding "Application." to the Options to no avail, and I've left the trailing slash off with no effect. Anyone see this before? Thanks! Tag: What's changed in vba in Word 2007? Tag: 101646
  - 21
    - How do I access a new Word Macro on multiple network computers? I've created a new Macro in Word. Apparently, it appears to be maintained on my individual computer. How can I share this macro with other Network computers or move it to a level where it can be accessed by other network computers. I do not see anything helpful in the Word Help menu. Tag: What's changed in vba in Word 2007? Tag: 101639
  - 22
    - Using VBA w/ IE6: how to run a JavaScript? Using VBA in Word 2003, I've managed to navigate to a web page (Windows XP, IE6sp2) and set an object to it, then find the two elements on the page that I want and set objects to them also. All I want to do is select a checkbox, then select the Next Page - lather, rinse, repeat until I run out of pages. But I can't run the JavaScripts that activating these elements is supposed to run. I can find the checkbox and set objCB.Checked = True. Looking into the page code, the OnClick event is set to run a JavaScript function named "selectAllCB". I tried objCB.onclick = "selectAllCB" but no joy. Likewise, I can find the "Next" link, but I can't activate it to run "javascript:showPage(2)". How can I do this through VBA? Ed Tag: What's changed in vba in Word 2007? Tag: 101638
  - 23
    - IncludeFieldCodes doesn't work I am trying to extract text from various ranges in a Word document. I want the field codes to display as their codes not the resulting text. I have: Range.TextRetrievalMode.IncludeFieldCodes = True MsgBox Range.Text I get: 6/19/2007 I tried True and False, same result. However if I do: activewindow.view.FieldCodes = True msgbox range.text I get: CREATEDATE \* MERGEFORMAT This is what I want but I don't want to mess with the GUI. So what am I doing wrong with the TextRetrievalMode.IncludeFieldCodes? TIA JO Tag: What's changed in vba in Word 2007? Tag: 101634
  - 24
    - Word 2003 calculate GPA Hello, I created a report card template awhile ago with drop down fields for teachers to input student grades (A, B, C, etc.) I was asked recently if it were possible to calculate the GPA from these field results. I'm over my head here. What is the best approach? Macro? Visual Basic? Active X? Has anyone out there generated this code? Thanks, Gary Tag: What's changed in vba in Word 2007? Tag: 101630
  - 25
    - Mail Merge with Variables (Sequal Formatting?) I have Office 2003 and I have tried every variation I can think of to use a variable for the worksheet name (to reflect the database) in a mail merge. I hesitate to try a different connection, because the way it is currently set up, it will read more than 255 characters (which is a requirement). I'll include my code below (up to the point I have a problem). SQLStatement:="SELECT * FROM 'strExcelWkshtName'", _ I have also tried these (and many, many other) variations. SQLStatement:="SELECT * FROM strExcelWkshtName", _ SQLStatement:="SELECT * FROM" & strExcelWkshtName, _ SQLStatement:="SELECT * FROM" & 'strExcelWkshtName', _ This statement (without the variable) works fine. SQLStatement:="SELECT * FROM `'Planned Close Version 200-DB$'`", _ Notice that the variable strExcelFileName is used twice in the mail merge and that works fine. Just before my mail merge statements, I have 'commented out' the mail merge line for the worksheet (database) that does not contain the variable and works great. ==================================================================== Dim appXL As Excel.Application Dim strExcelFileName As String, strExcelWkshtName As String ' Merge the data from the spreadsheet into a new word document based off of this template. ' Set appXL = GetObject(, "excel.application") With appXL.ActiveWorkbook strExcelFileName = .FullName strExcelWkshtName = .ActiveSheet.Name & "$" MsgBox strExcelFileName MsgBox strExcelWkshtName End With ' ' Merge the Word Template with the Excel data to create the User Release Notes. ' ' , SQLStatement:="SELECT * FROM `'Planned Close Version 200-DB $'`", _ ActiveDocument.MailMerge.MainDocumentType = wdCatalog ActiveDocument.MailMerge.OpenDataSource Name:=strExcelFileName, _ ConfirmConversions:=False, ReadOnly:=False, LinkToSource:=True, _ AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate:="", _ WritePasswordDocument:="", WritePasswordTemplate:="", Revert:=False, _ Format:=wdOpenFormatAuto, Connection:= _ "Provider=Microsoft.Jet.OLEDB.4.0;Password="""";User ID=Admin;Data Source=strExcelFileName;Mode=Read;Extended Properties=""HDR=YES;IMEX=1;"";Jet OLEDB:System database", _ SQLStatement:="SELECT * FROM 'strExcelWkshtName'", _ SQLStatement1:="", SubType:=wdMergeSubTypeAccess ======================================================================== Anybody have any ideas? Keith Tag: What's changed in vba in Word 2007? Tag: 101628

Hi folks,
According to a friend, this macro works fine in Word 2003 but causes a crash
in Word 2007. The name boat-03 is the name of the current active document.

Sub FollowLink()
Selection.Hyperlinks(1).Follow
Documents("boat-03.doc").Close
End Sub

I personally don't have Word 2007 to test it myself. Can anyone shed any
light on this?

Top

Re: What's changed in vba in Word 2007? by Shauna

Shauna
Mon Jun 25 09:25:34 CDT 2007

See response to your more-or-less identical post sent 2 hours after this
one.

Shauna Kelly. Microsoft MVP.
http://www.shaunakelly.com/word

"padshall" <padshall@discussions.microsoft.com> wrote in message
news:DE1C2B72-AA22-443C-81B3-95A3589D231F@microsoft.com...
> Hi folks,
> According to a friend, this macro works fine in Word 2003 but causes a
> crash
> in Word 2007. The name boat-03 is the name of the current active
> document.
>
> Sub FollowLink()
> Selection.Hyperlinks(1).Follow
> Documents("boat-03.doc").Close
> End Sub
>
> I personally don't have Word 2007 to test it myself. Can anyone shed any
> light on this?

Top