changing an excel workbook on one computer from an excel workbook on a different computer

Computerman

Board Regular
Joined
Mar 3, 2016
Messages
91
At work we use an excel spreadsheet to keep track of which process we are at for multiple sites. As only one person can access a workbook at a time, I created multiple single user workbooks that can Sync to and from a 'Master' workbook. That part works fine. What I want to do now is when one person syncs to the master workbook I want a flag to display on all the other users workbooks forcing them to sync From the Master workbook before they can make a change and then sync to the master workbook. Here is the code I wrote to do this

HTML:
'Send Master Tracked has changed to the other users
Set KARProcessTrackerCierra = ActiveWorkbook
KARProcessTrackerCierra.Activate
For Each wb In Application.Workbooks
    If wb.Name = "KARProcessTrackerCierra.xlsm" Then
        Call SheetParameters
    End If
Next wb
Set KARProcessTrackerCarisa = ActiveWorkbook
KARProcessTrackerCarisa.Activate
For Each wb In Application.Workbooks
    If wb.Name = "KARProcessTrackerCarisa.xlsm" Then
        Call SheetParameters
    End If
Next wb
Set KARProcessTrackerRay = ActiveWorkbook
KARProcessTrackerRay.Activate
For Each wb In Application.Workbooks
    If wb.Name = "KARProcessTrackerRay.xlsm" Then
        Call SheetParameters
    End If
Next wb
Set KARProcessTrackerAshley = ActiveWorkbook
KARProcessTrackerAshley.Activate
For Each wb In Application.Workbooks
    If wb.Name = "KARProcessTrackerAshley.xlsm" Then
        Call SheetParameters
    End If
Next wb
Set KARProcessTrackerGeorge = ActiveWorkbook
KARProcessTrackerGeorge.Activate
For Each wb In Application.Workbooks
    If wb.Name = "KARProcessTrackerGeorge.xlsm" Then
        Call SheetParameters
    End If
Next wb
Set KARProcessTrackerRo = ActiveWorkbook
KARProcessTrackerRo.Activate
For Each wb In Application.Workbooks
    If wb.Name = "KARProcessTrackerRo.xlsm" Then
        Call SheetParameters
    End If
Next wb

When I run this among two different users on my system it works fine the flag appears on the other users workbook when the other workbook does a Sync to the Master Workbook. But is this possible to do across two different computers, which are on the same network. In testing I put a break point on the line that has Carisa as the user. As I cycled the code it found the master workbook and my workbook but not Carisa's (she was the only one with her copy of the process tracker open, so was the only one I expected to see). So my questions are: Is what I am trying to do even possible, and if so, what should I change in my code to make it work?
If you have made it this far, thank you for taking the time to read this and I hope that I made it clear what I am trying to accomplish.

Computerman
 

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

SpillerBD

Well-known Member
Joined
Jul 2, 2014
Messages
2,710
The code will run on the local application, yours, but not Carisa's. If she has her file open, then it will be locked and unavailable for your sessions macro to evaluate.
The WebApp provides the sync functionality you are looking for.

However the overall task is not a good fit for Excel. There are several Access templates that are good.
A shared OneNote binder has advantages too when the Tags and Tasks are considered.

The master can be a reporting document. Get & Transform makes it easier but the combining by macro is okay. Then opening by multiple people is okay as it should refresh on open and save so the first person to open updates and all other simultaneous views see latest update. Have a updated date/time displayed.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,582
Messages
5,625,619
Members
416,124
Latest member
DeMoNloK

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top