Imbed an Excel Sheet in a Word Doc W/OUT Every Excel Grid Visible 2

[ProtocolPirate]

When imbedded in a Word document, all of the worksheet grid lines with no border appear in gray, rather than blank as they should.

What a useful feature!! Thank you so much Microsoft... Can I salvage this, or am I going to have to convert this to a PDF and import that instead?

 

[combo]

It is the default way excel displays worksheet.
Edit embeded workbook, in Tools>Options>View tab untick 'gridlines'.

combo

 

[RonRepp]

Thanks...and a star for you.

Ron Repp

If gray hair is a sign of wisdom, then I'm a genius.

My newest novel: Wooden Warriors

http://www.repproductions.net

 

[ProtocolPirate]

I know how to turn off gridlines for an Excel object in VB.NET by running oXL.ActiveWindow.DisplayGridlines = False, but how do you get the oXL object for a spreadsheet that you have just imbedded in a Word document using AddOLEObject? I need to be able to imbed an Excel spreadsheet in a Word document and turn off the gridlines to print a report.

 

[combo]

In VBA:

Dim wdOLEFormat As Word.OLEFormat
Set wdOLEFormat = ThisDocument.InlineShapes(1).OLEFormat
' replace 'ThisDocument' by document reference if code
' is outside processed document
wdOLEFormat.DoVerb wdOLEVerbDiscardUndoState
' or ...DoVerb -6 (&HFFFFFFFA) for late binding
With wdOLEFormat.Object
    .Windows(1).DisplayGridLines = False
End With

combo