Posts by jngreenb

  • [Solved] Inserting: multipage spreadsheet into word shows 1

    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.


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

  • [Solved] Printing Row Titles

    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 :(

  • [Solved] Inserting: multipage spreadsheet into word shows 1

    PLEASE HELP.


    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??


    THIS IS AN URGENT PROBLEM!
    ANY SUGGESTIONS WELCOME...


    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.