Whenever the following code snippet runs, I get a "Type Mismatch" error when the penultimate line tries to execute.
The code is being run in an Excel 2010 VBA module, and the subroutine, from which this snippet comes, opens up an instance of Word, populates a new document with text, but then must insert a table that is in the current workbook from which the code is being executed. I have declared my Excel range as a variant, which the Insertfile method seems to require. On a related note, how do I de-select the range? The wdCollapseEnd does not do it, although it does move the insertion point.
Please Login or Register to view this content.