<< Click to Display Table of Contents >> Navigation: PaXcel - functions > General Functions > CompanyDetails() |
CompanyDetails( Company, FieldToReturn )
This function will return your company details from Pastel.
The arguments are as follows:
Company: This is the path to your Pastel data directory. For example:
c:\PastelData\_demo would enable you to retrieve information from the Pastel Partner demo company.
FieldToReturn: This should be one of the following keywords:
Returns Keyword
Company Name Name
Company Address 1 Addr1
Company Address 2 Addr2
Company Address 3 Addr3
Company Address 4 Addr4
Company Address 5 Addr5
Company Info 1 Info1
Company Info 2 Info2
Company Info 3 Info3
Company Info 4 Info4
Company Info 5 Info5
Current Period Period
Last P&L PL
#Company Reg Number CompanyRegNo
#Company Tax Number CompanyTaxNo
#Fields are available in Sage Pastel Partner 12.1.6 onwards
The company information can be found in Pastel under Setup|Company Parameters
The path can be a reference to an Excel cell for example:
CompanyDetails( A1, "Name" )
Retrieves the company path from cell A1 and returns the company name from Pastel
CompanyDetails( A1, "Info1" ) Retrieves the company information line 1 |