Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel2003 | Charts and Charting in Excel | |||
Excel2003 MAX and MIN with < | Excel Worksheet Functions | |||
How to PERMANENTLY (for every doc) set Auto-Capitalization to OFF in Word2003? | Excel Discussion (Misc queries) | |||
Excel2003 - headings | Excel Discussion (Misc queries) | |||
Excel2003 and xlListSeparator... | Excel Programming |