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