On 27/01/2013 12:37, Hsu. Victor (GSM) wrote:
Hi,
I would like to copy a Pivot table to another location.
I can do that with VBA code below. Can someone guide me how to convert
below code to Python? Especailly the PivotTables PivotSelect part, I
don't know how to call it in python.
Hello,
I am currently working with win32com to access ProgeCAD (an AutoCAD Clone)
Excel and PDFCreator.
Using
comobj = win32com.client.Dispatch('xxx')
gives me an object through which I can access the COM interface and thus
the underlying program.
Within my program I have to pass this object
Hsu. Victor (GSM) wrote:
I am trying to use this python sample code to create automatic
daily report.
http://bytes.com/topic/python/answers/165364-ms-word-mail-merge-automation
but I always failed to open the data source in CSV file. Is this
python issue or Windows COM version
Hi Tim,
I fixed it by doing some modification.
data_source_name = os.path.abspath('recipient.csv')
mm.OpenDataSource(data_source_name)
And the Word Merge To Document function works now.
However, my intention is to send an email. So I change some setting,
#send the merge result to
Re-install my Office to English version. Finally know what Word told me. Let
me try how to fix this.
===
F:\MyProgram\python\Word2Emailpython Word2Email.py
Traceback (most recent call last):
File Word2Email.py, line 41, in module
mm.Execute()
File
Great...finally fix the problem.
#
#send the merge result to Email
mm.MainDocumentType = const.wdEMail
mm.Destination = const.wdSendToEmail
mm.MailAddressFieldName = EMail
mm.MailFormat = const.wdMailFormatHTML
mm.MailSubject = This is a test mail from Python