Two different 'Paste Special dialogs?

[PeteCresswell]

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:

 

[Dave Peterson]

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?

 

[Dave Peterson]

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.

 

[PeteCresswell]

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.