Delete code when saving the file

**Bob@Sun** · 01-23-2010, 02:50 PM

Hello again,

I have posted already the problem to delete the code when sending a sheet via email and I have found the solution to the problem.

I tried to do the same when saving the file to specific folder, but i am facing problem.
The code that I am using now is:

Please Login or Register  to view this content.

Can I add somewhere in this code the lines that will delete the code form the file?

Please Login or Register  to view this content.

**royUK** · 01-23-2010, 02:57 PM

Can't you call the macro that deletes the code that you have in the other reply?

**Bob@Sun** · 01-23-2010, 03:05 PM

Do you mean this macro?

Please Login or Register  to view this content.

I tried but probably I am not calling the macro in the right place because it is not working.

Where should I add the Call DeleteAllVBACode function in my code?

**royUK** · 01-24-2010, 04:42 AM

I would recommend that you test on a backup copy. Try

Please Login or Register  to view this content.

**JeanRage** · 01-24-2010, 05:14 AM

Hi,

As a quick reminder, do not forget in VBE
Tools>References
Microsoft Visual Basic for Applications Extensibility ...

HTH

**royUK** · 01-24-2010, 05:27 AM

For others' reference,this is a continuation of an earlier post

**Bob@Sun** · 01-26-2010, 04:42 PM

Thanks to all! I got it to work

Delete code when saving the file

LinkBack

Thread Tools

Rate This Thread

Display

Delete code when saving the file

Re: Delete code when saving the file

Re: Delete code when saving the file

Re: Delete code when saving the file

Re: Delete code when saving the file

Re: Delete code when saving the file

Re: Delete code when saving the file

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions