Posts by jngreenb

    Thanks for the replies.

    I've attached a test spreadsheet.

    To test it, just insert it as an object in Word (select Create From File tab).

    Then resize the object smaller.
    The 2 columns on the rightmost side are not shown.

    Jack, I'm using a very simple macro in Word, which basically just does the following:

    Selection.InlineShapes.AddOLEObject ClassType:="Excel.Sheet.8", FileName:= strName, LinkToFile:=False, DisplayAsIcon:= False
    Selection.InlineShapes(1).Height = 503.15
    Selection.InlineShapes(1).Width = 602.65

    I'm not sure what you are talking about, so if you think you can solve it, some sample code would be appreciated :)

    btw, is there a way I can speed up the AddOLEObject operation?
    It takes nearly 10 seconds!!
    And I might be adding several spreadsheets - so it can take a long time in total.

    I'm using Word/Excel 2000 (9.0.2720)
    I'm running NT 4, SP6.

    I presume you are talking about an excel spreadsheet?

    If so, you need to goto File - Page Setup - Sheet Tab.

    There you will find entries for 'Print Titles'
    with 'Rows to repeat at top'.

    Don't suppose you can help me with my post? I'm a bit stuck :(


    I'm using a Word macro to import an Excel spreadsheet into word, using AddOLEObject.

    The problem is, the spreadsheet is wider and deeper than 1 page (maybe about 1/4 page more).
    When it is imported into Word, no matter how much I shrink the object, only the columns and rows from page 1 are displayed in Word.

    How can I get the object in Word to show all the data from the spreadsheet??


    It is not practical for me to reduce the Excel spreadsheet down to 1 page.
    I need Word to be able to display the full spreadsheet.

    NOTE: I am using Office 2000.
    And it needs to also work on Office XP (not tested yet).

    ps. I need to get the Word macro to do this. I am thinking that there must be some property or method of the object I can use...
    But any suggestions as to how to do this outside of macros may be helpful also.