[Tutor] Looping, and Win32com.client

[Tim Golden]

Eduardo Vieira wrote:
> Hello, this is my first post in this list and I'm not a programmer,
> but am enjoying learning python.
> I'm trying to make a script to add worksheets to excel files:
> I managed to implement this code:
> 
> import os
> folder = 'C:\\Personal\\oldxlsformat\\'
> from win32com.client import Dispatch
> xl = Dispatch('Excel.Application')
> xl.Application.AskToUpdateLinks = "False"
> for ficheiro in os.listdir(folder):


os.listdir returns a list of files relative to
the directory in question. (Try it at the
interpreter and see). Excel requires, pretty
much, a list of absolute filenames. So try
using something like os.path.join (folder, ficheiro)
when opening in Excel.

TJG