tintin1012000
Board Regular
- Joined
- Apr 27, 2011
- Messages
- 237
I have a master file which is open on a remote pc it has some connections via power query and auto saves every 20min. Its always open and anyone on network can open it readonly to view data.I want to add a refresh macro so that read only user can refresh their view without closing and opening manually. Perhaps discreet close and open without updating screen.might be the way to go but i dont know how to do this using vba. Anyone think they can help