Progressing through (lower regions of) the python/Com learning curve I
cannot help but think (and I know im not the first to suggest this) that a
python interpreter could take the place of the VBA editor.
1. It seems to me we could automatically set a com wrapper around any
arbitrary function
Hi there,
I have the below python code that was working via
Windows Task Scheduler on Windows 2000 Terminal
Server:
import os, commands
from win32com.client import Dispatch
myExcel.Workbooks.Add('C:/JD/billing/Billing-Report-'
+ str(today) + '.xls')
Jd H wrote:
Hello,
I have the below python code which opens an excel sheet, runs a macro
then save the file. When run from python it runs perfectly. Code is
below. File name is test.py
from win32com.client import Dispatch
myExcel = Dispatch('Excel.Application')
myExcel.Visible =
Jd H wrote:
I am posting test.py again below:
from win32com.client import Dispatch
myExcel = Dispatch('Excel.Application')
myExcel.Workbooks.Add('C:\Python24\\test.xls')
myExcel.Workbooks.Add('C:\Python24\\macro.XLA')
That's still not right. It will work this time, until some Python
Why are you using Cygwin cron instead of native Windows Task Scheduler (Windows
version of cron-like scheduler)?
These lines:
myExcel.Workbooks.Add('C:\Python24\\test.xls')
myExcel.Workbooks.Add('C:\Python24\\macro.XLA')
myExcel.ActiveWorkbook.SaveAs('C:\Python24\\test.xls')
should
I included an additional backslash and still same
error type below:
Traceback (most recent call last):
File c:\Python24\test.py, line 4, in ?
myExcel.Workbooks.Add('C:\\Python24\\test.xls')
File
C:\Python24\Lib\site-packages\win32com\client\dynamic.py,
line 496, in __getattr__
raise