The following image is the final output where you can click on any of the series to have it either included or excluded. In the Excel workbook copy the table you want updated in the word document. Week 2 deals with text strings and text (.txt) files. I'm trying to use VBA (in Excel 2010) to loop through a list of URLs and import the data from these websites. Video created by for the course 'Excel/VBA for Creative Problem Solving, Part 2'. I've recently started learning VBA in my free time and need help with a project I've taken on.
Firstly the building of the template needs to occur in Word. Excel, so any advice to improve this posting is appreciated.
It sounds simple however there is a lot which needs to occur before the procedure runs smoothly.
A way of locking the data down is to create a template in word which is linked to a template in Excel.
Under Microsoft Excel Objects in Project Explorer, you will find ThisWorkbook module. If you use VBA in my experience Excel tended to upload data from Excel into Word a different size and shape each time the code runs. Open destination Excel file and press Alt+F8. Writing the code inside WorkbookOpen() evevt would ensure that it updated the figures immediately when the Excel file opens.