Tech Problem Aggregator

Macros in Word 2003 Pro will not work regardless of security level

Q: Macros in Word 2003 Pro will not work regardless of security level

I'm having a very hard time with Word 03 Professional. For some reason, my macros have been disabled, and I'm not even allowed to make new ones. The exact message I'm getting is "The macro cannot be found or has been disabled because of your Macro security settings." My security settings are at low right now; I've went to Help>About Microsoft Ofiice>Disabled Items, but nothing is there. I'm not sure what to do next. Any help would be appreciated.

More replies
Answer Match 78.12%

my copy of windows continually fails to recognise macros. from many different programmes. most annoyingly it wont even recognise a hyperlink! just brings up the code. i have tried reducing the security level of macros and even at low they are still not recognised! is there anyway to sort this out other than destroying my computer and buying an apple mac?

 

A:MS word 2003 macros

Welcome to the forum.

With regards to hyperlinks I am guessing you are viewing the field codes which will show you the address and such. To turn that off go to "Tools">>"Options" from the menu bar and uncheck the check box for "Field Codes."
 

1 more replies
Answer Match 78.12%

I hope someone can help me with this problem. I recently did a complete restore on my computer. I have Office 2003.

In Word I must have had over 1,500 macros. I can't find the file where they would be kept in my backup drive so I can hopefully recover them.

Can anyone help me.

This is so frustrating. I don't want to put them all in again manually.
 

A:Word 2003 macros

If you've restored the PC back to it's factory settings the macros are lost. Macros are saved either on a particular document or they can be saved to your default Word template file which is called Normal.dot so that it can be available to all documents. Sorry but I think you are outta luck if a true restore was performed.

Either way
 

1 more replies
Answer Match 78.12%

I have hundreds macros stored in Normal.Modules 1-6 which I have been using quite satisfactory for years. For some reason some of them have now stopped running and I get "Compile error. Expected: If or Else or Elself or End or Endlf or Const.

I have noticed that the ones that aren't running are not in a module but Normal.NewMacros.

However, none of them will run now.

I have contacted Microsoft and they just keep telling me to copy the New Macros into a Module, but I don't know how to do this.

Also, I can record a new macro in All Documents.Normal.dot, but when I try to run it I get the error message mentioned above.

No-one in our IT understands macros, and I'm not getting anywhere with Microsoft so any help would be gratefully received.

Alison Armitage
[email protected]

A:Macros in Word 2003 won't run

Maybe this will help: Copy a macro - Project - Office.com

1 more replies
Answer Match 78.12%

hi i had a problem opening word with macros popping up, i looked online and followed instructions and deleted them, but now these boxes pop up every time the user opens word, how can i get rid of them

More replies
Answer Match 77.28%

When I start MS Word 2003, it start giving me error that some macros could be virus, so I disable them. These macros are WFWORD2K.DOT Symantec WinFax Macro.

It tried to disable these related Macros from Word Tools Menu->Templates and Add-ins but the Remove button is not functioning (dimmed) and when I tick-off to disable these macros and launch MS Word 2003 again, then are still there enabled and giving me the same errors.

Any ideas?!
 

More replies
Answer Match 77.28%

Hi there pals!

How could I introduce my Word 2003 macros and templates in my Word 2010 new installation? Any idea how to avoid the toil of making the macros and templates anew?

Thanks.

D.
 

More replies
Answer Match 77.28%

Using Win 7 Home premium and Word 2003. Record new macros, but they're not available if I close and re-open Word. Have renamed normal.dot to oldnormal.dot but don't see a new normal template. Have Acrobat 9.0 but found past problems only with Acrobat 7. Everything worked fine using Word 2003 with Vista so wonder if Win 7 is the problem. Please advise

A:Macros won't save Word 2003

Word (Office) 2003 SP3 - Version 11 - is compatible with Windows 7:
http://www.microsoft.com/windows/compatibility/windows-7/en-us/Details.aspx?type=Software&p=Microsoft%20Office%20Word%202003&v=Microsoft&uid=11&pf=3π=8&s=office&os =32-bit

3 more replies
Answer Match 77.28%

Each time I open Word 03 I get message that palmapp.dot contains macros, do I want to disable, enable or cancel.... How do I attach a security certificate to this trusted file.. so I don't get the message everytime?
 

A:MS Word 2003 and palmapp.dot macros

Nicked from another website:
You can create your own digital certificate by using Selfcert.exe tool that was installed with office (do a file search for it). This will create a certificate that's stored on your machine.

Then, in the VB editor, you can go to the Tools menu and select Digital Signature. This will let you pick one of the certificates you have installed (you'll probably only have one).

After saving, you'll need to re-open it with security set to Medium. You'll have an option to 'always trust macros from this source'. If you enable this you can set your security back to High and you'll never be asked again about code signed with that certificate.

If you want to do the same on another machine you'll need to copy the certificate over to it (it's a .cer file) and do the last part on that machine too.

That's the long way. The short way is to go into your macro security settings and select the 'trusted sources' tab. If you tick the 'trust all installed add-ins and templates' option, then anything in your default template directories won't trigger a warning. I *think* that applies to the startup folder as well.Click to expand...

Gram123
 

1 more replies
Answer Match 75.6%

Whilst I have used many macros before (not written), I'm struggling with the basics here on looping.

The idea is that this macro cursors to the end of a paragraph, selects the last 6 characters and then highlights them. This should be looped through the file 'til all instances of these are highlighted. Then it searches for any highlighted word spaces and makes them non-breaking spaces. Finally it removes all highlights:

Sub min5ver2()

' min5ver2 Macro
Selection.HomeKey Unit:=wdStory

'need to loop this section
Selection.MoveDown Unit:=wdParagraph, count:=2
Selection.MoveLeft Unit:=wdCharacter, count:=1
Selection.MoveLeft Unit:=wdCharacter, count:=6, Extend:=wdExtend
Selection.Range.HighlightColorIndex = wdBrightGreen
'loop ends

Selection.Find.ClearFormatting
Selection.Find.Highlight = True
Selection.Find.Replacement.ClearFormatting
With Selection.Find
.Text = " "
.Replacement.Text = "^s"
.Forward = True
.Wrap = wdFindContinue
.Format = True
.MatchCase = False
.MatchWholeWord = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False
End With
Selection.Find.Execute Replace:=wdReplaceAll
End Sub
 

More replies
Answer Match 74.76%

I changed hard drives and did not copy my Word macro's. I can put the old drive in as a slave. Under Windows, where are my Word 2003 macros stored? Thank you in advance for your time and help.
 

A:Solved: On my computer, under Office 2003, where are MS Word macros stored?

They could be in many different locations:

- Within the document in question, which is probably not the case since you're missing your macros.

- In your normal.dot, which is normally located in your profile directory (usually C:\Documents and Settings\YourUsername) under \Application Data\Microsoft\Templates\

- In any .dot file in your Word Startup folder, which is usually in your profile directory: \Application Data\Microsoft\Word\STARTUP\

- In any other .dot file in any other folder, that was manually added to Word through Tools, Templates and Add-Ins. If your macros were not in any of the previously mentioned locations, search the hard drive for any .dot files and check whether your macros in there...
 

2 more replies
Answer Match 74.76%

Hi! Firstly I'd like to make it clear that I have absolutely no experience with Visual Basic in Word 2003 and therefore if anyone is able to help I would appreciate 'baby-fed instructions'

I have 3 shapes/groups in my document. I have used various macro's to manipulate the colour of all 3 groups, which therefore makes it easier for the user than having to select each group seperately and revise colour.

My problem is that: the user has to be able to have the option to delete one(or more) of the shapes and continue to colour the remaining groups onstage. Currently I'm getting a "Run-time error" which states "The items with the specified name wasn't found". I expect I'll require some sort of "IF" statement?!!

An extract of my script can be seen below:
Code:

Sub BlackTopLenses()
'
' BlackTopLenses Macro
' Macro recorded 28/05/2012 by New User
'
ActiveDocument.Shapes("Group 533").Select
ActiveDocument.Shapes.Range(Array("Group 533", "Rectangle 522")).Select
ActiveDocument.Shapes.Range(Array("Group 533", "Rectangle 522", _
"Group 523")).Select
Selection.ShapeRange.Fill.ForeColor.RGB = RGB(0, 0, 0)
Selection.ShapeRange.Fill.Visible = msoTrue
Selection.ShapeRange.Fill.Solid
End Sub

Any help would be greatly received...
 

A:Visual Basics, Word 2003, macros ... head scratch!

Can you post a sample document?

Rollin
 

2 more replies
Answer Match 74.34%

Hi, I am trying to create a macro to assign the heading level to the caption numbering.
To explain it better:
If a figure is under a heading 3, let's say 2.1.1, its caption should be 2.1.1-1
If the next figure is under a heading 2, f.e. 3.1, its caption should be 3.1-1

Sadly iI have very little knowledge of the methods and properties available under Word, so I don't know where to start: I fiddled with CaptionLabel and HeadingLevelForChapter but I have no idea on how arrange things up.
Any suggestion would be helpful
Thank you
 

More replies
Answer Match 71.4%

I have been trying to change the security level of internet explorer. But it is always showing as high. I have checked the group policy settings, but found nothing.

Anyone please suggest any methods to change it into medium?

Regards,
Nishad
 

A:Solved: Unable to change the security level in Windows 2003

Hi, what sec level are you talking about.

tools>internet options>security>change it to whatever you want.

Bill
 

3 more replies
Answer Match 69.72%

I am converting an old MS Word template we have for our office to install properly on 64 bit systems which basically just inserts some small preformatted .doc files into a template which you can save as a new file. All I did was change the lookup for the file location to grab the program files environment variable so it would go to Program Files or Program Files (x86) when it should.

Now the issue I'm seeing is that the toolbar it places provides shortcuts for 10 or so of these inserts and 9 of them work. The last one gives the error "The macro cannot be found or has been disabled because of your Macro security settings". This error popped up on all these shortcuts before I dropped macro security settings down to medium, after which the rest of them worked just fine. If I go to tools->Macros->Macros to see the list of available macros I can run it directly from there and it works just fine.

The problem insert has no different code at all (except for the filename which it inserts), but is the only document to have a picture within it if that helps. I'm not very familiar with word or the macro editor within it but I was not able to find a way to edit the toolbar that appears in 2003 (Which is not present in 2007).

Some extra info: I am seeing this issue on a win8 64 bit laptop running office 2003. On my other laptop I have office 2007 and do not have the toolbar shown in 2003 at all. The toolbar issue may be present there but I have no idea how to e... Read more

More replies
Answer Match 67.2%

At my work we have templates from Word 2003.

When we open them in Word 2007 they doesn´t work as they should.

We have for example a menu like

2 Electronics
2.1 Phones
2.1.1 Mobile phones

When you make an uppdate on the menu the sub-numbers disapear so it is
2 Electronics
Phones
Mobile phones

Also in 2003 you get a menu to the right where you can change in the list not only the types but also the numbering. Is there something like that in 2007?
 

A:Making Word 2003 templates work in word 2007

A couple of things.

Firstly here is an interactive guide for some of the features in 2003 - 2007. It is useful in some circumstances
http://office.microsoft.com/en-gb/word/HA100744321033.aspx

In regards to using 2003 templates for 2007 - i noticed that not all things worked in the same way in 2007 especially when it came to printing (things would display differently to how they would print)

I work for a big company and i had to redesign alot of templates. Sorry.

In regards to changing the numbering, you now right click on one of the actual numbers within the document and you can change the numbering from there.

Hope that all makes sense.
 

1 more replies
Answer Match 63.42%

I cannot use IE on my desktop, but several other applications (e.g. outlook) can access the internet. When I ping my router from the desktop, it works fine, but when I ping the desktop itself from the desktop it times out.

Pinging the desktop from other computers on the home network work fine.

Is my stack screwed up, or do I have a problem with the network adapter?

Steve
 

A:Low-level Connects work, not high-level

14 more replies
Answer Match 63%

Since installing Win10 I can't get 2003 Office Word to work.

It won't make links for email and web addresses, the wrong toolbars come up again and again, and it generally doesn't work.

Any way to fix this? I have tried with two different 2003 Office programmes, re-installing, but no luck.

Thanks

A:Word 2003 won't work.. any way to fix it?

I don't know if this is the solution, but I think that Office 2003 is so old that it works but has errors because of Compatibility. I had this same problem, so bought a subscription to Office 2016 and it all worked fine! ��

3 more replies
Answer Match 62.16%

I have a report that contains macros to update all the information that is put in. It is in excel 97 and my business just recently updated to 2003 and now I get a compile error when I run the reports. How can I fix this error?
 

A:Solved: convert excel 97 macros to excel 2003 macros

8 more replies
Answer Match 61.74%

Hello,

I am having issues with Word and Outlook 2003. I just upgraded them from 2000 and now I am running into a couple of issues. Help!

Microsoft Word 2003
- Can't highlight or select an area on my Word page with my mouse. I can use my keyboard, but that becomes quite annoying as you can imagine.

Microsoft Outlook 2003
- Can't highlight or select an area on my page with my mouse. I can use my keyboard, but that becomes quite annoying as you can imagine.
- Can't open Word document attachments only. I can open excel, pdf, etc..., but not Word.

I have restarted my pc, reinstalled office 2003, erased the normal.dot profile, removed the 11.0\Word\Data registry and no luck. Any solutions would be greatly appreciated. Thanks!
 

A:Can't highlight in Word 2003 and Outlook 2003. Can't open Word 2003 attachments.

9 more replies
Answer Match 61.32%

I need to find out if there is a way to copy all the macros I wrote and use in Word 2002 to Word 2007. I have both versions installed at the moment.

Also, is there a way to transfer settings such as all my auto correct, etc (although this is less important)

Barbara
 

A:Solved: How can I copy macros from Word 2002 to Word 2007?

Open the document(s) in question and press ALT + F11 to bring up your Visual Basic editor. On the left hand side of the VB editor is your project explorer window. In the project explorer window you will see a folder called "Modules" that you can open to show all the modules attached to the document. These modules is where you VBA code is stored. You can right click each module and selection the option to export to the location of your choice. Once exported you can copy or save them to another machine and then re-import them by openining the VB editor on the other compuer and choosing FILE >> IMPORT.

Regards,
Rollin
 

3 more replies
Answer Match 60.9%

When I bought my new computer its' 64 bit, I transferred everything from my old 32 bit computer and

everything went fine, but my word 2003  will not load the Pleading Wizard.  It loads everything else in the
word program but the PLEADING WIZARD, it was working fine in windows 10 at 32 bits
Does anyone know how to get my 2003 32 bit program to work on my new 64 bit computer?

More replies
Answer Match 60.9%

This is a sub routine designed for Excel 2003 that calls the 'Save As' routine and allows the user to input their own file name and directory etc. I would like to convert it to a Word 2003 routine can anybody show me how or suggest a method by which I can do the same in Word ? Word doesn't recognise the 'Application.GetSaveAsFilename' method in this routine.

I have tried using a MsgBox to define a file name and the use the ActiveDocument.SaveFileAs to save the file but I can't allow the user to choose his own directory using that method and its clumsy !

Dim file_name As Variant

' Get the file name.
file_name = Application.GetSaveAsFilename( _
FileFilter:="Excel Files,*.xls,All Files,*.*", _
Title:="Save As File Name")

' See if the user canceled.
If file_name = False Then Exit Sub

' Save the file with the new name.
If LCase$(Right$(file_name, 4)) <> ".xls" Then
file_name = file_name & ".xls"
End If
ActiveWorkbook.SaveAs Filename:=file_name
End Sub
 

A:Solved: Convert a Excel Sub to work in Word 2003

Try this

Application.Dialogs(wdDialogFileSaveAs).Show

Rollin
 

2 more replies
Answer Match 60.48%

I am converting a large website of Microsoft Word files to TeX files and have written several useful Word macros to automate this process. When I converted from Word 2007 to Word 2010, the macros I wrote disappeared (a lot of supplied macros do appear). They don't appear even when I open a doc file where they have already been used in that file under Word 2007. It didn't occur to me to save the macros elsewhere, and apparently installing Word 2010 destroyed them.

Where can I find them?

Thanks

Tech Support Guy System Info Utility version 1.0.0.1
OS Version: Microsoft Windows XP Professional, Service Pack 3, 32 bit
Processor: Intel(R) Pentium(R) D CPU 3.00GHz, x86 Family 15 Model 4 Stepping 4
Processor Count: 2
RAM: 2046 Mb
Graphics Card: RADEON X600 256MB HyperMemory, 256 Mb
Hard Drives: C: Total - 476937 MB, Free - 393990 MB; F: Total - 305243 MB, Free - 26023 MB;
Motherboard: Dell Inc. , 0YC523, , ..CN708215ADH0IM.
Antivirus: McAfee Anti-Virus and Anti-Spyware, Updated: Yes, On-Demand Scanner: Enabled
 

More replies
Answer Match 60.06%

I have been used to using Word 97, but the company has upgraded me to 2003. I am using the Print Layout to create my documents, and when I create a hyperlink, the hyperlink shows up in underlined blue, but it won't work. It will work if I view the document in Reading Layout, but that doesn't do me any good, since that layout does'nt look anything like the Print Layout. Can anyone make any suggestions?
 

A:Solved: Word 2003 - Hyperlinks don't work in Print Layout

It works.
It's just that Microsoft, in its infinite wisdom, decided to make us Ctrl+Click for a hyperlink.

Otherwise, you can change the setting on your PC to NOT require the Ctrl key.
Tools-Options-Edit tab. Second checkbox on the right...

And don't you just LOVE that Reading Layout feature?
 

3 more replies
Answer Match 59.64%

Hi All,

My office is upgrading from Office XP to Office 2010. We have a dozen different macros written for Office XP. They are all Word documents. Each produces a different form. Some have only about a dozen fields to populate. Others have up to 100 different options.

These macros run great in Word XP but crash when run in 2010 with a variety of VB errors. All our users are running Windows 2007 with the latest service pack.

Is there an easy method to upgrade these macros to 2010 format, without having to learn enough VB programming to recode all of them? I have an MSDN subscription and one idea was to try a gradual upgrade - from Word XP to Word 2003, then Word 2007, then Word 2010 - just alot of testing VMs to set up...

Thank you,

Mike C.
 

A:Convert Word XP Macros to Word 2010

Can you provide some examples of the code that is failing and include some of the error messages you receive? The issue could be as simple as differences in the object libraries that are being used. Without seeing the code it would be hard to tell.
Rollin
 

3 more replies
Answer Match 57.12%

I would like a macro that will compare Accounting system data and Bank statement data. I am comparing the date and amount for an exact match. If there isn't a match, I need the macro to list the exceptions. I am using Windows XP.
 

A:Using Macros in Excel 2003

10 more replies
Answer Match 56.7%

Hi i'm working with microsoft word and trying to build a macro, unfortunately it keeps giving me an error, this happens when i try to save the file as an xml file without good syntax. This pops up a window which i have to click ok on. is there anyway to click okay on a pop up window in a macro? thanks in advance!

A:word macros

Coming from a programming perspective you would have to grab the window handle of the pop up window and close it that way. Other than that I'm not sure you will be able to surpress the window output or do much of anything else.

Good luck.

2 more replies
Answer Match 56.7%

Hello I need help with a word macro...

What i want to do with that :
- Go to a bookmark that refers to a table and the then split that table wherever I have a specific word. Then I want to enumerate those tables with numbers from 1 to 99.

-Go to a bookmark that refers to another table table and the then split that table wherever I have a specific word(it is the same word as above.Then I want to copy the header from the main table and paste as header of all the tables created. Then I want to enumerate those tables with numbers from 100 to 999.

- The last step would be to intercalate the tables I created in step one1 and the ones created in step 2 as follow:

Table 1
Table 101
Table 2
Table 102

and so on...

Any ideas is it too hard ?
 

More replies
Answer Match 56.7%

I'm new at macros and need help. I have a Word document that has form fields for name and address. I would like to create another Word document that uses the name and address on the first form and send it to the next form with a push of a button. Can anyone help me?

More replies
Answer Match 56.7%

Hello geeks, I'm not if anyone has made a thread about this but if I need help. So, I'm trying to make a one key for saving a document for a specific folder. I want to be able to save a doc that will prompt me to save to the specific day. Example; I'm writing a letter that need to be sent out 2 days from now, I want to save to a folder that will be be the date of. Please advise.

More replies
Answer Match 56.7%

Ok I am working at a company currently working on an ASP web page for internal use.

Some guy in the company decides (since I am the only available "IT" saavy person) to ask me a question about MS Word Macros.

He is creating a form in Word and when a person enters their info (i.e. First Name, Last Name etc.) it will be displayed on the 2nd page without them having to enter it again...

Ok maybe it is because I really REALLY hate word or because I have never used Macros but he went away a disappointed individual (not really) because I didn't have a clue how to help him.

ok I think thats it!
Gerbill
 

A:MS Word Macros - HELP

Not a macro.

On the form field, choose "calculate on exit"

On page 2, Insert-Cross Ref--Bookmark, and pick the bookmark name of the form field.
 

1 more replies
Answer Match 56.7%

Can you rename macros in Word 97? Mine are Normal.NewMacros.Macro1, etc. They take up too much room on the toolbar. I would like to change it to something like M1, M2, etc. Thanks.
 

A:Macros in Word 97

They don't even have to show a name. Go here and read ALL of step 2:

http://www.theofficeexperts.com/officevba.htm#WordVBA
 

3 more replies
Answer Match 56.7%

Dear All

I have been fighting with this macro for some time now and now request your help.

I have 1 single word file with numerous client statements. There is no page break as i have copied them from a txt file which has a digital identifier.

I want to create separate files for each client and the unique identifier after each client statement is "security.".The files have a unique client id which is always at a specific location.

The macro should
1. Search for the unique identifier between two clients
2. Copy all data between the first two identifiers
3. Open a word file and paste the copied data onto that file.
4. Save and Close the file with the file name being the client id. eg 10000022 as in the macro. the next file will have the next client id name.

So if i have 500 clients , i should be having 500 files. each of the files will have data as per the unique identifiers.

I have the following macro and request help pls.

Sub splitfiles()
'
' splitfiles Macro
' Macro recorded 10/2/2009 by ABC
'
Selection.Find.ClearFormatting
With Selection.Find
.Text = "client Id"
.Replacement.Text = "signature.^m"
.Forward = True
.Wrap = wdFindContinue
.Format = False
.MatchCase = False
.MatchWholeWord = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False
End With
Selection.Find.Execute
Selection.MoveRight Unit:=wdCharacter, Count:=2
Selection.MoveRight Unit:=wdCharacter, Count:=8, Extend:=wdExtend
Selectio... Read more

A:Macros for Word

14 more replies
Answer Match 56.7%

in word xp, how can you keep a macro from starting automatically when you start the program (specifically Adobe PDF maker), which i never use, and just clutters by taskbar. Cheers,

Christian K.
 

A:Word Macros

6 more replies
Answer Match 56.7%

Trying to create a template with text form fields but need the fields to be fixed so the ones below don't move down as I add text to the ones above. The only solution I can see is to run a macro on entry to each text form fields to position it. Is there any other solution? If not can anyone help me with the VB code and how to set it up.
 

A:word macros

No code necessary.

Generally, you use the properties of the form field to set the allowable number of characters to enter, right? Won't work for you.

Instead, here's what I do. For each "paragraph" I want to allow, suppose I want to restrict it to 1" high of text. Insert-Table, 1 column, 1 row. Set the height of the row to EXACTLY 1". You'll really want to type some text into it to find out a VERY nice height that will not cut off the bottom of line of text.

Anyway, this won't keep your people from entering extra text. But the won't see it if they just keep typing, and it will not force-break your page or even the 1" barrier....

Hope this helps!
 

3 more replies
Answer Match 56.7%

Hi im looking for some simple totorials to show to students about how to record and make macros in MS Word if anybody can help it would be greatiliy appreciated
Note: the students are real beginers and have never used macros before

thanks
Ben
 

A:Macros In MS Word

Try this

How to create a simple macro
 

1 more replies
Answer Match 56.28%

OK it's not my fault I am working on XP with Office 2003 (you never know work may catch up with the rest of the world one day!)

I am trying to pull a macro together for our sections watchlist so when someone enters "L" into a cell it will automatically shade it blue, "C" will shade it a different colour and so on and so forth. I have tried using conditional formatting but that only gives me the option of setting 3 conditions (4 if you count the default blank lol)

As it is I have 12 different options with 12 different colours to denote Leave, Courses, Duties, Sick etc, etc

Can anyone help. I have played about with the Macro recorder but it has confused me to the point of getting a headache and resorting to asking for help.
 

A:Excel 2003 Macros help needed!

does this help at all
http://www.vbaexpress.com/kb/getarticle.php?kb_id=90
 

3 more replies
Answer Match 56.28%

i am using macros to create charts on a 2nd sheet. i need to make 3 total and then move them to the right spot. the first two go without any issues however, the 3rd doesnt move or risize like it should. it seems like the problem is because i use the mouse to move the chart and the screen scrolls down. also, is there a way to assign the chart title with a block from the spreadsheet?

thanks
 

A:Solved: excel 2003 macros

16 more replies
Answer Match 56.28%

Can I ask for help in a similar vein to last post, I have another CSV file that’s down loaded
where text is in column D and I want to enter equivalent in column E as below which is used to build a pivot table on column E headings in correct order to match input journals, again varying number of rows each time file extracted.

Change formula to below for each type
D E
Layaway Part Payme to 9Layaway Part Payme
Gift Voucher sale to 8Gift Voucher sale
Sales without VAT to zSales without VAT
Visa / Mastercard to 1Visa / Mastercard
Cash to 1xCash
Layaway Part Payment Clearing to 3Layaway Part Payment Clearing
Gift Voucher Redemption to 4Gift Voucher Redemption
Credit note redeemed to 5Credit note redeemed
Till Differences to 6Till Differences
Cash to 1Cash
POS Payment/Outpayment. to 8POS Payment/Outpayment.
prod Sales to Zprod Sales
 

A:loops in macros Excel 2003

Again my question: what do the numbers stand for under what I imagine should be E?
 

1 more replies
Answer Match 56.28%

How do I enable macros for Outlook 2003? I am currently not using any macros for Outlook, but am using them in Excel 2003. When I try to run a macro from within Outlook 2003, I get the message: "The macros in this project are disabled. Please refer to the online help or documentation of the host application to determine how to enable macros".
 

A:Enable Outlook 2003 macros

What do you want to use Macros for in Outlook?
 

3 more replies
Answer Match 56.28%

Hello all..

Ok, I'm hitting the big leagues now...

I have an access file for students.

Now I want to get fancy and create a switchboard. On the switchboard, I want do do the following:
1) Open a report (easy..right?)
2) Print a report (need a macro?)
3) run a search for a particular student. I need an input mask (?) for the last name, first name, punch a button, and if he/she is there, their record would appear. If not, a dialog box that says we don't have 'em..
4) update student records (easy..add/edit form?)

So, this is what I think at the moment. Perhaps I'm getting too big for my britches...

Thanks for the assist!

all the best,

Mike
 

A:Access 2003 Switchboarding Macros

Mike, do you want to use Access's Switchboard or do as I do and have a Main Menu Form with Command Buttons?
If it is the latter then have a look at the Search Form database that I posted on Post #11 on your Thread.
http://forums.techguy.org/business-...ccess-2003-import-data-one.html?highlight=obp
 

3 more replies
Answer Match 55.86%

The company I work for has been getting a Word Macros Virus. I have checked in the normal.dot file to look for macros, but have been unsuccesful. Possibly because I'm not familiar with word enough to find the Macros that are enabled. We are for the most part running Win '98 with some using Win '95. I'm lead to believe its the Concept Macro Virus, by how its attaching itself after a file is being prompted to be saved. Please educate me!
 

A:Word Macros Virus

Boone: get a virus checker on everybody's PC. In the meantime, have everyone close Word and rename their normal.dot file to normal1.dot. If they've got macros in their normal.dot, they can copy them from normal1.dot by going to Tools-macro-macros and using the organizer button. It's pretty straightforward. Go to Tools-Options-General tab and make sure they have "macro virus protection" checked. If your company doesn't really use macros, tell them not to open files that give the warning until YOU have checked them out. Also, on the Save tab under tools-options, select "prompt to save the normal template" because then, when a macro HAS written itself to their normal.dot file, they'll be asked if they want to save the changes to the normal.dot file. Tell them not to! Changing toolbars and default fonts, etc., will also "change" the normal.dot file so make them aware that when they have done these kinds of things, they SHOULD save the changes to normal.dot.

I'll be writing an article for the next TSG newsletter that explains how to get rid of macro viruses in Word (above) and Excel. Look for it within the month--make sure you're a subscriber. I've put some good stuff about Office in the last two issues, print them out and make copies for your users (and yourself).
 

1 more replies
Answer Match 55.86%

I am fairly new to marcos in Microsoft Word.

I need to write a macro that asks for a starting number and an ending number from the user. The page will then display the first number and print that page and continue incrementing the number and printing out that page until it reaches the ending number. I have the printing function down, but need to display the incrementing numbers on these pages. Here is what I have as of now:

Sub NewMacro()

Dim startNum As String
Dim endnum As String
Dim x As Long
startNum = InputBox("Enter Start Number: ", , 1)
endnum = InputBox("Enter End Number: ", , 1)

For x = startNum To endnum
ActiveDocument.ActiveWindow.PrintOut

Next x

End Sub

Any help would be appreciated. Thanks.
 

A:Solved: Macros in Word

9 more replies
Answer Match 55.86%

Does anyone know where I can find a good tutorial on recording macros in Microsoft Word?
 

A:Macros in Microsoft Word

About.com's Guide to Macro Recording

http://wordprocessing.about.com/od/workingwithmacro1/l/blmacrointro.htm

Best questions on here, are related to direct questions, about a particular problem, the best way to learn about macros is to record them, and work out which bit of code does what, and then learn how to edit it, to do exactly what you want it to do. The best way is to record, google it, edit it, and come on TSG for solutions to problem you come up against.
 

3 more replies
Answer Match 55.86%

Guys,
I need to create a smart document using query boxes, fields and macros. The problem is that I never use macros before, anyone can give me a quick "know how"?

Gracias
Keet

------------------
I am here to stay!!
 

A:Word 2000 Macros know how

There is no quick "know-how" in creating macros. You can get a good start by recording a macro to perform your task.

Hit Start-Macros-Record new macro.
Name the macro, no spaces in name.
Click on Toolbar to place a button on the toolbar that will run your macro, hit keyboard to assign a keystroke to perform your macro.
Hit OK.
You should now be in record mode.
Perform any steps you would like a macro to do automatically.
Hit the Stop record button on the recording toolbar.

Things to be aware of:

In the first part of creating the macro, make sure you store the macro in normal.dot if you want it to be available for any document, or in "current document" if you're creating a specific file from which to run the macro(s).

Hope this helps.
------------------
~dreamboat~
Brainbench MVP for Microsoft Word
http://www.brainbench.com
 

1 more replies
Answer Match 55.86%

This problem is now solved. The author sent me a copy without the macro.

I am using MS word and Windows XP. I have a MS Word document that apparently has an imbedded macro that starts up when I open the file. How do I disable or shut off the macro?

Thanks to OBP for the try at helping but the problem appears more complicated. Here is more Information: The word document is a table/form that I have revised by deleting all but two pages to meet my needs. After I open the file/document a dialog box comes up to guide me through filing out the form. This is what I want to delete. The dialog box has a "cancel" button that I click on and the dialog box goes away and the form appears. Once the dialog box is gone I can start filling out the form. Here is how I tried to find the macro to delete it:

With the open document on my screen I click on Tools>Macros, but no macros are listed. Also, when I click on Tools>Macros>Visual Basic Editor>Macros no macros are listed.

The Macro must be hidden, but it has to be in the document somewhere to activate when I open the file.

Hopefully, this additional information will provide a clue to getting to the macro. If someone would like to look at the document or discuss this with me, my email is removed by moderator Anne Troy.

Thanks,

314kos
 

A:Disabling macros in MS word

6 more replies
Answer Match 55.86%

Greetings,

I am using Windows 7, Word 2007. Though I have some experience with Word macros, I have not been successful in deriving a macro that will re-position content throughout a document.

Here is an example of what I desire to accomplish:

BEFORE: 1999, No. 91 (Adj. Sess.),

AFTER: 1999, Adj. Sess., No. 91,

In this example, the macro would need to re-position "(Adj. Sess.)," and remove the parentheses.

In addition, the record in this example contains different enumerations following "No." -- e.g., "No. 44", "No. 157", etc. Wild cards for this wrinkle seem to be of no help, but I want to be sure I am not missing something.

Thanks for your kind attention and input.

q.b.

A:Word 2007 - Macros

Maybe this will help you: Record or run a macro - Word

1 more replies
Answer Match 55.86%

Is there a way of saving Word Macros prior to installing Office 2003 (other than the 'Save My Settings Wizard') which I asume saves the macros? How are the macros actually stored?
 

A:Loosing Macros in Word?

8 more replies
Answer Match 55.86%

Hello,
I just recently started worknig as a transcriber, adn was told how to set up a "macro" in Word using the autocorrect feature. I have had to input the macro three times, and it works immediately after I use it, but then when I go to use the macro on a new document, it won't work. Do I have to save it in a special way to get it to work in all documents. Please help!
Thanks in advance,
Julie
 

A:macros in Word 2010

Save it as a template file...
 

2 more replies
Answer Match 55.86%

For my job as an auditor I use my 10 key alot to format long numbers into tables in Word. I want to write a macro that will allow me to use the * key as a comma. I found this macro online, but when I run the macro it inserts a question mark with a square around it instead of a comma. Here is the macro I found. Any suggestions???? HELP!!!

Sub AssignCommaToAsterik()
CustomizationContext = ActiveDocument.AttachedTemplate
KeyBindings.Add KeyCategory:=wdKeyCategorySymbol, _
Command:=",", _
KeyCode:=BuildKeyCode(wdKeyNumericMultiply)
End Sub
 

A:Word 2007 Macros

Anyone?? Need answer ASAP to save alot of time!
 

1 more replies
Answer Match 55.86%

I use a form/letter template for various entries. Everytime I make new entries on my form I need to save it with the same name, in a location of my choice with a date stamp.
I need a SAVE AS macro in Word 2007 to do the following:
1. Prompt me where to save the file
2. Save the file with the same name and a date stamp.
Can you help?
Thanks
 

More replies
Answer Match 55.86%

Hello Good People of the Forum:

Whenever I attempted to open a Word file I get the attached message. I have no idea what a macro is. Thanks in advance for any help.

Regards
Powell Lucas

A:Macros in Word Documents

Did you create these Word files or did you download them from somewhere or did somebody send them to you?

9 more replies
Answer Match 55.86%

Hi all,

I'm just emailing to ask you guys a simple question. I understand that Macros are susceptible to infection from viruses, hence I have my virus scanner looking for any file that contains Macros - just so I can keep my eyes open for anything suspicious. I also know that Auto Macros in MS Word XP (AutoOpen, AutoSave) are particularly prone to becoming infected - therefore, it would be great if someone could tell me what file they are contained in, so I know where to look during a virus scan if I am alerted to any problems.

Many thanks,
PCHammer

More replies
Answer Match 55.86%

Hi

I?m using MS Word 2010
I made a file called normal.file and put in some macros to be used in the ribbon
I?m having problems with some of the code. I tried to use what I use for Excel, but it doesn?t work.

I want to have a ribbon button to save and close:

Sub save ()
yesno = MsgBox(" Save and Close?", vbYesNo)
Select Case yesno
Select Case yesno
Case vbYes
ActiveWorkbook.Save
ActiveWorkbook.Close
Case vbNo
End Select
End Sub

I also want a button to make all of the text that I highlight into a lower case.
In excel, I highlight a cell and use this

Sub lowercase()
Selection.Name = "here"
For Each x In Range("here")
x.Value = LCase(x.Value)
ActiveWorkbook.Names("here").Delete
Next
End Sub

I use this to put in today?s date at the cursor

Sub date ()
ActiveCell.Value = Date
'ActiveCell.FormulaR1C1 = "=today()"
Selection.Value = Selection.Value
End Sub

How would I do it in word ?

Sorry, I can't find any "code brackets:

Mike
 

More replies
Answer Match 55.86%

Quick question -

A client of mine currently has a macro setup on their toolbar to automatically do a bin-print, ie brings up a box asking how many letter headed and how many plain prints they want - it then does two print jobs, one from each relevant tray. They have a new printer however, that is completely ignoring this setting and prints two jobs, both from the same tray.

I have no experience with macros, so can someone tell me either how to edit the macro (called normal.binprint.binprint), or create a new one with the right values.

Many thanks,
PS - If you select Macros, Binprint, Step Into, you get the following message "project is unviewable"

Relevant?
 

More replies
Answer Match 55.86%

Macros in Word 2010
Are they safe to use?
Thank You,
Gary
 

A:Macros in Word 2010

Hi Gary,
You shouldn't duplicate your posts, one is enough.
When you go to a restaurant, do you trust the cook?
That's how asfe macros are, you know who sent you the file so do you trust him / her?
 

1 more replies
Answer Match 55.86%

I am working in a lab and trying to record and run macros. On some machines, I go to TOOLS>>MACROS>>MACROS and I get a pop-up window, everything in fine. But, on some machines, I go through the same steps and the window does not pop up. What should I do?
 

A:Problems with Macros in Word

Try Tools-Macro-Security and make sure it's set to low or medium.

Open any doc and hit Alt-F11 to make sure you can get into the VB Editor. Maybe VBA wasn't installed on those PCs.
 

1 more replies
Answer Match 55.86%

I received this in an email today from a friend.
I don't use macros so I'm no help.
Does anyone know how to do this...
-----------------------------------------------------------------
Do you use macros in Word much? I find that they are now so sophisticated
that they may be good for programmers and businesses who want very
sophisticated customized applications but I can't do many of the simple things
I use macros for and I don't want to spend days or weeks studing visual basic
I want to paste the clipboard contents (in this case to create a custom footnote marker)
but the macro always pastes the original clipboard data present when the marco is
created, not the current clipboard. Any idea of how to do this? Of course I looked on
Microsoft's site and could not find anything intelligible.
There must be a way to do this but I can't find it.
 

A:macros in word issue

True.
A PITA to learn how to WRITE macros.

Tell this person to use an autotext entry instead.
Or have them email me at [email protected]
 

2 more replies
Answer Match 55.86%

I am not sure whether someone out there can help me with this.

We design extensive number of Word templates that we distrubute throughout the department to fill in content. Now in our case this is not straight template such as fax/letter template where you might have control over where/what user will type. With our documents, the content varies widely and it's difficult to know what the user will want or need to input (tables, figures, etc.)

So in other words, they are not simply filling in content..they are creating documents. We just providing them with the required guidelines.

Here is what I want to automate:

We get these lengthy documents that user creates. Our job is to ensure they follow the required guidelines for format and content.

When it comes to formatting:

We spend hours screening through lengthy documents to conduct simple MS Word formatting such as checking whether styles are applied, margins are set, and etc. It has become rather tedious process and time consuming, something folks with our bkg shouldn't be doing.

I am trying to come up with a solution to cut down this formatting task. I am hoping to somehow automate the process to eliminate the manual time required in formatting documents.

I am trying to figure out the best way of going about doing this.

I have thought of two options and I don't know whether they are feasible and which one would be easier or ideal to implement:

1) To have templates with macros so that we don't ... Read more

A:Word Macros and Templates

It depends on what formatting you're going to have to do. It would be easy enough to record a macro that selects the entire contents of a document, formats the fonts, paragraphs, borders, removes any styles (or adds one), sets standard margins and print areas, page orientation, indents etc etc
You could then create a button and stick it on one of your toolbars and formatting would be a one-click deal.

However, you might find that you don't want to be selecting and formatting all of the data as in doing so, you could lose certain specific formatting that you want to keep - e.g. if you format the font of a whole document, the formats of items like sub-titles and bulleted lists can be lost.

Using tools like AutoFormat can be useful (and could be used as part of the macro), but you might be trusting the machine to know what's best and it isn't always what you intended.

Gram
 

2 more replies
Answer Match 55.86%

hi, new member, i use a word document for health and safety report for all my engineering projects. (cdm) the document is standard with changes on certain pages. I have written a macro that takes me to page two. I would like to change the necessary text then automatically be taken to next page and do the same until i print at the end.
can anyone assist or point me in the right direction? many thankd
 

More replies
Answer Match 55.86%

Macros in Word 2010
Are they safe to use?
Thank You,
Gary
 

A:Macros in Word 2010

Hi Gary,
You shouldn't duplicate your posts, one is enough.
When you go to a restaurant, do you trust the cook?
That's how asfe macros are, you know who sent you the file so do you trust him / her?
 

2 more replies
Answer Match 55.86%

ok here goes nothing.... i'm a big noob at excel macros and i shurelly would need a little help.. i have a table (it has like 40-50 collmns amd 2000-3000 rows).... on D collumn i have a lot of names (like 20)...

i need a macro that splits my original excel table (or only that sheet) in 20 smaller tables (or sheets) and the criteria should be the names from that collumn

the names from that collumn are not in any order.... so bassiclly i could sort the table by name (starting with that collumn) and this can be done using a macro (i can record one while i push the button ) but how do i split my table in 20 different tables???

if anyone wold like to help me i'ld much apreciate it

thank you
 

A:Solved: macros in office excel 2003 sp3

16 more replies
Answer Match 55.44%

Hi all, my first time on a forum. Could someone suggest a good entry tutorial to help demystify macros in Microsoft's Word software. The least technical the better. Thankyou in advance.
 

A:word macros tutorial for beginer

I would say the best way to approach this would be consider the particular task that you want automated, and get to work firstly using the most simple way, and that is recording the steps. Then play them back and see how they work. A quick search gave me this site, and it looks reasonable enough.
http://www.officeletter.com/favtips/wordmacros.html

A macro is a series of commands executed automatically. Macros normally pay back the time and effort invested in creating them many times over.

You do not need to 'demystify' the whole caboodle in order to get a collection of useful macros working for you. You just need to think about what tasks you want to do. The net is full of examples and helpful folk who'll help you if you hit snags.
 

2 more replies
Answer Match 55.44%

I have a WORD template document that appears very temperamental. I believe the form was created from a standard WORD document and we subsequently added some macros and then saved it as a *.dotm file (template with macros). The macros in the form do not work if you open the file with a standard double click. You need to right mouse click and select OPEN. Then the macros work. Also, sometimes when uploading the file it also appears to lose its functionality. Hard to understand what is causing the problem. Would like to have the file in such a way that the macros always work no matter how the form is opened.

Do we need to create the entire form over again from scratch as a template with macros ? Or better what do we need to do the existing form to insure the macros work all the time. The form is already protected.
 

A:Word Template with Macros not always working

Hi, welcome to the forum.
Are the macro's enabled by default?
Since you speak of *.dotm files I assume that hyour version wof Word is at least 2007 or newer
 

2 more replies
Answer Match 55.44%

On my networked office PC, I made a number of Word 2000 macros. They are updating our computers. How can I make sure the new PC Word will have my old Word macros?
Also ditto for Autocorrect entries?
Thanks.
 

A:Moving Word 2000 Macros To New Pc

Where are the macros attached? If the macros are attached to your Normal.Dot file, you should be able to copy Normal.Dot and replace the one that resides on the new machine.

Here is a link to export your autocorrect entries

http://word.mvps.org/FAQs/Customization/ExportAutocorrect.htm
Rollin
 

1 more replies
Answer Match 55.44%

I would like to be able to print out an alphabetical list of all the macros and auto corrects I have created in my system. I know there must be a way. Anybody have any idea?
 

A:Word Macros & Auto Corrects

16 more replies
Answer Match 55.44%

I have been having problems with more than half my machines, some are laptops and some are networked desktop computers. I am having my students record macros for basic formatting. Half the tasks we try give us errors or simply don't complete (For example, if I center all the text, change the background color and add a page border, the background color simply won't change even though I can see it in the code). I have had a particular problem with inserting the student name into the header of the document. They need to be able to do this in particular because they are taking Cambridge Exams and might be asked to do it. The first line is the line of code that is highlighted and gives us errors:

ActiveDocument.AttachedTemplate.BuildingBlockEntries(" Blank").Insert_Where:=Selection.Range, RichText:=True
Selection.Delete Unit:=wdCharacter, Count:=1
Selection.ParagraphFormat.Alignment = wdAlignParagraphRight
Welection.TypeText Text:="Student Name "

Please help !
 

A:Teacher needs help with Macros Word 2007

6 more replies
Answer Match 55.44%

I am new to TSG and have a problem related to enabling macros in WORD.
Every time I open Word 2002 I get a message telling me that I need to enable my macros. When I bypass the message it allows me to proceed.
When I have finished and want to close down the same message is posted .
I would very much like to have some advice as to how to do this enabling as I cannot find any way to solve the problem.
 

A:Solved: Enabling Macros in WORD

Word asking you if you want to enable macros is a good thing. Some viruii and malware use macros. You can lower the security setting if you don't want to asked every time, but your open the computer up to possible security problems.

To change macro security settings:
Tools > Macro > Security...
 

2 more replies
Answer Match 55.44%

Hi,

I can record simple search and replace macros in word 2007 but my abilities stop there.

Back in the days when I was using Word Perfect I could easily write macros that search for a string, exit the search function, select all text until a different string occurred, and then marked that text red, and then repeat until end of document.
In that way I could easily, e.g. in text formatted as below, find and colour everything Bob says red. I would search for "Bob:" turn selection on, move and select everything until the next ^p (which signals that Bob has stopped speaking), change formatting to red, and then repeat until end of document.

Ted: Hi, Bob. How are you?
Bob: Fine. And you?
Ted: I've got a splitting head ache.
Bob: You-d better have an aspirin, then.
// ...etc etc etc... //


In MS-Word 2007 I have not been able to perform such automation, and I have no luck googling for tutorials either. I would appreciate if someone could point me in the right direction.

Thanks!

A:writing macros for word 2007

Hope this help...


Code:
Sub FindBob()
'
' create a loop that continues until the end of the doc
Do Until ActiveDocument.Bookmarks("\Sel").Range.End = _
ActiveDocument.Bookmarks("\EndOfDoc").Range.End

' find Bob:
Selection.Find.ClearFormatting
With Selection.Find
.Text = "Bob:"
End With
Selection.Find.Execute

' Once Bob: is found then select to the paragraph mark
Selection.GoTo what:=wdGoToBookmark, Name:="\para"

' format the selected para
Selection.Font.ColorIndex = wdRed

' move insertion point to the end of the para so the find can continue
Char = Selection.EndOf(Unit:=wdParagraph, Extend:=wdMove)
Loop
End Sub

1 more replies
Answer Match 55.44%

I am running MS Office 2003 and am trying to create a Word macro to open a main document with an attached data source, execute a merge and save the resulting document. I just get an error message: " Run time error 5852, Requester object is not available". I have been able to create a macro to execute a merge and save the resulting document on a main document that I open normally but not when opened by the macro itself. What am I doing wrong?
 

A:Word Macros and Mail Merge

8 more replies
Answer Match 55.44%

Hello,

I'm new to macros and have recorded an AutoOpen one for a particular document that is based on a custom template. When I save the document containing the AutoOpen macro, close it and try to re-open it, I receive a VBA error message that macros are disabled for the document. This tells me that it is actually trying to run the macro, but is unsuccessful.

Any suggestions on a 'quick-fix' for enabling these macros?

Thanks in advance.
 

A:Word 2000 Macros disabled

10 more replies
Answer Match 55.44%

Any idea how can I resolve this without having to learn Visual Basic?
 

A:Outlook 2010 - Cannot use Word Macros

Your post is very vague so if you want help you will need to provide more details. Is this an error you are receiving?

Rollin
 

3 more replies
Answer Match 55.44%

Hello,

I recently switched from Word and Outlook 2003 to 2013. I was able to migrate my macros over from 2003 Word to 2013. However I cannot figure out how to use macros in Outlook 2013.

My macros are only things like signatures, long text that I don't want to have to retype all the time, etc. - nothing fancy.

In 2003 Outlook used Word as the editor I suppose so the macros recorded in Word also worked in Outlook. From what I have gathered so far, it seems that 2013 Outlook does not use the same "word editor" so the macros for Word will not run or appear in Outlook 2013.

Can anyone tell me how (if it is possible) to use my 2013 Word macros in 2013 Outlook? If not, can anyone tell me how to record Macros in Outlook 2013? I think VBE is an option but I don't have a clue about that. I only know how to record macros in Word.

Any advice would be appreciated.

Thanks!
 

A:2013 word and outlook macros

6 more replies
Answer Match 55.44%

I did a macro no a excel workbook using a userform to marge a document with a word file.. it work all right but after merging two files... and when i close the word file and the excel file word file get closed permanently but the excel runs application even though it get closed what should i do???....................
 

More replies
Answer Match 55.44%

I don't know where else to turn for this problem. I have surfed the Web and combed the MS site, but there is no reference to it.

The problem is simple: The macros that I record when I have Word open are deleted or have disappeared when I close out of the program. The next time I open Word, I have to re-record the macros. This is a major pain.

Any ideas?
 

More replies
Answer Match 55.44%

Someone once told me about a macro in MS Word, where if the admin took away the Command line, you could write a small macro to bring it back...

Is there some truth to this, or was I supplied w/ false info?
 

More replies
Answer Match 55.44%

Hey everyone -

This is my first post on Tech Spot, but I've used this forum to look up many issues that I have at work (I'm a desktop technician for an insurance company).

Currently, I have a user that runs a macro in Word 2002 (Office XP) that opens and closes several Word windows to merge letters together and then it will suddenly crash. It seems like its always in different spots as well.

Yesterday I decided to put Process Explorer from Sysinternals on the machine and have it watch Word. When word crashed I created a full dump of the WINWORD.EXE process. From what I can tell it crashes on a VBE6.DLL (I don't have much experience with dump files). I've attached the dump file with all the information. Any help will be greatly appreciated.

Thanks -

Lurch
 

A:Word (Office XP) Crashes on macros

Hi Lurch,

Have you tried re-writing the macro from scratch? It might simply be that the Macro is caught in an endless loop somewhere due to a SYNTAX error.


james
 

4 more replies
Answer Match 55.44%

Does anyone knoow any good tutorials on recording macros in Word
 

A:Recording Macros in Microsoft Word

Welcome to the forum. I have not seen an all encompassing tutorial on recording macros. But, an easy way of starting recording of a macro is to double-click on the "REC" button on the status bar or Word. It will then prompt you to name the macro. Macro names do not like spaces or special characters, so I advise you to name it with only characters.
 

3 more replies
Answer Match 55.44%

Hi

I have an issue with Microsoft Word 2000. I work with it and use macros as my "life source," lol. Every so often all of my macros will just be randomly dumped. So I go through and remake them all (3,000 of them). Please, if there is any way, could someone tell me how to restore those macros before I pull out all of my hair? I have tried macro security settings and also detect and repair, neither worked. Thank you much!

vprrchk
 

A:Macros in Microsoft Word 2000

7 more replies
Answer Match 55.44%

I've got some Word Macros on my old computer (still working and on the network) that I want to transfer to the new one. How do I do that?

Old is Word 97 on Win98; new is Word 2000 on WinXP Pro.

(PS: I'm not asking how to transfer files, either by disk or over a network. I need to know what files to look for, what directory to transfer them to, or anything else I need to do, like an export/import operation.)

Thanks!
 

A:Transferring Word Macros to New Computer

The file you are looking for is normal.dot. It will transfer all your toolbars, macros, etc. I'm not sure if everything will transfer or if it will work right since you are going from 97 to 2000, however. But it won't hurt to try.

You'll need to rename the normal.dot on the new computer to something such as normalold.dot. Then paste in the normal.dot from the other computer. If it doesn't work or makes Word weird since it is a newer version, just close Word, delete the normal.dot file, and open Word. It will automatically create a new normal.dot for you.

Hope this helps.
 

3 more replies
Answer Match 55.44%

I have a lot of macros in Word 2003, and I was thinking that there must be a way to list them all, together with their triggers. Word has a way of making the triggers vanish at the drop of a hat, which forces me to add them again one by one. This would be much easier if I could see them in a list.

Does anyone know a way to accomplish this?

Lily Ossendrijver
 

A:I'd like to list all macros in Word, with their triggers.

I have been looking for the same code. I found these links but have not tried them yet.

http://stackoverflow.com/questions/3922772/return-a-list-of-all-macros
http://support.microsoft.com/kb/262961#appliesto

Hope they work for you
 

2 more replies
Answer Match 55.44%

I have had a hard drive failure. I had backed up settings using MS Backup. On another drive I ran restore. I have not been able to find any of the macros I built in MS Word. I have those marcros except for the two or three done in the last month or two. If MS Backup copies macros, how do I find the macros when the restore is completed?
 

More replies
Answer Match 55.02%

Hi all,

I've got a series of Excel 2003 spreadsheets with macros. They run just fine on a Windows XP machine. However, we recently moved them to a Windows 7 Pro machine. We still run them in Excel 2003, only now on a Windows 7 system. Problem is, they don't run right. No errors, but the one that is giving me grief needs to read from a csv text file. I don't thinki it is opening and/or reading the input fule. I don't understand why.
Like I said, everything runs OK on WinXPSP3. I think I have all of the permissions set correctly. UAC is turned off and Elevated priveleges is turned off as well.

Anyone have any ideas?

Thanks in advance.

A:Excel 2003 Macros do not run correctly on a Windows 7 system.

Hi Honu425

According to Windows 7 Compatibility Centre, it is compatible with Excel 2003 with Service Pack 3. Do you have Office Excel SP3 installed?

http://www.microsoft.com/windows/compatibility/Windows-7/en-us/Details.aspx?type=Software&p=Microsoft%20Office%20Excel%202003%20Service%20Pack%203&v=Microsoft&uid= 11&l=en&pf=1π=6&s=office%20frontpage%202003&os=32-bit

1 more replies
Answer Match 54.6%

Hi guys,

Im currently undertaking tertiary education and have to start at the beginning unfortunetly. This post is for part of a project:

Sam wants some information on recording macros in Microsoft Word. Find an internet forum and ask if anyone knows any good tutorials on recording macros in Word."

Thanks guys!

-Steel
 

A:Solved: Recording Macros in 2007 Word

9 more replies
Answer Match 54.6%

Hey guys...

I was wondering if anyone can help me with some really good tutorials on recording macros in Microsoft Word.

I appreciate any responses to good sites for tutorials on this...

Thanks heaps
Leis33
 

More replies
Answer Match 54.6%

After creating macros, I can view the list by going to Tools > Macro > Macros. That displays the names I gave the macros, but not the shortcuts.

Is there any way to view the keyboard shortcuts for the individual macros? Aside from keeping an external list, there seems to be no way to know what the are.
 

A:Solved: Keyboard shortcuts for Word macros

In Word

Click on Tools > Customize...

In the "Customize" window that opens, click on the "Keyboard..." button at the bottom.

In the "Customize Keyboard" window that opens, look at the Categories window on the left. Scroll down past the dotted line to "Macros" and click on it.

A list of macro names will appear on the right.

Click on each macro name in turn and see what shows up in the Current Keys box.
 

2 more replies
Answer Match 54.6%

How does one share a customized tool-bar which contains custom tool-bar commands with other users via a network? Also how does one copy this customized tool-bar for a home pc or laptop? The tool-bar needs to be available as a option in the Normal template.
 

A:Word XP share customized toolbars & Macros

8 more replies
Answer Match 54.6%

I would like to know if there is a way to convert wordperfect templates that contain macros over to MS Word,and if so how can I do this without loosing any of the form and macro prompts, your help with this will be greatly appreciated.
Thanx
 

A:Converting Wordperfect docs w/macros to Word

11 more replies
Answer Match 54.6%

Okey here is what i need help with, ive tried everything i can thing of.

My excel document has 3 sheets, and i have a macro to compile some logs on the first two.(excel macro).

on the last page i have an embeded word document, and i have a macro written for it on my pc.

The problem is i need to distribute the 3 page log to a lot of people, and when i send it, it doesnt send the macros for the embeded word document.

any help would be greatly appreciated .
 

More replies
Answer Match 54.6%

I receive four different kinds of documents that I need to comment on extensively. I use a lot of macros, and my list is getting too long to be useful.

Using Word 2007, is there any way to divide my long, unruly list of macros into four separate lists, each of which could be used with one of the four types of documents?

I've tried searching for help and I'm either using the wrong terms, or this is nowhere nearly as straightforward as it seems like it should be.

Any help would be very much appreciated.

Thanks!
 

A:Macros for different document types in Word 2007

12 more replies