connect to excel

Hello, I've got a problem with connection HeidiSQL to Excel. I choose normal in excel, datas from sql server, and i've got a table, where si a question for server name. is some command in sql, which will tell me server name, pls? or where i can find server name? After i want to make a macro, which will connect to SQL and choose datas which i need (only some selects, sorts and etc). thanks a lot and have a nice day.

If you already connected via HeidiSQL, then you have the hostname in the session manager.