PH, Thank you Thank you. At first I was wondering why you referred to "sFiles" because the variable I wanted was "xlFilenames", and I thought I had tried what you suggested. Turns out I got my variables mixed up at some point in my experimentations. I changed the declaration from xlFilenames...
I'm trying to paste a series of Excel workbooks into Word as imbedded objects. The list of workbooks is contained in a named range "xlFilenames" within an Excel workbook. The destinations
within Word are specified using bookmarks. The table xlFilenames contains corresponding bookmark names...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.