Re: [Tutor] Invoking Excel Macro

[Mike Hansen]

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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of arun
Sent: Friday, April 21, 2006 1:44 AM
To: tutor@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 <[EMAIL PROTECTED]> 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

_______________________________________________
Tutor maillist  -  Tutor@python.org
http://mail.python.org/mailman/listinfo/tutor