Autoreload Quickpick list spreadsheet

[coco999]

I am trying to run the sample Autoreload the quickpick list (http://www.gruss-software.co.uk/Excel/A ... ckList.xls)
in order to get BA automated.

I copied the module data and procedure texts into my own sheet but the updating is intermittent. Some days it updates great, some days it doesnt update at all.

Any advice?
The sheet is running on a vps server and the macros are functioning ok. Just seems to pick and choose when to update instead of everyday at midnight.

Regards
Andy

[GaryRussell]

I fixed a bug in the latest Beta where there was a problem with the trigger being ignored when used from multiple sheets. I don't know whether you are having the same issue, but you can try the latest Beta and let me know if the problem still occurs.

See http://gruss-software.co.uk/forum/viewtopic.php?t=3922 for download link.

[coco999]

Gary

Hi

No i`m just using a single excel sheet. Just strange how some days it works and some it doesn`t

Can youn think of anything obvious? I copied the code from your sheet to my own trading sheet so wasn`t sure if i missed something?

Andy

[dgs2001]

coco

Not sure but this may help

If the code is interupted and you stop / exit it after this line

Code: Select all

Application.EnableEvents = False


but before this line

Code: Select all

 Application.EnableEvents = True


then excel can be left in the not enabled state.

To avoid this change the code in the "ThisWorkbook" to the following.

Code: Select all

Private Sub Workbook_Open()
    Application.EnableEvents = True
    Application.OnTime TimeValue("00:00:00"), "loadQuickPickList"
End Sub


this will reset the application enable to true every time the work book is opened.

Duncan

[coco999]

Duncan

I will give it a go.

Many thanks
Andy

[coco999]

Hi

Still having problems with the autoupdate. It appears when you fisrt load up the workbook the code runs the first night only but not subsequent nights.

Any ideas?