I have list of ad groups in excel and I want to get the list of users (first name, last name) separated by semicolon in the same sheet but separate column. The function will take the group name and get the list of users. I have a script from Rob (Thanks Rob) but don't know how to call the AD with in excel function (macro). The script that enumrates is shown below.
Ex. Groupname in A1 will pass into the function and the list of users in group A1 will be listed in E1.