Hello all,
My workbook is slowly coming along thanks to all the help on this forum, but I'm now truly befuddled.
Sheet 5 (named RESULTS) has data appended to it in table form using a VBA - basically it copies certain cells from another sheet and adds these to the next empty row in RESULTS sheet.
This starts at B2 and uses 6 columns (so B2 to G2). There are a variable amount of rows depending on how many tests are done (so the range will be B2 to Gx).
What I want to do is for excel to open a word template (C:\test.dot) and put the info from B2 - Gx into table form into Word. But I can't do it! I've tried Professor Google but everyone else's code doesn't seem to work for me.
Oh - it's excel 2003 I'm using (my employers too tight to upgrade!)
Many thanks.
Bookmarks