View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gizmo Gizmo is offline
external usenet poster
 
Posts: 47
Default Paste Excel2003 to Word2003

How can I change this code to create a new Word doc instead of a Excel
workbook.

Sub ExportDebrief()
Call CreateDebrief
Dim sDebriefName As String
Dim sToolName As String


sDebriefName = "Debrief.xls"
Sheets("Debrief Report").Activate
ActiveSheet.UsedRange.Select
sToolName = Range("C5").Value
ActiveSheet.Copy
ActiveWorkbook.SaveAs Filename:=sToolName & sDebriefName, _
FileFormat:=xlNormal
Windows("NEWCCSFTMachineRecordsMaster51208.xls").A ctivate
Application.DisplayAlerts = False
Sheets("Debrief Report").Select
ActiveWindow.SelectedSheets.Delete
Application.DisplayAlerts = True

End Sub