View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Clif McIrvin[_3_] Clif McIrvin[_3_] is offline
external usenet poster
 
Posts: 203
Default xlDialogWorkbookMove crashing Excel (object has disconnected error)

"GS" wrote in message
...


I'm curious as to why you'd invoke the dialogs to move/copy when using
the Move/Copy methods accept optional Before/After parameters to
specify destination (within same wkb or other open wkb). If these
parameters are omitted then a new wkb is created with just the
moved/copied sheet[s].



I didn't realize that .Move would create a new wkb - learned something
new here (again!) <g

--
Clif McIrvin

(clare reads his mail with moe, nomail feeds the bit bucket :-)