path to copied workbook problem

[mlaxx]

I have the following situation: A file - fisierzero.xlsm that is on the Desktop, and two other files: one in the laminate folder named laminate.xlsm and one in the monolit folder named monolit.xlsm.
I guess I do not give the correct path in the VBA code because I have error 9 out of range error. all files are open.

Please Login or Register  to view this content.

[Marc L]

As it depends on which codeline the error occurs …

[Fluff13]

If the files are open, then you don't need the file path, just the file name.

Please Login or Register  to view this content.

[mlaxx]

MArc L The error is highlighted in yellow here:

Please Login or Register  to view this content.

[Mumps1]

Try:

Please Login or Register  to view this content.

[Marc L]

So the workbook is not opened or a typo in the path but first try Fluff13' suggestion.

As you can check if a workbook is opened via the worksheet function ISREF …

[mlaxx]

Thank you very much. both solutions work. Still a question. If the file fisierzero.xlsm would be on Desktop on computer no 1 and the other files would be one on the computer no 2 and the other on the computer no 3, and if they were open, would the VBA code work?

[Marc L]

As it works only within the same Excel instance …

[Fluff13]

You're welcome & thanks for the feedback.

All the files need to be open on the same computer

[mlaxx]

So I understand, if the files are on different computers did not work?

[Marc L]

If you can open a workbook from another computer …

[mlaxx]

The idea is that the fisierzero.xlsm file will be opened on a computer, and the other two files will be opened on each computer.In this scenario I suppose it will not work?

[Marc L]

No as I yet wrote in post #8 like Fluff13 in #9 …

[mlaxx]

ok. can you suggest me where to look for a solution for this scenario?

[Fluff13]

You cannot run a macro over various computers. The files all need to opened on the computer running the code.

[Marc L]

mlaxx, why don't you use the same way you wrote on another forum's thread
aka files « in a folder on a server. […] The path to the folder would be "Z: Production \" » ?

So it would be easy to open all files on an unique computer in order to execute your procedure …

[mlaxx]

Marc You're right. I was going to post here this information too. For the scenario where the filezero.xlsm and the files monolit.xlsm and laminat.xlsm are on a server, the path to the files would be "Z: production \", how could I do the following work:
A user opens the filezero.xlsm on computer 1, another user opens the laminat.xlsm file on computer 2, and another user opens the monolit.xlsm file from computer 3.
The goal would be for users on computer 2 and 3 to see any changes made to the filezero.xlsm.
I'm sure I did not present the problem I started in the right way, and I honestly did not know about the one-instance thing in Excel.
I suppose technically, with Excel I do not have much chances to create this way of working.

[Marc L]

Nope as Excel is far not a network database software …