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