Currently I'm using an Excel macro that runs reports from an Access
form that get outputted to an excel spreadsheet. My problem is when
running these reports if I copy or paste anywhere in Windows the
report is completely invalid. Whatever I was trying to copy gets
thrown into the report and I end up with a large chunk of the data
from the report when I try to paste. I've looked around and haven't
found a way to use a data object since I bring over ranges and other
variables that have formatting, ect. info in them and the data objects
only accept text.

The main question is, is there any VB code I could include in the
macro that would copy to a private clipboard or a created clipboard
with all of the functionality of the windows clipboard? If not is
there any way to include some code in the excel macro to lock the
clipboard while it is in use?

Thanks in advance