[python-win32] Python and Excel via Cron

2007-11-21 Thread Jd H
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 = 1

Re: [python-win32] Python and Excel via Cron

2007-11-21 Thread bob gailer
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') > my

Re: [python-win32] Python and Excel via Cron

2007-11-21 Thread Tim Roberts
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') > myEx

Re: [python-win32] Python and Excel via Cron

2007-11-21 Thread John Machin
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 > What does "run from python" mean?? > > <<< > What's that "<<<"?? If you meant to

Re: [python-win32] Python and Excel via Cron

2007-11-21 Thread Tim Roberts
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 s

Re: [python-win32] Python and Excel via Cron

2007-11-21 Thread Larry Bates
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 re

Re: [python-win32] Python and Excel via Cron

2007-11-21 Thread Jd H
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') myExcel.Run('Macro1') myExcel.Application.DisplayAlerts = False myExcel.Ac

Re: [python-win32] Python and Excel via Cron

2007-11-21 Thread Jd H
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__ rais

Re: [python-win32] want to leave DOS console at any target dir

2007-11-21 Thread Charlie
bob gailer alum.rpi.edu> writes: > > Charlie wrote: > > When launching a python script from a DOS console, > > I can not find a way to leave the DOS console at a working directory > > other than the initial working directory. > > > Why do you want to do this? Might there be other approach

Re: [python-win32] want to leave DOS console at any target dir

2007-11-21 Thread Michel Claveau
Hi! Try this: import os os.system('start "TITLE" "cmd /KCD /DD:\\Dev\\python"') #for dir: D:\\Dev\\python ("TITLE" is the title (yes!) of the window) @-salutations Michel Claveau ___ python-win32 mailing list [email protected] htt