Problem with a macro

P

Paul

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?
 
J

JLGWhiz

You could do as Fst1 suggests and disable the alert display, or you could
rewrite the code so that the pasting action is completed before the
worksheet is closed. If you are not comfortable with re-writing the code,
then the DisplayAlerts is probably the solution you want.
 

Ask a Question

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.

Ask a Question

Top