Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. squarecat

    Preserve formatting after update - Word VBA

    CMP, Thanks for sticking with this one! I've just worked it out - sorry to waste your time - but the answer is below. OLD CODE: 'import Table + source oXL.Sheets("Key financials").Select oXL.Range("A8:H20").Select oXL.Selection.Copy With oWordDoc.ActiveWindow...
  2. squarecat

    Preserve formatting after update - Word VBA

    CMP, Thanks for this but it doesn't seem to work for tables - I'm fine with it working for Shapes and Inline shapes but there deosn't seem to be a OLEFormtat as part of the tables collection. Any other odeas!? Thanks squarecat
  3. squarecat

    Out of memory

    not meaning to be funny - but do you have a "End sub" at the end of that? Exit is fine but I think you'll need to end it as well. Cheers
  4. squarecat

    Preserve formatting after update - Word VBA

    Hi all; Hope someone can help with this one... I've created code to import 8 tables from a specified spreadsheet as linked objects. The code then goes on to format the tables and title and footnote text. This means that the Excel document has different formatting to the Word doc so on update...

Part and Inventory Search

Back
Top