working with multple users

[marik9581]

hi

I have several excel files with vba code, using 1 data file.
how can multiple users work with 1 data file?

also, how can i work with data file without opening it each time i need to read some data from it?

i will explain:
1st excel file read some cells from sheet1 on another excel file. if i try to read the cells without opening the 2nd data file - i get an error.
maybe there is another way to store data in a way i dont have to open, and can just read the data from it without opening it each time.

 

[dmt32]

hi

I have several excel files with vba code, using 1 data file.
how can multiple users work with 1 data file?

also, how can i work with data file without opening it each time i need to read some data from it?

i will explain:
1st excel file read some cells from sheet1 on another excel file. if i try to read the cells without opening the 2nd data file - i get an error.
maybe there is another way to store data in a way i dont have to open, and can just read the data from it without opening it each time.

If you just need to read data from your master file, then open it Read Only - this should allow any number of users to do the same thing without causing any conflict error.

Alternatively, if you really want to do this without opening then have a look here:https://www.rondebruin.nl/win/s3/win024.htm
which may be something that will help you.

Dave