If the serial port is, say, COM1 (in old DOS/PC terms), you would use
Open "COM1:" for input as file #1
You need to know the correct device name. Other than that, it is usually pretty simple. However, a word of caution. VBA will treat the action as SYNCHRONOUS - so if there is a long delay associated with the port, your program might appear to go nowhere for a long time.