I use excel or VB, leave the host blank, it refers to the machine name. So if you are running excel and the TWS on the same machine, host is blank.
If TWS and excel are running on different machines on a network, its the machine name on a network.
One word of warning the data updates so fast, that excel can hit a permanent state of "calculating" so they slow the data refresh down.