[Tutor] Invoking Excel Macro
arun
r.arunchand at gmail.com
Fri Apr 21 09:44:08 CEST 2006
I'm sorry , there is something realy wrong with 'Run-time error 1004':. I
have fixed it now but still it throws an error while trying to save the
workbook.
On 4/21/06, arun <r.arunchand at gmail.com> wrote:
>
> 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
>
>
>
>
>
>
--
arun
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.python.org/pipermail/tutor/attachments/20060421/9737c2e7/attachment.html
More information about the Tutor
mailing list