So if it is the case of VBA Excel not opening port, the fix i got is to only use "COM1" and not with the extra bitrate and and and..

Open "COM4:115200,N,8,1" For Binary Access Read Write As #1

Open "COM4" For Binary Access Read Write As #1