[Tutor] Invoking Excel Macro

arun r.arunchand at gmail.com
Fri Apr 21 09:29:07 CEST 2006


Hi,
I tried invoking a macro from my python script and  It is  throwing  an
error message that reads 'Run-time error 1004':

"This operation requires the merged cells to be identically sized"

My script looks like this

from win32com.client import Dispatch
xl = Dispatch('Excel.Application')
xl.Workbooks.Add('E:\Templates\sample.xls')
xl.Run('Import_file')  # name of the macro

Also while (running the macro)opening the workbook it  names it as  "
sample1.xls' ,and so
It says there is no such file sample.xls

"
Filename =  Myexcel.xls
Workbooks("sample.xls").SaveAs Filename
"

Can somebody help me with this issue : (


Thanx
arun
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.python.org/pipermail/tutor/attachments/20060421/be914afc/attachment.htm 


More information about the Tutor mailing list