[Tutor] Invoking Excel Macro
arun
r.arunchand at gmail.com
Mon Apr 24 15:32:43 CEST 2006
Hi Mike,
It doesn't display any dialog box rather it gives a temporary name to
the file.
Ex
newsheet.xls as newsheet1.xls
So i'm not able to save it. Is there an alternative to invoke the macro
and save the file from my script itself .(saving it through macro wud be a
better option : ) )
Thanx and Regards,
arun
On 4/21/06, Mike Hansen <mhansen at cso.atmel.com> wrote:
>
> In the macro, you might try Application.DisplayAlerts = False and reset
> it to True after you save.
> I think it might be trying to display a dialog box before it saves.
>
> Mike
>
> ------------------------------
> *From:* tutor-bounces at python.org [mailto:tutor-bounces at python.org] *On
> Behalf Of *arun
> *Sent:* Friday, April 21, 2006 1:44 AM
> *To:* tutor at python.org
> *Subject:* Re: [Tutor] Invoking Excel Macro
>
>
>
> 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
>
>
--
arun
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.python.org/pipermail/tutor/attachments/20060424/15c9f67a/attachment.htm
More information about the Tutor
mailing list