Home     Contact Us    
Main Board Job Seeker's Board Job Wanted Board Resume Bank Company Board Word Help Medquist New MTs Classifieds Offshore Concerns VR/Speech Recognition Tech Help Coding/Medical Billing
Gab Board Politics Comedy Stop Health Issues
ADVERTISEMENT




Serving Over 20,000 US Medical Transcriptionists

MS Word macro question. SM

Posted By: MissouriMT on 2008-02-01
In Reply to:

All of sudden all my macros give me the "Code Execution has been Interrupted."  Then I have to click Continue, End, Debug, or Help.


Why is this happening?  I've tried deleting the macros and re-recording them, but it keeps doing it.  HELP!  It's making me crazy.


 




Complete Discussion Below: marks the location of current message within thread

The messages you are viewing are archived/old.
To view latest messages and participate in discussions, select the boards given in left menu


Other related messages found in our database

There is a word macro that can change that
for you.  Not sure if it will work on your platform, though.  If you need it, just answer on here and I will post the macro so you can paste it into your program macros and assign a shortcut
No, not within SH. However, if you use Word, you can make a macro.nm
nm
When recording a macro in MS Word
what do you do in order to be able to jump from heading to heading; i.e., how do I get from HISTORY: to FINDINGS: ? Thanks for your help.
Microsoft Word Macro's
How do I set up macro's on Microsoft Word 2003 for frequently used terms?
Word 2007 macro help

I sure hope someone can help me here.  I have recently started using Word 2007 and am absolutely lost!  I finally figured out how to create a macro....but now cannot figure how how to call up that macro when I need it.  does this make sense???  example, ddd stands for degenerative disc disease..when I type "ddd"  do I hit a function key, just the tab key, CTL + function key?????  can't figure this out.  please help me!


thanks.  Rita



 


Word 2007 macro help
word 2007 is completely different than previous versions.  can you tell me where the autocorrect button/tab is??????  thanks for your help.
Word 2007 macro help
there is no "tools" in word 2007, or not that I can find.
Word 2007 macro help
thanks for all the help.  I absolutely hate word 2007 and as soon as I can I will be uninstalling it and reinstalling an older version.  it is completely different from previous versions. there are no toolbars at the top but a "ribbon" which is needlessly complicated.  sorry I'm cranky.  Thanks again though.
How can I make a macro in word

For some reason, I am unable to use the F11 key to jump to headers within a report when I use my macroed reports in EXtext.  So, I wanted to know how I could macro to jump from header to header in the word document and use a hot key.  If I could make a macro using word, I think I could still use my macro reports. 


Thanks


Just an extremely simple Word macro SM
I'll try and explain it. I'm no Word genius, I PROMISE.

You get in a document you're typing.

Macros
Record new macro
I made mine a keyboard macro, you name it, assign it (mine happens to be alt. alt period)

Then you go:
Edit
Find
. (period space space is what that is supposed to be)
Replace . (period space)
Replace all.

In the parentheses is the keys I pushed. I don't know how else to explain it but it's the alt Key and the period Key.

There's bound to be a "real" way to do it, but I just bumbled through this way.
What version of Word? That can't be set in newer versions. I had to do a macro --sm
I hope this link works for you. It shows how to make the macro. I use alt + semicolon for it because it seemed those would be a convenient shortcut to use. H

Here's the link (you'll probably have to copy and paste it):

http://fitaly.com/board/msword/posts/1629.html


Macro to Search Google from Microsoft Word?
I found one on the net, but when I pasted it in, it would not work.

My version of Word is Word 97. Thanks.
Word Macro to count Lines Strict inside

Hi,


The solutions others gave are good, but if I just needed to get the number of lines with typing (and don't need an invoice or a report), I'd use a Word macro.


The other solutions offered have this drawback: If the body of your document contains tables, the count Word gives you is vastly inflated, for Word counts each cell in that table as a line. This is not what the eye sees, and becomes problematic when you try to justify such to your client.


Below is a macro for counting what we at Emmaus call Lines Strict. (i.e. Lines with typing on them, vs Lines Extended that includes the blank lines).


To use it, copy from Public Sub through End Sub, and paste it into your macros along with your other macros. Easiest way of doing this is (after you have copied the appropriate lines):


1. Click Tools | Macros, and select an existing macro.


2. Click the Edit button.


3. Once the Visual Basic Editor opens, press Ctrl+End to move to the bottom.


4. Paste the clipboard contents.


5. Click File | Compile Normal. (If you've pasted things that don't belong, it won't compile.)


6. Click File | Close and Return to MS Word.


Merry Christmas!
vJoe
http://www.mpword.com


OOPS! I looked at the HTML code after I pasted the code into the editor on this board, and it added things that when pasted into the Visual Basic Editor in Word will not compile. Here's the code if you want to retype it, but pasting won't work. If you send me an email, I'll attach the code into a .txt document, and you won't have any problems.  vjoet@attglobal.net


Public Sub GetLinesStrictCount()
    Dim CharsStrict As Long
    Dim Count As Long
    Dim ParaswBlanks As Long
    Dim ParasWOBlanks As Long
    Dim LineswBlanks As Long
    Dim BlankLines As Long
    Dim LinesWOBlanks As Long
    Dim NumOfTables As Long
    Dim NumOfRows As Long
    Dim TableRowCount As Long
    Dim x As Integer
   
    TableRowCount = 0
    NumOfTables = 0
    NumOfRows = 0
   
    ActiveDocument.ComputeStatistics (wdStatisticCharacters)
    ActiveDocument.ComputeStatistics (wdStatisticLines)
    CharsStrict = ActiveDocument.BuiltInDocumentProperties(wdPropertyCharacters)
    ParasWOBlanks = ActiveDocument.BuiltInDocumentProperties(wdPropertyParas)
    LineswBlanks = ActiveDocument.BuiltInDocumentProperties(wdPropertyLines)


    NumOfTables = ActiveDocument.Content.Tables.Count
    If NumOfTables > 0 Then
        For x = 1 To NumOfTables
            With ActiveDocument.Content.Tables.Item(x)
                NumOfRows = NumOfRows + .Rows.Count
            End With
        Next
        TableRowCount = NumOfRows
    End If
   
    If CharsStrict > 0 Then
        ParaswBlanks = ActiveDocument.Range(wdMainTextStory).Paragraphs.Count
    Else
        ParaswBlanks = 1
    End If
       
    If LineswBlanks > 1 Then
        LineswBlanks = LineswBlanks + 1
    End If
   
    If ParaswBlanks = 1 And ParasWOBlanks = 1 Then
        BlankLines = 0
    Else
        BlankLines = ParaswBlanks - ParasWOBlanks
    End If
   
    LinesWOBlanks = LineswBlanks - BlankLines
    Count = LinesWOBlanks
   
    MsgBox "Lines Strict (with typing) = " & CStr(Count + TableRowCount)
End Sub


 


 


Setting up macro in Word for jump code...inside
(you can actually use any key on the keyboard, I actually use F3 because it doesn't seem to interfere with anyting.)

I call it a "jumpcode" and what you need to do is create a Word macro for it. For example, I use (Alt + /) to insert blanks in a document. Now if I want to jump to the blanks I use (Alt + >). In reading your question, it sounds as if the symbol you want to "jump" to is already in the document, so you would just have to define the jumpcode for that prompt.

So, first create your macro.
1. Tools - Macro - Record New Macro.
2. Name your macro (ex. Jumpcode) or use the default Macro name
3. Assign macro to Keyboard.
4. Pick what keys to assign the keyboard macro - Example Alt + J (NOTE - SOME KEYS ARE ALREADY DEFAULT ASSIGNED BY WORD. SYSTEM WILL ALERT YOU TO THIS FACT! YOU WOULD THEN PICK ANOTHER KEY OR THE DEFAULT WORD KEY WILL BE OVERWRITTEN)
5. Select Assign - Close
6. You will then notice the "record macro function" come on (symbol of a little tape cassette will appear on screen). All key strokes from this point will be recorded until you turn off record macro function.
7. Recording your macro. Since the jumpcode you want to jump to is the >" you should set it up this way:
A. Ctrl + F (the find function). This will pull up the "Find and Replace" box.
B. Type in the prompt you want to find which would be >"
C. Hit "Find Next"
D. Then close "Find and Replace" box.
E. Stop recording. (Hit the square in the record macro icon)

Now when you hit "Alt + J" system should jump to the >" prompt in your document

You can use Shorthand to make a Macro, then bring the macro up in WP. nm
nm
I need step-by-step instructions to make a macro in word that aligns automatic numbered list to the
HELP!!!!! Thanks in advance.
Re companion macro. Do you know there is already a macro
in Word that will create a document with all entries from both the normal.dot and the .acl file? The normal.dot only stores the formatted entries.
Me too - with a macro. nm
x
Macro

1.         Open a blank document.


 


2.         Type 3-4 question marks down in a single line.


 


3.         Put your cursor back up at the top before the first ? mark.


 


4.         Open tools Macros – Record new macro.


 


5.         Click keyboard – type in the combination of keys you want to use to jump (make sure that combination is not assigned to anything else).  I used Shift+Control+Alt J.  Then close that box out.


 


6.         With your mouse click Edit - Find – type a ? in the find box, click Find Next.  It will take your cursor to the first question mark (make sure it’s highlighted).  Then hit cancel to close out the find box, and click STOP on the macro button.


 

Now try the combination.
You don't need a macro for this.
Just insert fields in your template with Ctrl+F9 and when you create new docs, hit F11 to jump to the fields and start typing.
Macro
Go to this page which will display the macro that you need. You will have to edit one of the lines in order to create one space, instead of two.

http://wordtips.vitalnews.com/Pages/T1497_An_Automatic_Two_Spaces_After_a_Period.html:



Don't know if this will help you with your macro, but
see the link below.
macro help
Help!!! I made a macro in Microsoft Word for formatting and font.  When I use the macro, the words on the last line of each paragraph are spaced too far apart. Any advice greatly appreciated. 
Macro Help
Anyone know an easy way to set up macros in MS Word 2007?  I have tried and tried and cannot figure it out.  Thanks in advance!  sb
macro help

can someone please tell me how to make a macro in word for go to *?


You don't need a macro for this.
Use blank fields instead and all you have to do is hit F11 to jump to each field. Ctrl + F9 inserts a blank field. Search here for fields and you will see examples.
macro help
Thanks that works!
macro okay
it should work

Macro
Need help i  using macros. I need to use find and replace words. For some reason the word is being highlighted when I run the macro, but not being replaced by the assigned word. Please advice on the use of macros.
macro
I recorded Macro using record button, wihtout any code.Find and replace is working alright now, but would like to know whether I can enter multiple words to replace. I have a long list of words to be entered, and right now I am unable to do that all in one Macro. Please help.
Macro help

Can anyone give me instructions on how to create a period macro in word 2003.  I want to make a macro that inserts a period when I need it.  I use ASR, so I need this function to make corrections easier.


Thanks so much!!!!!


NSS: Here's the macro instructions

In a Word document, type a few words, like a diagnosis on a line.  Leave your cursor at the end of the line.


Click TOOLS, MACRO, RECORD NEW


A window called Record Macro pops up.  I suggest you put a name in the "Macro Name" field.  (Hint:  No spaces allowed in the name.)


Click KEYBOARD to assign it to the keyboard.


A window called "Customize Keyboard" pops up.  In the field "press new shortcut key", press what you want as the shortcut.  (Hint:  I use ALT+N so I can remember it for numbering.)  That key combination you type should populate that field.


Click ASSIGN, CLOSE


You will be back at your document (your cursor still at the end of the line of text you typed) and there will be a small window called "Stop" that has a solid square (the STOP RECORDING button) and another symbol (PAUSE RECORDING button).  At this point, every single thing you do is being recorded!


Press the HOME key (to put cursor at the beginning of the line).


Press the 1. keys and space twice (or however many times you space between your number/period for your account).


Press the END key (to return cursor to end of the line of text).


Press the RETURN key.


Press the 2. keys and space twice (or, again, however many spaces you put between your number/period for your account).


Click the STOP RECORDING button in the little window.


Your macro is complete.  I suggest you try it out.  Skip down a few lines and type a line of text.  At the end of that text, hit your macro shortcut.  It should run (you won't see it do anything but make the changes you recorded) and automatically go to the beginning of the line, number it as 1 with a period and spaces, and return at the end of your text and start the number 2, period, spaces and be ready for more text!!  Email me if you have problems. 


NOTE:  This will only work if the text you type is only 1 line long.  If it word-wraps to a second line, this will not work...you will just have to manually return to the beginning of the line and number. 


More ideas for building macros, at least the ones I use most: 


-- macro to increase the zoom to a certain percentage (I use 110%)


-- macro to scroll down 1 frame or page


-- macro to copy the preoperative diagnosis heading, the 1-line text below it, return a line blank and type postoperative diagnosis heading and paste (for when the dictation is for "postoperative diagnosis same").  I use ALT+; for postoperative diagnosis and ALT+' for postop diagnosis


-- macro to copy the physician names/credentials in the signature block and search for the header for SURGEON and fill it in, putting it in all capitals, etc.


Just a handful of ideas I use.  Hope these help.


you have to create it as a macro (sm)
hit F3 for help and then M or C to create Macros...
when you follow these instructions, it will create an ALT(whatever). Then, in your docutment, you would do ALT-K or ALT-J, or ALT(whatever you name it)
just did it.. it's CTL-10 and then define macro (nm)
x
How do you make that macro?

I feel like MTs are being nickel and dimed to death with this.


How do you make that type of macro?  Do you type "." space, space?  I'm not sure my Expander recognizes spaces after an entry.  ?


Here is a link to a macro (sm)

for that.  Following the macro he gives instructions on how to modify the macro for one space.  When you modify the macro you will have to change the name also, so you could change it to read:


Sub OneSpace()


on the first line.


If you don't know how to add a macro, click Tools, Macros, Macro, then in the Macro Name: box put TwoSpaces, then click create.   Paste the macro provided in place of the "Sub TwoSpaces()" and "End Sub" that are there.  Go the end of the End Sub line and hit enter.  Paste the second macro there and click save again.


You have to create a macro. SM for how I did it.

I assigned my macro to ALT-B, but you can assign any keys you want so long as they are not already in use for another function.


To create a new macro you click:


Tools -> Macros -> Record a new Macro


A window will open up that says:


Macro Name:  In the box type in the name you wish to give your macro. (I simply typed in AltB).


In the middle of the window you will see "Assign Macro to" with two buttons that say "Toolbar"  and "Keyboard".  Click the Keyboard button.


This opens a new window and your cursor will be in the field that says "Press new short cut key".  You will hit the series of keys you want to assign your macro to (in my case it was Alt+B).


Below you should see "Currently assigned to [unassigned}"  If it says it is assigned, you will need to pick other keys to assign your macro to.


Finally, click assign.


Now you are in your document and there will be a little box that has a stop button and pause button.  Every keystroke you make from this point on is recorded and will be assigned to your macro.


Now you want hit Ctrl+F which will bring up the find window and type in a character that you want your cursor to jump to.  I use the asterix (*).  Then click the stop button on the little box.


Then test our your macro.  I have report templates I use that look like this:


CHIEF COMPLAINT:  *


HISTORY OF PRESENT ILLNESS:  *


And every time I hit Alt+B, I jump to the next asterix.


I hope this helps.  It sounds kind of confusing when you are trying to explain how to do it, but once you do it it is really pretty simple.


MACRO FOR JUMP

Could you email it to me too?  I have not had 100% success with this in Word, having typed in WordPerfect for years and years.  I appreciate any help you may provide in this regard. 


keystroke to macro
Hi, I tried to look at my old "jump" macro, but in XP I cannot do this.  Assuming you are using an Expander (I used PRD back then) you create the name of the macro (mine was ALT-J) by inserting a "find" (so it will find @ or ? or whatever you call your place for the insert) and there the key is to create a destructive backspace so that your work will be without extra space/spaces.  This destructive backspace will remove your @ or ? or whatever you use on your template and allow you to insert your data.  If I could pull mine up (and wish I could do this more easily) I would just paste it here for you.  Good luck!  If I manage to get mine out of its "resting place" I will post it to you. 
Here is a macro from Productivity.com
/
Macro had a life of its own...
My funny is a little different -- my macro for "erectile dysfunction" was of course ed but little did I know that every time I typed a word that ended in "ed" (which are a lot of words!) "erectile dysfunction" would pop up instead. Like in my private emails and stuff. It was difficult to explain to non-MTs...
I have never made a macro yet nor do I know how
and I've been doing MT for over 13 years now.  I have used PRD, Instant Text and auto correct and auto text in Word - I could not make a macro if my job depended on it!
Macro help...error?!

I have set up several macros with my docs thank yous, closing and signatures.  They seemed to work fine whenever I set them up and then tried them out but now everytime I try and use one, it plugs in something that I earlier cut and pasted.  For instance, the thank you and closing are there but instead of the docs sig it is something wierd that I cut and pasted earlier.  I go into my macros and it looks right.  Anyone have any suggestions on how to fix this??  As always, thanks!  I don't know what I'd do without this website!!


Try using an autoclose macro

Since I don't know what platform you are using, this may not work for you --  if the normal dot is open somewhere else.  I do have another solution if this does not work; if you like, you can write me and I will send you the suite of macros and instructions that I use that will work around this problem that occurs with some transcription platforms.


I don't know anything about this acl file that is supposed to be saved but maybe the person who has written me about this will put up a post that will provide some information on what needs to be done to do this.


This macro needs to be posted into your macro editor.  Since I have had problems in the past with macro code not posting to this forum correctly, I will take a quick look at it and make sure it's okay, and post a follow-up note that it is okay to use.


Sub AutoClose()
on error resume next
If NormalTemplate.Saved = False Then NormalTemplate.Save
End sub


the autoclose macro is okay
hope it works for you

macro - fixed
between windows & mac, something got squashed in the file name reference. Let's see if it pastes cleanly now.

Make sure you create a text file c:
eplacetext.txt and put the entries in the format specified

findthis|replacewiththis
teh|the
mjsmithx|Michael J. Smith, MD,
HIPPA|HIPAA
etc....

Note - if you want to change the file name or location, change the corresponding OPEN statement in the macro below. Also, if you want to change the delimiter character from the hardcoded (single pipe) value to something else, change the delimchar line below and the text file accordingly.

You can insert this into a module in your normal document template -- or in a specific document or template if you don't want it in Normal -- post here if you need more details

This will run through every entry in the text file and make the corresponding replacement in the target document.


Sub replacemulti()

Dim TextRaw, FindText, ReplaceText As String

Dim delim As Integer

Dim delimchar As String


delimchar = "|"                 'Must be a single character for this version.

Open "c:
eplacetext.txt" For Input As #1    ' Open the find/replace source file.

Do While Not EOF(1)             'Loop until end of file   
Line Input #1, TextRaw      'Read file, one line at a time
   
delim = InStr(1, TextRaw, delimchar, 0) 'Get the position of the delimiter

 FindText = Left(TextRaw, delim - 1) 'FindText = text to left of delimiter
ReplaceText = Mid(TextRaw, delim + 1, Len(TextRaw))  'ReplaceText = text to right of delimiter
'Do the replacement

Selection.Find.ClearFormatting

    Selection.Find.Replacement.ClearFormatting

    With Selection.Find 
.Text = FindText
.Replacement.Text = ReplaceText

.Forward = True
       
.Wrap = wdFindContinue

        .Format = False

        .MatchCase = True

        .MatchWholeWord = True

        .MatchWildcards = False

        .MatchSoundsLike = False

        .MatchAllWordForms = False

    End With

    Selection.Find.Execute Replace:=wdReplaceAll
Loop

Close #1    ' Close file.

End Sub

Macro expander
Have any of you used that new Windows Expanderex product advertised on this site? What kind of file does it use?  Is it compatible with Shorthand? Sure wish they would make one available that isn't so expensive. Would like one for home use but don't want to spend over $100.
If possible, make a macro...
to add 2 spaces after each period.  At the end of the report, run the macro and it will make the changes for you.
If you don't know how to create a macro
an unhelpful post to someone asking for help? Especially since someone else had already given her good instructions for what she wanted to do and another poster had pointed her in the direction of a board devoted to increasing productivity.
To NSS: Instructs for the macro you asked about are
posted below under the thread about Hints and Tips.  I listed some other ideas on how macros can work for you.  Hope these help.
To SnowBunny--thank you for the macro link.
xx