I think the second parameter is incorrect. It should probably be a numeric value, but I'm not sure what that is.
>It looks as if SaveAs is the answer, but I can't get it to work.
>It should accept another parameter for file format.
>I found a list, but no matter how I try to pass it, I crash
>
>This is the latest try, and it crashed
>
> ole_xls.ActiveWorkbook.SaveAs(lc_location + pc_detail + ".xls","xlExcel5" )
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer