The Word is our rock and foundation. The way we know truth from untruth. The Spirit leads, guides and comforts us, within the parameters set up by the Word. Sometimes that is also rebuke, or teaching when we have been wrongly taught.
I am most aware of the work of the Spirit when I read my Bible, but also when I am doing ministry in my chaplaincy. The Holy Spirit always gives me the Bible verse the person needs most for encouragement and hope.
I am so grateful to be able to have the freedom to read and preach the Word, under the continual guidance of the Holy Spirit. So yes, there is a HUGE relationship between the two.
"But the Helper, the Holy Spirit, whom the Father will send in my name, he will teach you all things and bring to your remembrance all that I have said to you." John 14:26