Excel VBA clipboard problem

R

ryanvanh

Currently I'm using an Excel macro that runs reports from an Access for
that get outputted to an excel spreadsheet. My problem is when runnin
these reports if I copy or paste anywhere in Windows the report i
completely invalid. Whatever I was trying to copy gets thrown into th
report and I end up with a large chunk of the data from the report whe
I try to paste. I've looked around and haven't found a way to use
data object since I bring over ranges and other variables that hav
formatting, ect. info in them and the data objects only accept text.
Is there any VB code I could include in the macro that would copy to
private clipboard or a created clipboard with all of the functionalit
of the windows clipboard? If not is there any way to include some cod
in the macro to lock the clipboard while it is in use?

Thanks in advanc
 
D

Dave Peterson

I don't speak the Access. But there may be better ways of retrieving data from
your database.

You may want to search google:
http://groups.google.com/advanced_group_search
both in Access newsgroups and excel newsgroups.

And if that doesn't pan out, maybe a post to the Access newsgroup.

(Unless you get a good answer here.)
 
R

ryanvanh

Well the main issue is the clipboard being copied over when a user trie
to do a Ctrl+C Ctrl+V or any other copy or paste while the repor
process is running. My main question is, is there a way to give excel
through a macro, it's own private clipboard, create a clipboard with al
the functonality of the windows clipboard, or lock the clipboard whil
the report process is running
 
D

Dave Peterson

If there is, it's way beyond me.

ryanvanh < said:
Well the main issue is the clipboard being copied over when a user tries
to do a Ctrl+C Ctrl+V or any other copy or paste while the report
process is running. My main question is, is there a way to give excel,
through a macro, it's own private clipboard, create a clipboard with all
the functonality of the windows clipboard, or lock the clipboard while
the report process is running?
Click to expand...
 
Top