I need some help. I have played now for days with code which other members have written and run into error or just does not work.
What I have is a "Dispatch" excel workbook with data from sql which runs every 5 minutes populating the file on sheet "BOB".
I then have another workbook "Supervisor Plan" which looks at each cell in workbook "Dispatch" sheet "Bob" and updates when opened only
I need it to update data every 5 minutes. these are to different workbooks on a network public drive which are open by different employees.
ACTION
1. I need "Supervisor Plan" to go look at "dispatch" sheet "Bob" every 5 minutes and update without any human input (((((='P:\Excel Files\Manufacturing Floor\[Dispatch.xlsx]Bob'!B1)))) is what is in the cells.
2. Once it has the updated information I need it to save the "Supervisor Plan" to the same file name and location without human.
3. If the Supervisor plan is closed I don't want it to open and update on its own.
I have limited knowledge of VB and macros writing. So details on how to would be very helpful. Thank You
What I have is a "Dispatch" excel workbook with data from sql which runs every 5 minutes populating the file on sheet "BOB".
I then have another workbook "Supervisor Plan" which looks at each cell in workbook "Dispatch" sheet "Bob" and updates when opened only
I need it to update data every 5 minutes. these are to different workbooks on a network public drive which are open by different employees.ACTION
1. I need "Supervisor Plan" to go look at "dispatch" sheet "Bob" every 5 minutes and update without any human input (((((='P:\Excel Files\Manufacturing Floor\[Dispatch.xlsx]Bob'!B1)))) is what is in the cells.
2. Once it has the updated information I need it to save the "Supervisor Plan" to the same file name and location without human.
3. If the Supervisor plan is closed I don't want it to open and update on its own.
I have limited knowledge of VB and macros writing. So details on how to would be very helpful. Thank You
