Two different 'Paste Special dialogs?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PeteCresswell - 27 May 2005 16:20 GMT

In different situations, I get different dialogs when I choose
Edit|Paste Special.

When pasting from a NotePad document, the dialog has a scrolling
ListBox in the center captioned "As:" and a "Result" display
underneath that explains the currently-selected ListBox option.

Also, when pasting from a .XLS that I create in VBA, the "As/Result"
dialog appears - whereas the user expects to be able to transpose.

OTOH, when pasting from another spreadsheet - not created by my VBA
routine - the Paste Special dialog contains no ListBox. Instead it
contains two option groups and a couple of checkboxes. Option groups
are 'Paste' and 'Operation'. Checkboxes are 'Skip blanks' and
'Transpose'. This is the dialog that my users expect when pasting
from a .XLS I create in VBA because they often want to transpose the
pasted data from horizontal to vertical presentation.

Two questions:
--------------
1) What are the circumstances that determine which dialog appears.

2) Is the second dialog dependent on the source document being hooked
into any special library?

Reply to this Message

Dave Peterson - 27 May 2005 18:42 GMT

I don't think it's how the workbook was created. I think it's how you're
running excel.

If you copy from a different application, then edit|paste special, you get that
"Listbox" version of the paste special dialog.

If you copy from the same instance of excel (including a different workbook open
in that same instance), you get the other paste special dialog.

I bet you're running two instances of excel. If you open both workbooks in the
same instance, then you'll see the "listbox" dialog.

===
So the question becomes how are you creating/opening that second workbook?

> In different situations, I get different dialogs when I choose
> Edit|Paste Special.
[quoted text clipped - 20 lines]
> 2) Is the second dialog dependent on the source document being hooked
> into any special library?

Signature

Dave Peterson

Reply to this Message

Dave Peterson - 27 May 2005 19:56 GMT

Oops.

Replace:

I bet you're running two instances of excel. If you open both workbooks in the
same instance, then you'll see the "listbox" dialog.

with:
I bet you're running two instances of excel. If you open both workbooks in the
same instance, then you'll see the other dialog.

> I don't think it's how the workbook was created. I think it's how you're
> running excel.
[quoted text clipped - 39 lines]
>
> Dave Peterson

Signature

Dave Peterson

Reply to this Message

PeteCresswell - 27 May 2005 20:00 GMT

>with:
>I bet you're running two instances of excel. If you open both workbooks in the
>same instance, then you'll see the other dialog.

Thanks. I figured you had them transposed... I'm looking into that
right now.

Reply to this Message