tkpstock
Cubicle Warrior
- Local time
- Yesterday, 21:37
- Joined
- Feb 25, 2005
- Messages
- 206
I posted this over on the "Forms" board, but this may be more pertinent under the VBA board:
I have an embedded excel workbook on an Access form (Access 2002)
I would like to change the zoom of the excel "view".
I've tried this:
I get an error that says:
"Unable to set the Zoom property of the Window class"
However, if I READ the zoom level, it works fine. The zoom property of the window class in excel is read/write, but this may not be the case for embedded OLE objects. Is there another way? Does anyone have any ideas?
I have an embedded excel workbook on an Access form (Access 2002)
I would like to change the zoom of the excel "view".
I've tried this:
Code:
' xlCharts is an embedded XL workbook
xlCharts.Object.Parent.ActiveWindow.Zoom = 100"Unable to set the Zoom property of the Window class"
However, if I READ the zoom level, it works fine. The zoom property of the window class in excel is read/write, but this may not be the case for embedded OLE objects. Is there another way? Does anyone have any ideas?
