[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