I'm just a beginner at writing macros. And I'm really lost with proper
syntax in order to point to the desired directory location where we need the
file saved.

I recorded the macro, and then edited respective to tab names, etc. I'm
thinking it's maybe the syntax around the TimePeriod string. I'm also not
familiar with all the SaveAs conditions.

Here's the statement that where I get the error:

ActiveWorkbook.SaveAs([Q:\Finance\Forecast\2007\"&(TimePeriod"\TRG\Prelim
Actual vs
Forecast],[.xls],[""],[Normal],[""],[""],[False],[False],[""],[""],[""],[""])