[python-win32] Selecting OK button in dialog

2007-10-11 Thread mjohnson
I know this has been discussed elsewhere, maybe even on this board. But I am getting spooky things happening, can anyone shed any light please? I enumerate through the windows until I find the one I want, then using childWindows = [] win32gui.EnumChildWindows(window[0], windowEnumerationHandl

[python-win32] excel xla runautomacros

2007-04-25 Thread mjohnson
I am having a problem with an excel add-in which is installed via xlApp.Workbooks.Open("C:/Program Files/Program/XLOF32.xla").RunAutoMacros(1) I can then add the add-in and install it via xlApp.AddIns.Add ("C:/Program Files/Program/XLOF32.xla",True) xlApp.AddIns.Item(Index='Excel Functions').Inst

[python-win32] Registering an excel addin

2007-04-13 Thread mjohnson
Apologies if this is in an incorrect format, but I have just stumbled on the list whilst trying to solve my problem from win32com.client import Dispatch xlApp = Dispatch("Excel.Application") time.sleep(40) xlApp.Visible = 1 wb=xlApp.Workbooks.Add() xlApp.RegisterXLL("C:\Program Files\TestApp\Prog