VBA code to select Custom Views at specific times in the day

Hi there,

Take a look at the attached version of your workbook and see if it does what you need. It uses the following code which is inserted in the "ThisWorkbook" VBA CodeModule:

Please Login or Register  to view this content.

The highlighted values may be altered to suit your requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M

Hello Greg M, thanks for your quick reply. It doesn't seem to be working for me yet. When I first open your attachment, I get this runtime error "Run-time error '1004': Method 'Run' of object '_Application' failed" on this part of the code. Am I missing a step?


'=========================================================================================
'=========================================================================================


Private Sub Workbook_Open()

mdteNextRun = Time()

Application.Run msPROCEDURE_NAME

End Sub

Hi again,

Thanks for that feedback.

Hmmm . . . seems strange, as it works correctly on my system (Excel 2016).

See if making the highlighted change makes any difference:

Please Login or Register  to view this content.

Hope this helps - as before, please let me know how you get on.

Regards,

Greg M

Hello, that didn't seem to work either. Now I'm getting "Run-time error '5': Invalid procedure call or argument"