external table

  1. L

    Create Arrays from external workbook and add worksheet table data to the arrays

    I have a workbook that will be my main program. From this workbook I need to do the following in VBA. 1) Reference external workbook (hardcoded location). 2) Create arrays based on the sheet names in this external workbook 3) Populate each array with the table data in each worksheet once the...
  2. P

    Error when mail-merging from spreadsheet with chart

    Hi, all I have a spreadsheet that I use to populate a Word template using a mail merge. I've recently modified the spreadsheet to chart certain information, and the chart is on its own sheet, but when running the Word mail merge using the new spreadsheet as a data source, I get the error...

Some videos you may like

This Week's Hot Topics