View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AlbertYWang AlbertYWang is offline
external usenet poster
 
Posts: 6
Default launch an embedded spreadsheet object

For an excel spreadsheet(objectname1) embedded as an OLE object, the
following code opens the embedded spreadsheet.

ActiveSheet.Shapes("objectname1").Select
Selection.Verb Verb:=xlPrimary

However, it is not visible because of other VBA forms being in the way.

Is it possible to launch this in a separate application window?

Albert Wang