ouestque
asked on
Excel 2010: identify location network was accessed
My client has a building with 2 floors and 200 desks. Everyone has the exact same laptop that can dock/use the internet at any desk whenever they want. This concerns my client, but IT mentioned to my client that they can detect when/where people dock at any time and can detect people that dock/use the internet but don't belong to the building. I'm thinking if the IT departments claim is true, then there is something unique at each desk. (i.e., a special address, number, something special about the connection there etc.,) Nonetheless, I didn't notice any special device at any desk other than the dock.
To prove IT is correct, my client would like for me create an Excel file with a button. When the button is pressed, it will display something unique about the place that was docked and/or internet was used.
Anyone have any ideas on how to do this? I'm willing to explore API. Below is a little piece of code I created originally, but it does not provide any information that is unique/representative of the location I docked or internet was used.
For x = 1 to 100
debug.print environ(x)
next
To prove IT is correct, my client would like for me create an Excel file with a button. When the button is pressed, it will display something unique about the place that was docked and/or internet was used.
Anyone have any ideas on how to do this? I'm willing to explore API. Below is a little piece of code I created originally, but it does not provide any information that is unique/representative of the location I docked or internet was used.
For x = 1 to 100
debug.print environ(x)
next
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Neilsr. Based on your answer, My understanding is that there is no VBA or API calls I can use to figure out which switch or port I'm connected too?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Example Excel code to pull back info from IPCONFIG:
https://social.msdn.microsoft.com/Forums/en-US/b7f46967-786f-4200-9b2e-deb085a8e7cf/excel-vbmacro-how-to-get-pc-ip-address-and-netbios-system-name-?forum=exceldev
https://social.msdn.microsoft.com/Forums/en-US/b7f46967-786f-4200-9b2e-deb085a8e7cf/excel-vbmacro-how-to-get-pc-ip-address-and-netbios-system-name-?forum=exceldev
ASKER
Thanks guys. It sounds like I need to learn more about how all this works. I would love to read more about it. f you have any advice on some reading that could enlighten me more on how all this works will you post it? Thanks again.
You say "My Client", what is your role? What are you contracted to the company to do/provide?