I've got an Excel OLE automation that opens a ver 5 workbook does some stuff and then saves it as the same file name. My problem is that I've got excel ver 7 doing the automation and a lot of users have ver 5.
How do I get the file to save as ver 5.
ox.ActiveWorkbook.SAVEAS("c:\myworkbook.XLS",1)
TIA
Jeff
It's Time to get a gun.
That's what I've been thinkin.
I think I can afford one, If I do a little less Drinkin.www.TrueGeeks.com