Access VBA - Have the Previous Month display on an Excel report

I need the current month - 1 to display in Excel using VBA.

I tried this in my template
Month(today())-1 and it gives what looks like a month (ie...for current it's 7) but when I change the format to mmmm then it displays January. Basically it looks like it's having the month be the day. Anyway, can someone help me please please please? I don't care if it's in the excel template or in my vba code. Either one will do. Thanks - you guys rock.

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.