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