Advanced VBA-Use IDE to insert & run code in a new workbook after ThisWorkbook closed?

The thread title says it all.

I want to run code after ThisWorkbook is closed. Can ThisWorkbook use VBA to create a (temporary) new workbook, insert code module into the new WB and then use Application.OnTime to fire this new module code shortly after the ThisWorkbook closed?

Hello Kyle

Firstly +1 for taking the time to provide such detailed constructive criticism (As you may have noticed from my signature - I usually don't like to see forum users publicly criticize the OPs need for the thread solution - but I make an exception here as you are obviously trying to help).


The points you raise are valid however most of them won't apply in the usage I have in mind. I'll explain:

1. Manually removing an add = What you are seeing is only a small extract of a much larger project. Part of it contains an auto-update/install for the next version of the add-in. So I need to manually unload & uninstall the old version. And I prefer to automate the removal rather than having to manually do it.
2. Users permission = In this case, the end user will be myself and 2-3 close friends. So that won't be a problem here.
3. Send Keys = Yes I know. I found the Add-In Cleaner code on the net and I can't see anyway around the use of Send Keys for this macro. (If you know otherwise, I would be grateful )
4. OnTime = I wasn't aware that onTime was so iffy. Could you suggest another alternative? (In regards to the end user closing the workbook = the 3-4 users who are using this project have enough VBA nous to not do that )

P.S. my use of "IDE" - I haven't done a course on VBA so I don't always use terminology in the correct sense. I use "IDE" to refer to VBAs use of the IDE reference library to add/edit VBA code from VBA. (I haven't learnt how to write IDE yet so that explains why I can't try it to solve this thread).

IDE stands for Integrated Development Environment (it isn't a language or methodology) and refers to the tools that are provided to help you code, intellisense, compilation errors, object browsers, debugging etc, other IDEs exist for other languages (and many cross purpose ones); Microsoft has Visual Studio, eclipse is often used for Java etc... They are distinguished since you don't technically need an IDE to write code, for example if you were so inclined you could write C# code in notepad and compile it - in fact many developers (notably web, but certainly not exclusively) tend not to use IDEs preferring customizable text editors like Text wrangler or Notepad++ (or if you're really hardcode vi/vim). For example, I write a lot of JavaScript and I use Notepad++, then I use Chrome to debug, but I reckon you could almost claim that Chrome isn't far off an IDE

This is possibly why your questions come across as slightly odd, your use of "IDE" is just wrong

I'm going to duck out here and refrain from telling you why I disagree with your points, but I hope you achieve what you are looking for

Hello Kyle,

Thanks for the correction of IDE. How then should I refer to the use of VBA to create/edit VBA?

Using another WB to run code after closing was a bad idea. I'm now looking at using scripts instead.

This webpage looked promising http://stackoverflow.com/questions/1...e-updated-xlam

however it doesn't work. The code stops after unloading ThisWorkbook from add-ins.