Assuming you're trying to do this using VBA in Access, the database product
that's part of Office Professional, how did you open the files in the first
place?
If you're not trying to do this using Access, you'd be better off finding a
more appropriate newsgroup in which to ask this question. (And if you do
repost, please don't use all capitals. It's the visual equivalent of
shouting, and is considered rude)
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.