Scotland's economy is in a "very difficult position" which will force tough spending decisions in the coming months, the finance secretary has said.