Did you wait until ALL the pivot tables in the xls file had been created
before running the macro. If so, please post your code.

--
XL2002
Regards

William



"DNewton " wrote in message
...
| William,
| I ran your macro at the end of my first text file import, ran the
| import again, and it blew up because it was looking for pivot table 6
| instead of 2, so it didn't appear to work.
|
| Any other suggestions?
|
|
| ---
| Message posted from http://www.ExcelForum.com/
|