Newbie: returning dynamicly built lists (using win32com)

2006-06-06 Thread Ransom
Very newb here, but my question will hopefully be obvious to someone. Code: import string from win32com.client import Dispatch docdir = 'E:\\scripts\\Python\\RSAutomation\\' def getOldData(testcases): excel = Dispatch("Excel.Application") excel.Workbooks.Open(docdir + 'FILE.xls') #

Re: Newbie: returning dynamicly built lists (using win32com) (SOLVED)

2006-06-06 Thread Ransom
attribute incorrectly ( Cells.Value(x,y) instead of Cells(x.y).Value. Cheers, G Ransom wrote: > Very newb here, but my question will hopefully be obvious to someone. > > Code: > > import string > from win32com.client import Dispatch > docdir = 'E:\\scripts\\Pytho

Re: Newbie: returning dynamicly built lists (using win32com)

2006-06-06 Thread Ransom
ing. Shit. I always do that. I always mess up some mundane detail." -Michael Bolton Actually, this was a typo in my e-mail. And yes, I realize how annoying that can be when someone is seeking help. Thanks for your otherwise excellent response, though! G Paul McGuire wrote: > "Rans

occasional win32com error

2006-06-15 Thread Ransom
Hey folks... Newbie here. I'm working with win32com launching, closing and re-launching Excel grabbing output and doing stuff. Well, on some occasions, I get the following error: Traceback (most recent call last): File "checkrates.py", line 95, in ? newdata = getNewData(testcases1) File