remove a module with a macro

paul20091968 · May 19th, 2006, 09:07 AM

Hi,

Could somebody give me an example please how to delete a module with a macro?
I have an excel with module1 but after saving it in a report folder for users to read, I would like to delete module1 in that file.

Im a newbee with VBA so a simple example would be great

rgrds,

Paul.

interrupt · May 19th, 2006, 09:58 AM

Hi,

Just dump the report into a new workbook. That way you don't have to worry about deleting the module.

HTH
Joe

paul20091968 · May 22nd, 2006, 03:50 AM

What is the dump method? copy and paste all content form the worksheets and paste them in the new workbook?

paul20091968 · May 23rd, 2006, 03:58 AM

Ho do you dump the data into a new workbook?

Quote:

quote:Originally posted by interrupt
Hi,

Just dump the report into a new workbook. That way you don't have to worry about deleting the module.

HTH
Joe