Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #31  
Old 09-21-2012, 07:50 AM
muster36 muster36 is offline Macro errors Windows 7 64bit Macro errors Office 2010 32bit
Novice
Macro errors
 
Join Date: Aug 2011
Posts: 23
muster36 is on a distinguished road
Default

Point taken! But if mother was new to area and country and did not speak the language, she would need much more help.

Is this what you need?

Macro_MM.docx



LETTER.doc
Reply With Quote
  #32  
Old 09-21-2012, 04:01 PM
macropod's Avatar
macropod macropod is offline Macro errors Windows 7 64bit Macro errors Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

No, neither of those files is any good. I need one that contains the code module that's generating the error. Neither of those files has a code module (FWIW docx files cannot have code modules. For Word, only doc, docm, dot and dotm files can have code modules).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #33  
Old 09-24-2012, 05:56 AM
muster36 muster36 is offline Macro errors Windows 7 64bit Macro errors Office 2010 32bit
Novice
Macro errors
 
Join Date: Aug 2011
Posts: 23
muster36 is on a distinguished road
Default

Where do I find the Code Modules?? The File I sent was a *.doc file
I am out of my depth - which is probable very obvious. Perhaps I should drown in my sea of ignorance and leave you in peace!
Reply With Quote
  #34  
Old 09-24-2012, 09:09 PM
macropod's Avatar
macropod macropod is offline Macro errors Windows 7 64bit Macro errors Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

When you run the code and it fails, if you press 'Debug', the vb editor opens with the errant line highlighted. On the left, should be a list of 'Projects'. If you cancel the debug mode and click on the Project window, a particular code module should be highlighted. The filename immediately above that is the one for the file containing the macro. That is the file I need.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #35  
Old 09-25-2012, 03:41 AM
muster36 muster36 is offline Macro errors Windows 7 64bit Macro errors Office 2010 32bit
Novice
Macro errors
 
Join Date: Aug 2011
Posts: 23
muster36 is on a distinguished road
Default

I try to run the macro by View/Macro/ViewMacros/highlighting the macro 'MMM' and /Run. I then get the error message. Closing that error window I then press Debug and nothing happens. No highlighting and there is no list of Projects. but the error Macro is as follows

Code:
Sub MMM()
'
' MMM Macro
'
'Call OpenDoc("E:\DOCUMENTS\MMM\LETTER.doc")
Selection.MoveDown Unit:=wdLine, Count:=6

End Sub


Sub OpenDoc(StrDoc As String)
Documents.Open FileName:="StrDoc", ConfirmConversions:=False, ReadOnly:= _
  False, AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate:= _
  "", Revert:=False, WritePasswordDocument:="", WritePasswordTemplate:="", _
  Format:=wdOpenFormatAuto, XMLTransform:=""
I shall re copy this outside the code brackets and so it should show just as text if that makes any difference


Sub MMM()
'
' MMM Macro
'
'Call OpenDoc("E:\DOCUMENTS\MMM\LETTER.doc")
Selection.MoveDown Unit:=wdLine, Count:=6

End Sub



Sub OpenDoc(StrDoc As String)
Documents.Open FileName:="StrDoc", ConfirmConversions:=False, ReadOnly:= _
False, AddToRecentFiles:=False, PasswordDocument:="", PasswordTemplate:= _
"", Revert:=False, WritePasswordDocument:="", WritePasswordTemplate:="", _
Format:=wdOpenFormatAuto, XMLTransform:=""
Reply With Quote
  #36  
Old 09-25-2012, 11:55 PM
macropod's Avatar
macropod macropod is offline Macro errors Windows 7 64bit Macro errors Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

It's just wasting your time and mine continually going back and forth with the same content. Until you can post a document containing all the code, I'm not going to waste any more of my time on this issue. At the very least, I would expect to see both the code you started out with, or the code I first posted, plus the code you're having trouble with.

If you don't know how to identify which document contains your code module, despite me telling you how to do so, find someone who does.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #37  
Old 09-26-2012, 08:14 AM
muster36 muster36 is offline Macro errors Windows 7 64bit Macro errors Office 2010 32bit
Novice
Macro errors
 
Join Date: Aug 2011
Posts: 23
muster36 is on a distinguished road
Default

I am very grateful for your continuing patience in this saga which has been very frustrating for us both. I will leave this post now as, I agree, it is getting us nowhere. Thank you for all your input.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Errors in Outlook.pst Rik_StHelens Outlook 0 12-20-2010 09:40 AM
Strange errors omirza Excel 0 02-05-2010 01:30 PM
Macro errors Encryption XOR - any errors??? Word Doc Word 1 10-08-2009 12:57 AM
COM Automation Errors ivanm Word 0 03-23-2009 07:02 PM
How do you fix ost in use errors? enviroko Outlook 0 10-23-2008 09:49 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:57 PM.


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