XConnect

Friday, February 16, 2024

XConnect() - Open a connection

Description

This function opens a connection.

Parameters

Filename [Optional]

Connection name.

User [Optional]

Sage 50 user name. (For Sage 50 Canadian Edition only. For Sage 50 US Edition, the User must always be Peachtree.)

Password [Optional]

Sage 50 password.

Examples

It is strongly recommended to use Excel cells address (ex. A1:B19) containing the information of the parameters requested in all XLGL functions, such as: accounts, date, departments, etc. This practice adds flexibility to your worksheet and will ensure the coherence of your results. Moreover, the use of quotation marks (") is essential when the parameters are manually written in the arguments function window.

Opens a connection to "My Company" with the default user and no password
=XConnect("My Company")
Opens a connection to "My Company" with user "Peahtree" and password "Pass123"
=XConnect("My Connection","Peachtree","Pass123")

Was this article helpful?

 
Thank you for your feedback

Contact Can't find what you're looking for?

You can Contact us so we can address your question.