Excel VBA - Insert Word Table problem

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: PaulC (PaulC.174c11_at_excelforum-nospam.com)
Date: 05/31/04 

Date: Mon, 31 May 2004 06:37:51 -0500

I am trying to add a word table into a word document that opens from an
Excel97 macro. Everything works fine until I try to insert the table.
The code is:

Set wdApp = CreateObject("word.application")
wdApp.Documents.Open("C:Attendance _ Note.doc").Application.Visible =
True

With wdApp
Visible = True
With .Selection
TypeText Text:="Attendance Note"
TypeParagraph
Tables.Add Range:=Selection.Range,NumRows:=6, NumColumns:=4
End With
End With

This works except it will not insert the table. What have I missed
out?

Paul 

---
Message posted from http://www.ExcelForum.com/

Relevant Pages

  • RE: Word document unreadable
    ... It seems that the issue is related to the font setting. ... Which font is set on the Word document? ... Microsoft Online Partner Support ... It opens but the ...
    (microsoft.public.office.misc)
  • Re: make Word work in frame of webpage
    ... So if I want to save it after having worked in the frame ... I'm working in an Electronic Learning Environment for a school and ... Word document it is opened in a frame, ... (Course that opens a whole can of worms for ...
    (microsoft.public.word.docmanagement)
  • Re: "quiet" install of Word 2003
    ... is already open then the Word document opens when clicked via Application ... For security reasons I have the Terminal Server ... Word is not on the production Terminal Server once I install it users ...
    (microsoft.public.office.setup)
  • Re: Strange Format Issue When Emailing Presentation
    ... That will cause them to open in Slide Show mode. ... I send myself a .PPT file via HTML formatted mail, it opens in Normal mode, as ... Microsoft PowerPoint MVP Team ... > agenda as a Word document, ...
    (microsoft.public.powerpoint)
  • Re: "quiet" install of Word 2003
    ... Word Viewer didn't solve the issue. ... opens Word documents. ... Word document that is stored within Application X. ... Word is not on the production Terminal Server once I install it users will ...
    (microsoft.public.office.setup)