I am trying to create a macro for a workbook we have created that will simply refresh the data on the workbook once it is opened every 5 minutes.
This is what I have written into the macro:
' AutoRefresh Macro
Application.OnTime Now + TimeValue("00:05:00"), "AutoRefresh"
It is a pretty simple macro, but it isn't working.
The way I have tested it is that I have the workbook opened on multiple PCs on the network. I then have one user update the data on her PC. 5 minutes later or more, I check the other PCs that have the workbook open. None of the updated data shows up.
Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat. The purpose of this eBook is to educate the reader about ransomware attacks.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…