VBA to delete Formulas, Names, & Macros of another workbook, but to keep values

Dear Friends,

Because, once my reports are generated & got printed, I just need to keep only the values. Hence, I want a code to do the following:

I want to delete names, formulas, macros of another workbook. For example, A.xls is my codes workbook. From this file, I want to delete the names, formulas, macros (but to keep the values & formatting in tact) of another workbook (there must be a prompt for which .xls file, the names etc. to be deleted).

All files are in a same folder.

Thanking you and in anticipation,
acsishere.

is the code to produce the reports in the report workbook? If so maybe keep it in an addin then you won't need to remove the VBA which can be complicated and will only work if the VBA Project is not protected.

Please Login or Register  to view this content.

If you don't want to keep any names, replace the names part above with this

Please Login or Register  to view this content.

It should be Workbooks("A.xls")

Dear Sir,

Thank you very much. Thanks a lot for the code.