EXCEL MACRO VIA Python

[Bodmonkey]

Hi Experts,

I'm both very new to Python and to VBA, so my question may well be a simple one but i'm tearing my hair out

Basically i get a different excel files produced in any number after running a certain job and so the file names change for each job.

I have written a macro via vba to do some sorting and create a presentation in PP.

Now i want to combine hte 2 processes, but am having real trouble making my macro global and running the macro for each different file

Any help is much appreciated

Mike

Code Below

import win32com.client
xl = win32com.client.Dispatch("Excel.Application")
ppt = win32com.client.Dispatch("PowerPoint.Application")
xl.Visible = 1 #open MS Excel
ppt.Visible = 1 #open MS Powerpoint
xl.Workbooks.Open('Z:\\projects\\surveys\\SPSS - Generic files\\big output.xls')
xl.Workbooks.Open('Z:\\projects\\surveys\\SPSS - Generic files\\ChartsToPresentation.xla')
xl.Application.ExecuteExcel4Macro("!PERSONAL.XLS!C hartsToPresentation")