var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Excel Automation - No Find Dialog
I can use the following code in Word to show the Edit->Find dialog box:
There is no xlDialogEditFind index though. How can I search with the Excel Edit->Find dialog?
Dim wordApp As New Word.Application
.Visible = True
Set wordApp = Nothing
but i cant get it to work very well why dont you build your own,
i have been looking at using the windows api but the find dialog seems not to work to well as it is modleless
Yeah the problem with xlDialogFormulaFind is it is not the same as the Edit->Find Box as if you press Ctrl->F.
Theres a workaround here: http://www.excelbanter.com/q-t_13199...alog-box-.html
I found the easiest thing (although ugly) is to SendKeys "^f"
Last edited by wey97; 03-02-05 at 12:24.