VBA Code that Refreshes/Reopens Current Excel Workbook

[faltaman]

Hello,

I manage a networked system of computers at my local office, and I was hoping to find some VBA help. I have an Excel file hosted on my PC that contains local data without external links to outside data. I personally add/delete data to the Excel file daily and other users who open said file on my network can open a copy (Read Only since I keep the master file open on my PC). Users currently have to close their copy of the file and reopen it every time they want to update the
worksheet (again, no external references). I'd like to add a macro/VBA script that would allow a user to basically refresh the current worksheet to include any changes I've made to the master file.

I searched some of the threads and saw a command of ActiveWorkbook.RefreshAll, but that didn't work. Is there a macro/VBA script that I can tie to a button that would refresh the user's Read Only copy of my file without having to close/re-open the file?

Thanks in advance!

[ptmuldoon]

Not sure if VBA is the answer here. I think you maybe just need to allow the Sharing of the Workbook in the office. Other's can the see the change realtime as they happen, and I believe (but not certain) you can limit what each user can do to the file.

A basic google search on Excel Workbook sharing may help.

[Old4xford]

Not sure if VBA is the answer here. I think you maybe just need to allow the Sharing of the Workbook in the office. Other's can the see the change realtime as they happen, and I believe (but not certain) you can limit what each user can do to the file.

A basic google search on Excel Workbook sharing may help.

"Review" tab >>> "Allow User to Edit Ranges" >>> followed by "Protect and Share Workbook" with a password.

[Phixer]

What you could do is create a button that runs a macro that overwrites a remote file with a current version of the file and then automagically converts it to Read-Only (as a file attribute) so others can't change it. This won't allow others to refresh it, though, without reopening.

Another option can use external data queries (users would query your file, which must be visible on the network to be refreshed). This would eliminate the need to reload the file.

Or, outside of using Office, you can create a shared Google Sheet and update that and it will change live time without the need for refresh.

Just a few ideas off the top of my head.