ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Import module then run code not working. (https://www.excelbanter.com/excel-programming/320508-import-module-then-run-code-not-working.html)

R-Enemy[_5_]

Import module then run code not working.
 
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


All times are GMT +1. The time now is 02:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com