innovationhasem.blogg.se

• #HOW TO MAKE A TABLE ON EXCEL AND INSERT INTO WORD CODE#

Now, I'm not stuck to the idea of having to create a new Word document.

#HOW TO MAKE A TABLE ON EXCEL AND INSERT INTO WORD CODE#

Add new row in Word table if Excel code determine a new row is required and fill out new row.In second row, fill out word table cells with values ( which will be retrieved from Excel VBA from various places in the Excel workbook).Insert a new table into Word document with predetermined number of columns, and start with 2 rows.If not, what rules can be applied to identifying the document, or do you want the user to select it somehow?Ī) are you always extracting the data from the same workbook & worksheet? If not, what rules can be applied to identifying them, or do you want the user to select them somehow?Ĭ) how is the macro to identify what ranges to extract the data from?

Where do you want to run the macro from - Word or Excel?Ī) are you populating: an existing Word document (including a new Word document based on a template containing the required base content - which includes a table that can be updated) a new or existing Word document that lacks both the table and any other content or something else?ī) if its an existing Word document, is the filename & path always the same at the time the macro runs? This could include a new document that the macro creates from a template you've created for the purpose. The macro recorder is hopelessly inadequate for producing the code required for this.ġ. Range:=Selection.Range, NumRows:=4, NumColumns:=3, _ĭefaultTableBehavior:=wdWord9TableBehavior, AutoFitBehavior:=wdAutoFitFixedĪ quick search and I found these two links which I think should help me do what I want.