How can I refresh a network excel workbook that is in constant use?
I have a workbook that in use all day, this workbook is recording data every 5 to 15 mins, and I need to know if there is a way to; open it and so how refresh it. If I build a macro to open it and close it, as soon as I close the workbook the opening macro can be activated because the workbook is close, so is there a way to use may be a vbscript or any other vb code to use it in Excel pulldown menu and as I open the workbook I can run a code to open and close the workbook so I can see the most update data?
Have researched for awhile with no luck, but I know someone will come with a cleaver way to do this.
Even if the code is outside Excel will be helpful, something I can put in my desktop and trigger it, off course if it can be put in a button a menu will be better.
Thanks in advance for the replays.