Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-03-2015, 01:02 PM
MacroMess MacroMess is offline Word 2010 New maros - debugging needed Windows 8 Word 2010 New maros - debugging needed Office 2010 32bit
Novice
Word 2010 New maros - debugging needed
 
Join Date: May 2015
Posts: 3
MacroMess is on a distinguished road
Default Word 2010 New maros - debugging needed

Hello



Can some kind soul help me - or tell me where to go to debug/unscramble (i.e. make operational) the "new macros" in my Word template.

I'm not a programmer - someone knowledgeable could sort this out quickly I'm sure.

Begging ....


Pete
Reply With Quote
  #2  
Old 06-03-2015, 02:19 PM
Charles Kenyon Charles Kenyon is offline Word 2010 New maros - debugging needed Windows 8 Word 2010 New maros - debugging needed Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,140
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Newmacros indicates recorded macros.

They should be stored in your normal template and available in all documents.

What, seems to be the problem?
Reply With Quote
  #3  
Old 06-04-2015, 12:40 AM
MacroMess MacroMess is offline Word 2010 New maros - debugging needed Windows 8 Word 2010 New maros - debugging needed Office 2010 32bit
Novice
Word 2010 New maros - debugging needed
 
Join Date: May 2015
Posts: 3
MacroMess is on a distinguished road
Default

Hi Charles

Thanks for your interest: I get an error message - see attachment. A person competent in VBA needs to sort these marcos out - there's only about 3-4.

Thanks

Peter
Attached Files
File Type: docx ErrorMessage01.docx (168.7 KB, 8 views)
Reply With Quote
  #4  
Old 06-04-2015, 04:40 AM
Charles Kenyon Charles Kenyon is offline Word 2010 New maros - debugging needed Windows 8 Word 2010 New maros - debugging needed Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,140
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

I'm sorry. You still haven't given us much to work with. While the error message is a start, no one is going to be able to tell you which lines of your macros are causing a problem without seeing the macro and knowing the purpose of the macro.

I fiddle with vba, I am not a competent programmer. I am a lawyer.

Ambiguous name means that the name has been used in multiple places in different ways rather than just referring to one thing.

Notes on using this forum:

If you click on the "Go Advanced" button at the bottom you can attach a screenshot using the paperclip icon. You do not need to encapsulate it in a separate Word document.

If you are posting a macro, if you surround it with hash tags # of code and /code it will format correctly. Thus:

Code:
This is a holder for vba code.
Reply With Quote
  #5  
Old 06-04-2015, 05:51 AM
gmayor's Avatar
gmayor gmayor is offline Word 2010 New maros - debugging needed Windows 7 64bit Word 2010 New maros - debugging needed Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,106
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

There were no macros in the document and the macro in the illustration is in error because the highlighted line that names the macro 'Sub HideTextDoubleBrackets' is a duplicate of the previous line. No doubt there are two 'End Sub' lines also.

Add Option Explicit (if not already present) to the top of the module and click Debug > Compile Normal.

See http://www.gmayor.com/installing_macro.htm
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #6  
Old 06-04-2015, 06:42 AM
MacroMess MacroMess is offline Word 2010 New maros - debugging needed Windows 8 Word 2010 New maros - debugging needed Office 2010 32bit
Novice
Word 2010 New maros - debugging needed
 
Join Date: May 2015
Posts: 3
MacroMess is on a distinguished road
Default

Thank you Charles and Graham for your help. There were indeed two macro names - latter of which I finally summoned up the courage to delete. And the macro now works. I have also deleted some attempts at macros which didn't work - cleaning things up a bit.

Since the experts are here, 2 questions:

-How can I create a marcro to delete MetaData (document created by, last saved by etc.) in a single click?
- How do I combine 2 existing marcos and finally F12 (save as) into a single macro?

Thanks for any help you can offer.

Peter
Reply With Quote
  #7  
Old 06-05-2015, 09:48 AM
Charles Kenyon Charles Kenyon is offline Word 2010 New maros - debugging needed Windows 8 Word 2010 New maros - debugging needed Office 2013
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,140
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

"Writing Word Macros" by Steve Roman

Macros and VBA (Visual Basic for Applications)

Your second task requires opening the VBA editor and moving the guts of one macro into the second. Removing all metadata is beyond my capabilities.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Word 2010 New maros - debugging needed Help needed on Word ini files wordini Word 6 02-23-2014 09:22 PM
URGENT HELP NEEDED: Strange boxes over header area in Word 2010 zee_shah Word 1 10-31-2013 09:41 AM
Word 2010 New maros - debugging needed What is this box? Word expert needed! dkester Word 1 10-04-2013 02:42 PM
Boston Word Expert Needed pmarc Word VBA 0 04-03-2013 05:36 PM
Help needed with printing in Word sophieb Word 0 11-16-2010 12:52 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:24 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft