Access to Excel Sheet within shared folder

[danielaac]

Hi, I have the following problem, I have an Excel sheet open and updated continuously on a PC (1), and I would like another Excel sheet to another PC (2), could access the PC (1) certain cells each 5 sec. Is it possible? if anyone knows how can be done, I'll appreciate forever.

A greeting

 

[dantheman9]

yes it is possible,

depending on what excel version you are using, you would need to set the first excel file up as a shared workbook (which will then allow access from more than one source to it).

in excel 07 you can do this by going to review ->share workbook then allow changes to workbook by more than one user.

on the second pc you can then open this workbook at the same time.

depending on your network speed you might need wait for updates a bit longer than 5 seconds, but the code to rerun would be

Timerun = Now() + TimeValue("00:00:05")
Application.OnTime Timerun, "NAME OF SUB TO RERUN"

add it at the bottom of your copy and paste, and add the name of the Sub in the " " area, that would set it to rerun automaticly.

hope that helps

 

[danielaac]

Dantheman9 Thanks, but I ask you please to tell me how would the macro, with all the instructions, because I'm not a programmer and I get lost easily. If you do me this favor would be very grateful.

Greetings

 

[dantheman9]

it would be helpful to see the layout of your excel sheet?

I'm no programmer either (or at best an beginner)...but will see what i can do....
In terms of the updating of code, you could also try the marco recorder (start it, copy and paste the cells you what to update), then add the code below just before End Sub, then you would have the repect process in place.

 

[danielaac]

When recording the macro, it just copy the local instructions, and do not know which network, if anyone knows what instructions are needed, please do leave them in this post, I appreciate it.

Daniel