Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Macros word 2007 run time error 4605
Macros run time error 4605 the method or property is not available because
the clip board is empty or not valid. I get the above message when I paste two pages of text in to a macro I'm recording and formatting. I get the message when I restart my computer I usually copy the text before I start the recording and paste it in once I start recording. Can anyone help with this? I would like to get rid of the error and have a functional macro |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Macros word 2007 run time error 4605
Post your macro code with a description of what it is supposed to do. We
cannot help debug it if we don't know what it is? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "wordwordy" wrote in message ... Macros run time error 4605 the method or property is not available because the clip board is empty or not valid. I get the above message when I paste two pages of text in to a macro I'm recording and formatting. I get the message when I restart my computer I usually copy the text before I start the recording and paste it in once I start recording. Can anyone help with this? I would like to get rid of the error and have a functional macro |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Macros word 2007 run time error 4605
Thanks Graham.How do I post a Macro code then? It was suppose to just add
some existing pages from a doc into a macro and some text and save it with a bit of formatting. when I turn my computer off and and log back in I then get the error message in word when I click on the button to access the Macro "Graham Mayor" wrote: Post your macro code with a description of what it is supposed to do. We cannot help debug it if we don't know what it is? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "wordwordy" wrote in message ... Macros run time error 4605 the method or property is not available because the clip board is empty or not valid. I get the above message when I paste two pages of text in to a macro I'm recording and formatting. I get the message when I restart my computer I usually copy the text before I start the recording and paste it in once I start recording. Can anyone help with this? I would like to get rid of the error and have a functional macro . |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Macros word 2007 run time error 4605
Copy the code from the VBA Editor and paste it into your message.
-- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "wordwordy" wrote in message ... Thanks Graham.How do I post a Macro code then? It was suppose to just add some existing pages from a doc into a macro and some text and save it with a bit of formatting. when I turn my computer off and and log back in I then get the error message in word when I click on the button to access the Macro "Graham Mayor" wrote: Post your macro code with a description of what it is supposed to do. We cannot help debug it if we don't know what it is? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "wordwordy" wrote in message ... Macros run time error 4605 the method or property is not available because the clip board is empty or not valid. I get the above message when I paste two pages of text in to a macro I'm recording and formatting. I get the message when I restart my computer I usually copy the text before I start the recording and paste it in once I start recording. Can anyone help with this? I would like to get rid of the error and have a functional macro . |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Macros word 2007 run time error 4605
Do you mean the visual basic code?
"Graham Mayor" wrote: Post your macro code with a description of what it is supposed to do. We cannot help debug it if we don't know what it is? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "wordwordy" wrote in message ... Macros run time error 4605 the method or property is not available because the clip board is empty or not valid. I get the above message when I paste two pages of text in to a macro I'm recording and formatting. I get the message when I restart my computer I usually copy the text before I start the recording and paste it in once I start recording. Can anyone help with this? I would like to get rid of the error and have a functional macro . |
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Macros word 2007 run time error 4605
Yes. Macros are written in VBA.
-- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "wordwordy" wrote in message news Do you mean the visual basic code? "Graham Mayor" wrote: Post your macro code with a description of what it is supposed to do. We cannot help debug it if we don't know what it is? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "wordwordy" wrote in message ... Macros run time error 4605 the method or property is not available because the clip board is empty or not valid. I get the above message when I paste two pages of text in to a macro I'm recording and formatting. I get the message when I restart my computer I usually copy the text before I start the recording and paste it in once I start recording. Can anyone help with this? I would like to get rid of the error and have a functional macro . |
#7
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Macros word 2007 run time error 4605
Okay this is the code. I have removed some personal information and replaced
it with the word Personal Sub Personal() ' ' Personal Macro ' ' Selection.TypeText Text:= _ "I am an honest, conscientious person. I have complete confi" Selection.TypeText Text:= _ "dence in the work my work and I have always been a good team" Selection.TypeText Text:= _ " player and communicator in the work place. I have worked u" Selection.TypeText Text:= _ "nder pressure in the past but always managed to achieve exce" Selection.TypeText Text:="llent results despite the extra pressure." End Sub Sub test() ' ' test Macro ' ' Selection.PasteAndFormat (wdPasteDefault) ActiveWindow.ActivePane.VerticalPercentScrolled = 0 ActiveWindow.ActivePane.VerticalPercentScrolled = 66 Selection.MoveUp Unit:=wdLine, Count:=111 Selection.TypeParagraph Selection.TypeParagraph Selection.TypeParagraph Selection.TypeParagraph Selection.MoveUp Unit:=wdLine, Count:=3 Selection.TypeText Text:="Personal" End Sub "Suzanne S. Barnhill" wrote: Yes. Macros are written in VBA. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "wordwordy" wrote in message news Do you mean the visual basic code? "Graham Mayor" wrote: Post your macro code with a description of what it is supposed to do. We cannot help debug it if we don't know what it is? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "wordwordy" wrote in message ... Macros run time error 4605 the method or property is not available because the clip board is empty or not valid. I get the above message when I paste two pages of text in to a macro I'm recording and formatting. I get the message when I restart my computer I usually copy the text before I start the recording and paste it in once I start recording. Can anyone help with this? I would like to get rid of the error and have a functional macro . . |
#8
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Macros word 2007 run time error 4605
I have discovered that my macro button now acts as a paste button for
everything I copy up into the clipboard functioning just like the paste button. "wordwordy" wrote: Okay this is the code. I have removed some personal information and replaced it with the word Personal Sub Personal() ' ' Personal Macro ' ' Selection.TypeText Text:= _ "I am an honest, conscientious person. I have complete confi" Selection.TypeText Text:= _ "dence in the work my work and I have always been a good team" Selection.TypeText Text:= _ " player and communicator in the work place. I have worked u" Selection.TypeText Text:= _ "nder pressure in the past but always managed to achieve exce" Selection.TypeText Text:="llent results despite the extra pressure." End Sub Sub test() ' ' test Macro ' ' Selection.PasteAndFormat (wdPasteDefault) ActiveWindow.ActivePane.VerticalPercentScrolled = 0 ActiveWindow.ActivePane.VerticalPercentScrolled = 66 Selection.MoveUp Unit:=wdLine, Count:=111 Selection.TypeParagraph Selection.TypeParagraph Selection.TypeParagraph Selection.TypeParagraph Selection.MoveUp Unit:=wdLine, Count:=3 Selection.TypeText Text:="Personal" End Sub "Suzanne S. Barnhill" wrote: Yes. Macros are written in VBA. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "wordwordy" wrote in message news Do you mean the visual basic code? "Graham Mayor" wrote: Post your macro code with a description of what it is supposed to do. We cannot help debug it if we don't know what it is? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "wordwordy" wrote in message ... Macros run time error 4605 the method or property is not available because the clip board is empty or not valid. I get the above message when I paste two pages of text in to a macro I'm recording and formatting. I get the message when I restart my computer I usually copy the text before I start the recording and paste it in once I start recording. Can anyone help with this? I would like to get rid of the error and have a functional macro . . |
#9
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Macros word 2007 run time error 4605
If you are talking about the Sub Test(), that is what I would expect it to
do. Assuming that it was that macro that produced the error, it probably did so previously because nothing had been copied to the clipboard. There is nothing in either of your two macros to do that. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "wordwordy" wrote in message news I have discovered that my macro button now acts as a paste button for everything I copy up into the clipboard functioning just like the paste button. "wordwordy" wrote: Okay this is the code. I have removed some personal information and replaced it with the word Personal Sub Personal() ' ' Personal Macro ' ' Selection.TypeText Text:= _ "I am an honest, conscientious person. I have complete confi" Selection.TypeText Text:= _ "dence in the work my work and I have always been a good team" Selection.TypeText Text:= _ " player and communicator in the work place. I have worked u" Selection.TypeText Text:= _ "nder pressure in the past but always managed to achieve exce" Selection.TypeText Text:="llent results despite the extra pressure." End Sub Sub test() ' ' test Macro ' ' Selection.PasteAndFormat (wdPasteDefault) ActiveWindow.ActivePane.VerticalPercentScrolled = 0 ActiveWindow.ActivePane.VerticalPercentScrolled = 66 Selection.MoveUp Unit:=wdLine, Count:=111 Selection.TypeParagraph Selection.TypeParagraph Selection.TypeParagraph Selection.TypeParagraph Selection.MoveUp Unit:=wdLine, Count:=3 Selection.TypeText Text:="Personal" End Sub "Suzanne S. Barnhill" wrote: Yes. Macros are written in VBA. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "wordwordy" wrote in message news Do you mean the visual basic code? "Graham Mayor" wrote: Post your macro code with a description of what it is supposed to do. We cannot help debug it if we don't know what it is? -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org "wordwordy" wrote in message ... Macros run time error 4605 the method or property is not available because the clip board is empty or not valid. I get the above message when I paste two pages of text in to a macro I'm recording and formatting. I get the message when I restart my computer I usually copy the text before I start the recording and paste it in once I start recording. Can anyone help with this? I would like to get rid of the error and have a functional macro . . |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Every time open word 2007 I get "Compile error in hidden module" | Microsoft Word Help | |||
4605 error that says "this method or property is not available because no text is selected" | Microsoft Word Help | |||
i need to stop macros sign every time i open word application | Microsoft Word Help | |||
Error with Word Macros | Microsoft Word Help | |||
Error Code 4605 when running macro for saving each letter as a separate file | Mailmerge |