Results 1 to 1 of 1
  1. #1
    Platinum Member Array Shenong's Avatar
    Join Date
    Apr 2009
    Thanked 1,684 Times in 428 Posts

    Lightbulb Add-in A-Tools : Query, Share Excel file on LAN, internet with multiple users

    ( (

    Add-in A-Tools: Query, Share Excel file on LAN, internet with multiple users

    Add-in A-Tools allows sharing and managing Excel file on LAN, internet. Someone can open Excel file in server at the same time for editing and saving. Clients connect to server by TCP/IP protocol (not share full folder - Excel's way), server manage connections with restrict users, setting rights for each user group: read only, edit, limit how many people can open a worksheet,....,When data in spreadsheet is changed then other computers on LAN, internet are updated immediately (after about ~ 1 millisecond).

    How can I do with Add-in A-Tools?
    1) Share Excel files over the Network among users. Client connect to server by TCP/IP protocol, login with IP address, Domain
    2) Restrict Users to sheets, range address, workbook
    3) Restrict Users to edit only certain Cells in that sheet
    4) Restrict Users to print, copy sheet

    5) Some users can edit at the same time on sheet but can not clear or change data of others. User is leader can change data of users who in the same group.

    6) User have rights "Approve" can approve rows in sheet or all sheet so all users in network can not edit when rows, sheet have approved.

    7) Chat with other in Excel.
    8) Query data on sheet by execute SQL language. Connect to any database in your computer and link data to sheet. With function BS_SQL you can create professional.reports for high speed with large data in sheet, so very easy with draw and drop by mouse on SQL Builder.

    Add-in A-Tools can create dynamic reports by using the functions to query the database (DB) with T-SQL language. It also allowers users to connect to the internal and external database such as Excel, Access, Foxpro, MS SQL, MySQL and Firebird,... for instance. The "SQL Builder" helps users to create a query formula (with BS_SQL function) easily and efficiently. Users are able to create highly sophisticated worksheets which are filtered according to various conditions and associated with different data sources. In that way, accuracy, stability and high speed are ensured.

    Crack Intallation : The file "AddinATools.dll" has to be copied to c:\Windows\SysWOW64\AddinATools.dll if you have Windows x64 , and not sure in Windows x86 in system ( still untested under x86 )

    D/L Multi-Links:

    Password =
    Last edited by Shenong; 09-30-2018 at 10:31 AM.

  2. The Following 4 Users Say Thank You to Shenong For This Useful Post:

Similar Threads

  1. Req: Converter file XPO to Excel
    By laser1000it in forum Trading Platform
    Replies: 2
    Last Post: 10-04-2016, 09:15 PM
  2. Replies: 12
    Last Post: 08-07-2013, 06:17 AM
  3. [SHARE] Useful tools
    By musketeer in forum MetaTrader Expert Advisors
    Replies: 2
    Last Post: 07-14-2011, 06:33 AM


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts