View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bill Manville Bill Manville is offline
external usenet poster
 
Posts: 473
Default Export Excel to Word

1. At the end of the routine Word stays open and the document is not
visible.


Try

WordBasic.Application.Quit
before
Set WordBasic = Nothing

2. The document name appears in the Word File menu and can be opened from
here.

Try
WordBasic.SaveAs AddToRecentFiles:=False

3. When the document is opened it does not appear in print layout view, but
has a head/footer window open even though the last data inserted into the
document was placed in the body text of the document.

Not sure about that one.
Maybe
WordBasic.Characters(1).Select

By the way, your choice of WordBasic as the name of the Word.Document object
was initially offputting since WordBasic was the name of the dialect of Basic
used in Word before Word 97.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup