View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
carlos carlos is offline
external usenet poster
 
Posts: 2
Default excel 2007 windows class name

Hi

apparently embedded chart in excel 2007 have hidden windows classname.

I have this piece of code, what I use for position forms over the worksheet

hWndXL = FindWindow("XLMAIN", Application.Caption)
hWndXLDesktop = FindWindowEx(hWndXL, 0&, "XLDESK", vbNullString)
hWndXLChart = FindWindowEx(hWndXLDesktop, 0&, "EXCELE", vbNullString)

XLMAIN - EXCEL
XLDESK - Sheet Grid
EXCELE - Embedded Chart

someone knows a workaround for position forms exactily over a cell
independently of zoom and maximaze.

Thank's