Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error Driving Me Crazy
Hi all, I am working with an application I am making. It tries to send some data from excel to word. To do so, I make a template on word and say in excel to find and replace some values. The thing is that the code to find and replace works perfectly in my computer, but when I try to do it in another one crashes and gives the following error: THE FOLLOWING ERROR HAS OCURRED -2147023113(8007067F) ON EXECUTION TIME. ERROR ON THE METHOD 'EXECUTE' OF THE OBJECT 'FIND' The code I am using is - Dim DocWord As Word.Document Dim VariableWord As Word.Application Set VariableWord = New Word.Application Set DocWord = VariableWord.Documents.Add("I:\RIESGOS OPERACIONALES\Sarbanes-Oxley\Aplicación sox\recomendaciones.dot") VariableWord.Visible = False With DocWord.Content.Find ..Execute findtext:="{texto1}", replacewith:=encabezado.Text, Replace:=wdReplaceAll ..Execute findtext:="{texto2}", replacewith:=cuerpo1.Text, Replace:=wdReplaceAll ..Execute findtext:="{texto3}", replacewith:=cuerpo2.Text, Replace:=wdReplaceAll ..Execute findtext:="{texto4}", replacewith:=pie.Text, Replace:=wdReplaceAll- I WILL APRECIATE SOME HELP!! THANK YOU VERY MUCH -- internacio ------------------------------------------------------------------------ internacio's Profile: http://www.excelforum.com/member.php...o&userid=30960 View this thread: http://www.excelforum.com/showthread...hreadid=522742 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error Driving Me Crazy
Try the simplest first. You last line of code has
Replace:=wdReplaceAll- is the "-" on the end a stray character or actually in your code. If in your code, that might be the problem. Otherwise - some guesses. Try qualifying your objects. Ex: replacewith:=encabezado.Text, should be something like replacewith:=userform1.encabezado.Text, perhaps. also, it looks like you are using earling binding, but if your not, perhaps replace wdReplaceAll with the value it represents. -- Regards, Tom Ogilvy "internacio" wrote: Hi all, I am working with an application I am making. It tries to send some data from excel to word. To do so, I make a template on word and say in excel to find and replace some values. The thing is that the code to find and replace works perfectly in my computer, but when I try to do it in another one crashes and gives the following error: THE FOLLOWING ERROR HAS OCURRED -2147023113(8007067F) ON EXECUTION TIME. ERROR ON THE METHOD 'EXECUTE' OF THE OBJECT 'FIND' The code I am using is - Dim DocWord As Word.Document Dim VariableWord As Word.Application Set VariableWord = New Word.Application Set DocWord = VariableWord.Documents.Add("I:\RIESGOS OPERACIONALES\Sarbanes-Oxley\Aplicación sox\recomendaciones.dot") VariableWord.Visible = False With DocWord.Content.Find .Execute findtext:="{texto1}", replacewith:=encabezado.Text, Replace:=wdReplaceAll .Execute findtext:="{texto2}", replacewith:=cuerpo1.Text, Replace:=wdReplaceAll .Execute findtext:="{texto3}", replacewith:=cuerpo2.Text, Replace:=wdReplaceAll .Execute findtext:="{texto4}", replacewith:=pie.Text, Replace:=wdReplaceAll- I WILL APRECIATE SOME HELP!! THANK YOU VERY MUCH -- internacio ------------------------------------------------------------------------ internacio's Profile: http://www.excelforum.com/member.php...o&userid=30960 View this thread: http://www.excelforum.com/showthread...hreadid=522742 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error Driving Me Crazy
The problem might be a missing reference on the other PC.
Try with late binding like this: Dim VariableWord As Object Set VariableWord = CreateObject("Word.Application") Good chance that will fix the problem. RBS "internacio" wrote in message ... Hi all, I am working with an application I am making. It tries to send some data from excel to word. To do so, I make a template on word and say in excel to find and replace some values. The thing is that the code to find and replace works perfectly in my computer, but when I try to do it in another one crashes and gives the following error: THE FOLLOWING ERROR HAS OCURRED -2147023113(8007067F) ON EXECUTION TIME. ERROR ON THE METHOD 'EXECUTE' OF THE OBJECT 'FIND' The code I am using is - Dim DocWord As Word.Document Dim VariableWord As Word.Application Set VariableWord = New Word.Application Set DocWord = VariableWord.Documents.Add("I:\RIESGOS OPERACIONALES\Sarbanes-Oxley\Aplicación sox\recomendaciones.dot") VariableWord.Visible = False With DocWord.Content.Find Execute findtext:="{texto1}", replacewith:=encabezado.Text, Replace:=wdReplaceAll Execute findtext:="{texto2}", replacewith:=cuerpo1.Text, Replace:=wdReplaceAll Execute findtext:="{texto3}", replacewith:=cuerpo2.Text, Replace:=wdReplaceAll Execute findtext:="{texto4}", replacewith:=pie.Text, Replace:=wdReplaceAll- I WILL APRECIATE SOME HELP!! THANK YOU VERY MUCH -- internacio ------------------------------------------------------------------------ internacio's Profile: http://www.excelforum.com/member.php...o&userid=30960 View this thread: http://www.excelforum.com/showthread...hreadid=522742 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error Driving Me Crazy
Forgot to say that if you use late binding you will have to replace:
wdReplaceAll with the number 2 RBS "RB Smissaert" wrote in message ... The problem might be a missing reference on the other PC. Try with late binding like this: Dim VariableWord As Object Set VariableWord = CreateObject("Word.Application") Good chance that will fix the problem. RBS "internacio" wrote in message ... Hi all, I am working with an application I am making. It tries to send some data from excel to word. To do so, I make a template on word and say in excel to find and replace some values. The thing is that the code to find and replace works perfectly in my computer, but when I try to do it in another one crashes and gives the following error: THE FOLLOWING ERROR HAS OCURRED -2147023113(8007067F) ON EXECUTION TIME. ERROR ON THE METHOD 'EXECUTE' OF THE OBJECT 'FIND' The code I am using is - Dim DocWord As Word.Document Dim VariableWord As Word.Application Set VariableWord = New Word.Application Set DocWord = VariableWord.Documents.Add("I:\RIESGOS OPERACIONALES\Sarbanes-Oxley\Aplicación sox\recomendaciones.dot") VariableWord.Visible = False With DocWord.Content.Find Execute findtext:="{texto1}", replacewith:=encabezado.Text, Replace:=wdReplaceAll Execute findtext:="{texto2}", replacewith:=cuerpo1.Text, Replace:=wdReplaceAll Execute findtext:="{texto3}", replacewith:=cuerpo2.Text, Replace:=wdReplaceAll Execute findtext:="{texto4}", replacewith:=pie.Text, Replace:=wdReplaceAll- I WILL APRECIATE SOME HELP!! THANK YOU VERY MUCH -- internacio ------------------------------------------------------------------------ internacio's Profile: http://www.excelforum.com/member.php...o&userid=30960 View this thread: http://www.excelforum.com/showthread...hreadid=522742 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Driving me CRAZY~ please help | New Users to Excel | |||
Driving me crazy! | Excel Programming | |||
It doesn't add up - It's driving me crazy | Excel Programming | |||
Error Handling driving me crazy. Please help | Excel Programming | |||
Driving me crazy! | Excel Programming |