Possible bug with clipboard data? - Need Advice

J

Joshua

I have an excel workbook that has 3 worksheets (Input, Output, Clipboard)

Input is the only visible sheet and is used to input the variables.
Output is used for spawning a new excel sheet with a customized view.
Clipboard is used for when copying the data into word or another application.

My code looks like this:

Sub clipcopy()
'Copies the output sheet to clipboard so a user can paste into Powerpoint or
Word
Application.ScreenUpdating = False
Sheets("clipboard").Visible = True
Sheets("clipboard").Select
Range("A1:D18").Select
Selection.Copy
Sheets("Input").Activate
Application.ScreenUpdating = True
MsgBox ("The sheet is copied to the clipboard." & vbCrLf & vbCrLf & "Keep
this window open until you have finished pasting into another application.")
Sheets("clipboard").Visible = False

The problem is if you close the msgbox window and try to paste into word it
pastes as hidden text.

If you keep the msgbox open and paste into word it pastes normally.

This works but seems a bit messy to me. Is there another way I could
accomplish? Apparently when Sheets("clipboard").Visible = False is set, it
also affects whats already in the clipboard.

Thanks for any help you can provide, and if you would like a copy of the
file let me know.
 
B

Bill Renaud

Very interesting! On my machine (Windows ME and Excel 2000 SP-3), your code
works fine, even if I click OK and dismiss the MsgBox so that
Sheets("clipboard") is hidden before I paste into Word!
 
J

Joshua

Strange..

I tried on an office 2003 machine and office 2007 machine and both have same
results. When I paste into word, I cant see unless I show hidden text.

I am executing the code from a command button, but I really dont think that
is the issue.

So if it's not the code, and it's not the version of office, I guess it
could be something else within the file?
 
B

Bill Renaud

Does your "clipboard" worksheet have some special cell formatting that
might be causing the problem (i.e. white text on a white background or
pattern)? I had this happen to me once and it took me a little while to
figure out!
 
J

Joshua

It's black text on a white background. Its the exact same as the output
worksheet except the logo is smaller and in the bottom right hand corner,
which allows the pasted object to be centered in word or powerpoint by
default.
 

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