Office 2010
I have an Excel sheet I want to save as a Word Doc and I need the VBA coding, Coding I used in Office 2000 does not work. Thanks for help

Hi

Do you want to convert a Sheet to Word document / Insert the Sheet to a Word document. It would be good if you can share the existing code.

Cheers
shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

.ActiveDocument.PageSetup.Orientation = wdOrientLandscape
.ActiveDocument.SaveAs Filename:=Ydesktop
This code convert worksheet to landscape and saves as word document.
I want to add another line of code to save as legal

I thought this might work
.ActiveDocument.PageSetup.Size= wdSizeLegal

But it doesn't
Any suggestions much appreciated

Thanks very much --just what I need