>Hello,
>I hope somebody here can help me. I want to open all our Excel/Word/Powerpoint –Files with the extensions XLS, PPT and DOC and save them into the new Office 2007 format (XLSX, DOCX and PPTX).
>So I’ve written a Foxpro program which opens the files via OLE-automation and saves them in the new format. Works fine so far, but there is one problem. If e.g. the Excel file has a macro inside it is lost if you save it to an XLSX-File. If you don’t want to lose the macro you have to save it as XLSM-File.
>Now my question: Is it possible to find out whether an Excel-File has a macro or not?
>
>Any help is appreciated
>
>Thanks in advance :-)
>
>Marcus

Check this message Re: Deleting a macro via automation Thread #1286200 Message #1286298 Looks like you can get your answer from this.