Macro: Access File From Workgroup

  • hi,


    On network we can access a file through this code workbooks.open("\\acb\newfolder\abc.xls").


    But how can we access a file from a workgroup.


    Thanks in advance.


    Regards,

  • Re: Access File From Workgroup Through Macro


    A workgroup is only a collection of computers that are joined in a peer to peer network.


    You need to create a shared folder on the computer where the file is located. If people will be changing the file make sure that have the rights to change data (the second check box in the file sharing dialog).


    Then, making sure that all the computers in the work group have different names, yoiu can access the file in the same way: \\computer_name\dir_path\file.xls.


    Regards


    Rich

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!