hi
Applications.DisplayAlerts =False
this will turn of any alerts that excel is suppost to display and you don't
want to see. but before you exit the macro, it would be wise to turn them
back on again so as not to impact normal excel operations.
Application.DisplayAlerts = True

But since you didn't post any code, i can't tell you were to put the above
lines. only turn alerts off somewhere before the pesky alert appears and turn
on again Before you exit the macro.

Regards
FSt1

"Paul" wrote:

The macro below is part of a larger process. It is supposed to automate a
process of copying and pasting data.
The data is being copied from a table. cvs sheet, that was auto-generated
when a hyperlink was followed.
The data is being copied to the previously opened workbook, containing the
previously opened worksheet, where the hyperlink is located.
It does what it is supposed to do, with one hitch. That is copy the
data(from the active worksheet-Table.cvs), close (without saving) the table,
then paste the data to the(now active) previously opened worksheet. Another
macro, again part of the larger process, saves and closes this worksheet,
opens another & follows another hyperlink.
The hitch is, when the table is closed, a dialog box pops up. It wants to
know if I want to keep the data on the clipboard for future use, which of
course I do, because it is pasted two steps later.
How can I keep this from happening?