<div>
Sorry, forgot to add the original link:<br />
<a href="http://jayteknews.blogspot.co.il/2011/08/excel-user-defined-function-nslookup.html?showComment=1425071909216#c91333604348374641" rel="ugc">http://jayteknews.blogspot.co.il/2011/08/excel-user-defined-function-nslookup.html?showComment=1425071909216#c91333604348374641</a>
</div>


Sorry, forgot to add the original link:
http://jayteknews.blogspot.co.il/2011/08/excel-user-defined-function-nslookup.html?showComment=1425071909216#c91333604348374641 [http://jayteknews.blogspot.co.il/2011/08/excel-user-defined-function-nslookup.html?showComment=1425071909216#c91333604348374641]

nslookup.xlsm

<div>
Worked Like a charm.<br />
Thank you very much
</div>


<div>
<div class="content wysiwyg-content">
Hello everyone.<br />
I've found a link that shows a user-defined function that allows me to perform nslookup on a domain and recieve the IP Address of said Domain (Namely, the A record).<br />
I need however a way to modify this UDF or create one from scratch that recieves a domain and returns teh MX record of the domain.<br />
also, if the query returns multiple results, the UDF should return the one with the lower priority only.
</div>
</div>


Hello everyone.
I've found a link that shows a user-defined function that allows me to perform nslookup on a domain and recieve the IP Address of said Domain (Namely, the A record).
I need however a way to modify this UDF or create one from scratch that recieves a domain and returns teh MX record of the domain.
also, if the query returns multiple results, the UDF should return the one with the lower priority only.

User Defined function to find the MX of a Domain

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

The Domain Name System (DNS) is a hierarchical, globally distributed system responsible for associating the name of a computer, service or other resource into an IP address for connecting to the Internet or a private network. Most prominently, it translates domain names to the numerical IP addresses needed for the purpose of computer services and devices worldwide.

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.