Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

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
excel2003 archie Charts and Charting in Excel 1 May 28th 10 01:38 PM
Excel2003 MAX and MIN with < hamricka[_3_] Excel Worksheet Functions 10 August 20th 09 04:06 PM
How to PERMANENTLY (for every doc) set Auto-Capitalization to OFF in Word2003? Pablo Suarez Excel Discussion (Misc queries) 4 May 19th 08 03:29 PM
Excel2003 - headings joanne-mcc Excel Discussion (Misc queries) 1 June 24th 06 12:23 AM
Excel2003 and xlListSeparator... Daniel[_15_] Excel Programming 0 September 29th 04 12:36 PM


All times are GMT +1. The time now is 03:42 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"