Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default office automation Word-Excel

I call this code and always fails with Error number: - 2147023113 VBA Project Execute Method Failed. I don't know why it fails. Anybody
wdNew.Content.Selec

For col = 1 To
With wdApp.Selection.Fin
fcontent = exSheet.Cells(rec, col).Valu
.Execute FindText:=sfield(c), ReplaceWith:=fcontent,
Replace:=wdReplaceAll, Forward:=True, Wrap:=wdFindContinu

End Wit
Nex

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 599
Default office automation Word-Excel

pggardener

Just a guess: How is sfield dimmed, as an array? Has the variable 'c' been
initialized?

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"pggardner" wrote in message
...
I call this code and always fails with Error number: - 2147023113 VBA

Project Execute Method Failed. I don't know why it fails. Anybody?
wdNew.Content.Select

For col = 1 To 5
With wdApp.Selection.Find
fcontent = exSheet.Cells(rec, col).Value
.Execute FindText:=sfield(c), ReplaceWith:=fcontent, _
Replace:=wdReplaceAll, Forward:=True, Wrap:=wdFindContinue

End With
Next



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default office automation Word-Excel

sfield is actually define this way

Dim sfield(0 To 4) As String
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automation of Excel Data to Word (ref: Galimi answers) Adam Excel Discussion (Misc queries) 3 February 28th 05 04:57 PM
Data Automation from Excel to Word Adam Excel Discussion (Misc queries) 3 February 22nd 05 02:43 PM
Office automation application which will work with any version of office C#.NET Silly Programmer Excel Programming 1 February 21st 04 10:54 AM
RP - Office 2000 automation parameters Access and excel Matt. Excel Programming 5 December 16th 03 07:55 PM
Office 2000: excel to access automation and parameters Matt. Excel Programming 0 December 15th 03 09:33 PM


All times are GMT +1. The time now is 12:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"