Another Excel Save Problem [RESOLVED]

[wakka]

Hello Everyone!

I posted a topic yesterday regarding saving a file in Excel to today's current date which stanav helped me out with (Thanks Again Stan!) however I did have one little problem.

When I have the application save the data using the following code:

objExcel.ActiveWorkbook().SaveAs(Format(Now.Date, "MMddyy"))

It automatically gets saved to the My Documents folder on the machine. How would I go about saving this file in this date fashion shown above but also save it to a directory in particular....lets just say save it to C:\TEST...

I tried saving the file using this code:

objExcel.ActiveWorkbook().SaveAs("C:\TEST"(Format(Now.Date, "MMddyy")))

But would get the follwoing error after I ran the program
Index was outside the bounds of the array.

Thanks!!