Hi Fumei,

Well aren't you just the smart butt today and normally you're quite nice to people...

A. Thank you for your help.

B. The message box was just a quick cut and paste from my main macro and I deleted some stuff from it which probably included the ending ". And I changed myFile from MyFolder which is declared. Sorry for doing a half assz job about it...

C. I'm doing all of the selecting in Excel because that's where the data resides. I'm trying to get it into Word...so how would I get it in there otherwise?

D. Yes I did look up pasteandformat in Word Help the only example was Selection.PasteAndFormat Type:=wdChartPicture
It didn't give me what was valid and what wasn't.

E. Yeah forgot to change the code to the renamed tab when posting this. LOL I really messed this up...

F. I would have figured to use pastespecial Data Type... if the Macro recorder for Word showed me pastespecial instead of "Selection.PasteAndFormat (wdPasteDefault)" even though I did a paste special.

G. I have used object browswer but not that familiar with it...still learning. Is there a book...yeah right of course not that would be too helpful.

Now let me see if this works the way I'm hoping...