Sending an Excel File Without Code

**Mordred** · 06-10-2011, 05:12 PM

Hi all,

I have worked on a project that some of you have been very helpful with (find the link to it here) I have since finished this project and it has been live for a few weeks now. The user sent it to some execs in the organization and they want it published on somewhere on our Intranet. The workbook itself contains a lot of code for cleaning and storing the source data, performing calculations, and then running the charting tool. All in all, the excel file is just over 2 Mb's. What I want to know is: is there a way to upload a copy of the file with only the macros for the charting tool?

**tigeravatar** · 06-10-2011, 05:23 PM

Mordred,

You could copy just the macros for the charting tool and paste them into a new module Then right-click that module and select Export. Then saveas the file to be a .xlsx file. Saving as a .xlsx will remove all code. Then close and reopen the file and in the visual basic editor, import that module you exported earlier, and save the file as a .xls or .xlsm format.

Hope that helps,
~tigeravatar

**Mordred** · 06-10-2011, 05:28 PM

Thanks tiger, so this is not something the average user can do then is it?

**tigeravatar** · 06-10-2011, 05:31 PM

Mordred,

Right. Removing all code is easy because you can just save the file as a .xlsx, but to remove all but some specific macros is trickier, and no, I suppose its not something an average user can do easily.

~tigeravatar