PC Review


Reply
Thread Tools Rate Thread

Create macro how to change smart quotes "" with smart quotes ,,"?

 
 
sarunas.leonas@gmail.com
Guest
Posts: n/a
 
      1st Mar 2006
Hello,

I'm finding hard to record a working macro in Word2000, that would
change smart quotes "" with another smart quotes ,," (ALT+0132 and
ALT+0147 or ChrW(8220) and ChrW(8222))

Maybe someone could help me on this?

Thank you very much,

Sarunas

 
Reply With Quote
 
 
 
 
Richard O. Neville
Guest
Posts: n/a
 
      1st Mar 2006
You may be able to do this with the Replace function, not a macro. Try
copying "" into Find what, and ,, into replace with. Try it on a couple of
quotes; if it works, use Replace all.

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hello,
>
> I'm finding hard to record a working macro in Word2000, that would
> change smart quotes "" with another smart quotes ,," (ALT+0132 and
> ALT+0147 or ChrW(8220) and ChrW(8222))
>
> Maybe someone could help me on this?
>
> Thank you very much,
>
> Sarunas
>



 
Reply With Quote
 
Graham Mayor
Guest
Posts: n/a
 
      1st Mar 2006
The syntax is to use ^0132 or ^0147

See http://www.gmayor.com/replace_using_wildcards.htm

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

(E-Mail Removed) wrote:
> Hello,
>
> I'm finding hard to record a working macro in Word2000, that would
> change smart quotes "" with another smart quotes ,," (ALT+0132 and
> ALT+0147 or ChrW(8220) and ChrW(8222))
>
> Maybe someone could help me on this?
>
> Thank you very much,
>
> Sarunas



 
Reply With Quote
 
sarunas.leonas@gmail.com
Guest
Posts: n/a
 
      2nd Mar 2006
Yes, I know that using Replace function (not a macro) everything works
fine. But here's a problem, thah I need to automate this proces using a
macro. A I'm stuck here I believe i need to upgrade to an Office
2003. It has no problem at this point.

Thanks

 
Reply With Quote
 
Graham Mayor
Guest
Posts: n/a
 
      2nd Mar 2006
The macro recorder doesn't always work as planned - and it's no better in
Word 2003. What *exactly* do you want to replace with what?

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


(E-Mail Removed) wrote:
> Yes, I know that using Replace function (not a macro) everything works
> fine. But here's a problem, thah I need to automate this proces using
> a macro. A I'm stuck here I believe i need to upgrade to an Office
> 2003. It has no problem at this point.
>
> Thanks



 
Reply With Quote
 
Sarunas
Guest
Posts: n/a
 
      3rd Mar 2006
Well, in my region (Europe --> Lithuania) office 2003 automaticly
converts smart quotes " " with other smart quotes used in my native
language ,, " (ALT+0132 and ALT+0147).
So all I need to do, is to record a macro, that would search a first
quote " and would replace it with ,, , then search for closing quote
in an sentence and replace it with " (closing quotes are different when
using combination ALT+0147).
And that would be all the macro should be able to do.
Because when you have 100 of word pages with qoutes like this "",
there's a waste of time in finding and replacing them using Replace
dialog. That's why I need a macro.

Sarunas

Graham Mayor wrote:
> The macro recorder doesn't always work as planned - and it's no better in
> Word 2003. What *exactly* do you want to replace with what?
>
> --
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> Graham Mayor - Word MVP
>
> My web site www.gmayor.com
> Word MVP web site http://word.mvps.org
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>
>
> (E-Mail Removed) wrote:
> > Yes, I know that using Replace function (not a macro) everything works
> > fine. But here's a problem, thah I need to automate this proces using
> > a macro. A I'm stuck here I believe i need to upgrade to an Office
> > 2003. It has no problem at this point.
> >
> > Thanks


 
Reply With Quote
 
Graham Mayor
Guest
Posts: n/a
 
      3rd Mar 2006
Unless I have completely misunderstood your requirement.

You can stop Word converting ordinary quotes to smart quotes at tools >
autocorrect options > autoformat as you type.

alternatively

You can autoformat and insert your country's smart quote settings by tools >
autocorrect options > autoformat and set the smart quote preference. You
don't need a macro to do that. If however the autoformatting inserts the
wrong style of smart quote, then you can replace those by searching for eg
^0132


--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


Sarunas wrote:
> Well, in my region (Europe --> Lithuania) office 2003 automaticly
> converts smart quotes " " with other smart quotes used in my native
> language ,, " (ALT+0132 and ALT+0147).
> So all I need to do, is to record a macro, that would search a first
> quote " and would replace it with ,, , then search for closing quote
> in an sentence and replace it with " (closing quotes are different
> when using combination ALT+0147).
> And that would be all the macro should be able to do.
> Because when you have 100 of word pages with qoutes like this "",
> there's a waste of time in finding and replacing them using Replace
> dialog. That's why I need a macro.
>
> Sarunas
>
> Graham Mayor wrote:
>> The macro recorder doesn't always work as planned - and it's no
>> better in Word 2003. What *exactly* do you want to replace with what?
>>
>> --
>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>> Graham Mayor - Word MVP
>>
>> My web site www.gmayor.com
>> Word MVP web site http://word.mvps.org
>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>>
>>
>> (E-Mail Removed) wrote:
>>> Yes, I know that using Replace function (not a macro) everything
>>> works fine. But here's a problem, thah I need to automate this
>>> proces using a macro. A I'm stuck here I believe i need to
>>> upgrade to an Office 2003. It has no problem at this point.
>>>
>>> Thanks



 
Reply With Quote
 
Suzanne S. Barnhill
Guest
Posts: n/a
 
      3rd Mar 2006
In the past, I could have sworn that changing the document language and then
just replacing " with " would do the trick, but when I tried that yesterday,
it didn't work.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Graham Mayor" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Unless I have completely misunderstood your requirement.
>
> You can stop Word converting ordinary quotes to smart quotes at tools >
> autocorrect options > autoformat as you type.
>
> alternatively
>
> You can autoformat and insert your country's smart quote settings by tools
>
> autocorrect options > autoformat and set the smart quote preference. You
> don't need a macro to do that. If however the autoformatting inserts the
> wrong style of smart quote, then you can replace those by searching for eg
> ^0132
>
>
> --
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> Graham Mayor - Word MVP
>
> My web site www.gmayor.com
> Word MVP web site http://word.mvps.org
> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>
>
> Sarunas wrote:
> > Well, in my region (Europe --> Lithuania) office 2003 automaticly
> > converts smart quotes " " with other smart quotes used in my native
> > language ,, " (ALT+0132 and ALT+0147).
> > So all I need to do, is to record a macro, that would search a first
> > quote " and would replace it with ,, , then search for closing quote
> > in an sentence and replace it with " (closing quotes are different
> > when using combination ALT+0147).
> > And that would be all the macro should be able to do.
> > Because when you have 100 of word pages with qoutes like this "",
> > there's a waste of time in finding and replacing them using Replace
> > dialog. That's why I need a macro.
> >
> > Sarunas
> >
> > Graham Mayor wrote:
> >> The macro recorder doesn't always work as planned - and it's no
> >> better in Word 2003. What *exactly* do you want to replace with what?
> >>
> >> --
> >> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> >> Graham Mayor - Word MVP
> >>
> >> My web site www.gmayor.com
> >> Word MVP web site http://word.mvps.org
> >> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> >>
> >>
> >> (E-Mail Removed) wrote:
> >>> Yes, I know that using Replace function (not a macro) everything
> >>> works fine. But here's a problem, thah I need to automate this
> >>> proces using a macro. A I'm stuck here I believe i need to
> >>> upgrade to an Office 2003. It has no problem at this point.
> >>>
> >>> Thanks

>
>


 
Reply With Quote
 
Graham Mayor
Guest
Posts: n/a
 
      4th Mar 2006
Autoformat works for me provided the language of the text is set as
Lithuanian - in fact I had to do this to see what the OP meant. I take it
you didn't overlook the obvious and had the autocorrect as you type option
to replace smart quotes switched off - as I normally have?

Changing it back to English is a little more fun. You would need a wildcard
replacement of
[^0132^0147]
with
"
and then run Autoformat again if you need English smart quotes.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


Suzanne S. Barnhill wrote:
> In the past, I could have sworn that changing the document language
> and then just replacing " with " would do the trick, but when I tried
> that yesterday, it didn't work.
>
>
> "Graham Mayor" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Unless I have completely misunderstood your requirement.
>>
>> You can stop Word converting ordinary quotes to smart quotes at
>> tools > autocorrect options > autoformat as you type.
>>
>> alternatively
>>
>> You can autoformat and insert your country's smart quote settings by
>> tools
>>
>> autocorrect options > autoformat and set the smart quote preference.
>> You don't need a macro to do that. If however the autoformatting
>> inserts the wrong style of smart quote, then you can replace those
>> by searching for eg ^0132
>>
>>
>> --
>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>> Graham Mayor - Word MVP
>>
>> My web site www.gmayor.com
>> Word MVP web site http://word.mvps.org
>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>>
>>
>> Sarunas wrote:
>>> Well, in my region (Europe --> Lithuania) office 2003 automaticly
>>> converts smart quotes " " with other smart quotes used in my native
>>> language ,, " (ALT+0132 and ALT+0147).
>>> So all I need to do, is to record a macro, that would search a first
>>> quote " and would replace it with ,, , then search for closing quote
>>> in an sentence and replace it with " (closing quotes are different
>>> when using combination ALT+0147).
>>> And that would be all the macro should be able to do.
>>> Because when you have 100 of word pages with qoutes like this "",
>>> there's a waste of time in finding and replacing them using Replace
>>> dialog. That's why I need a macro.
>>>
>>> Sarunas
>>>
>>> Graham Mayor wrote:
>>>> The macro recorder doesn't always work as planned - and it's no
>>>> better in Word 2003. What *exactly* do you want to replace with
>>>> what?
>>>>
>>>> --
>>>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>>>> Graham Mayor - Word MVP
>>>>
>>>> My web site www.gmayor.com
>>>> Word MVP web site http://word.mvps.org
>>>> <>>< ><<> ><<> <>>< ><<> <>>< <>><<>
>>>>
>>>>
>>>> (E-Mail Removed) wrote:
>>>>> Yes, I know that using Replace function (not a macro) everything
>>>>> works fine. But here's a problem, thah I need to automate this
>>>>> proces using a macro. A I'm stuck here I believe i need to
>>>>> upgrade to an Office 2003. It has no problem at this point.
>>>>>
>>>>> Thanks




 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to turn off "smart quotes" Jerry W. Lewis Microsoft Word Document Management 4 12th Dec 2007 09:30 PM
Script to change Smart quotes to straight quotes for all users? =?Utf-8?B?TWljaGFlbA==?= Microsoft Word Document Management 1 15th Nov 2006 05:12 AM
Smart Quotes to straight quotes (apostrophe) =?Utf-8?B?RWxrZQ==?= Microsoft Word Document Management 6 14th Jan 2005 04:59 PM
replace "smart quotes"? Susan Microsoft Word Document Management 2 9th Oct 2004 08:54 PM
Replace Straight Quotes with Smart Quotes Jay [Work] Microsoft Word New Users 0 10th Oct 2003 04:08 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:28 AM.