Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
For some reason this isn't working and it's driving me crazy...
I have a module called updater. Inside this module I have a blank sub called runUpdates. I have to have a blank sub when the program starts or it throws an error. Sub runUpdates() End Sub I have a different module and sub that is supposed to remove updater, then import the new updater with the sub runUpdates filled with code to update the changes needed. The code is: Sub checkUpdates() 'code is here to check version number and see if an update is available, if so then update = true. If update Then removeUpdater 'this removes the module updater importUpdater 'this imports the new updater runUpdates 'this is to run the code for updating the workbook End If End Sub The problem is that Excel seems to have stored the blank sub runUpdates to memory and then executing this instead of the new runUpdates. So now, if I run checkUpdates again, it thinks it already updated. Also, if another new version is released and I run checkUpdates again, it will now run the code from the previous update, not the new update. I hope some of this makes sense. Please Help. Thanks, R |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Import External Data Module | New Users to Excel | |||
code in module A to not execute a Worksheet_SelectionChange sub of another module | Excel Discussion (Misc queries) | |||
Import module in protected project? | Excel Programming | |||
Import useerfom, module in .xlt | Excel Programming | |||
Import module with vba | Excel Programming |