You're on the right track, but I think the problem is in the use of the
Format function. You *may* have to encapsulate the call to Format in a
Str() function in your concatenation. But why use Format at all? I just
use something like Trim(Date) in similar circumstances and it works fine.

I'd also include the userID in that string, or create individual user
folders for the output. Your customers will probably prefer the latter,
based on my own experience along these lines.

Randall Arnold

"Ian L." wrote in message
...
I have an excel (XP version) application in use on a
network. The app is being run by 50+ different users,
and currently they output the final result sheet to a
printer on completion.

I would like to save some trees and instead of printing
the output, I would like to save it to a folder on the
network. The problem is, each user prints between 5 &
10 of these sheets per shift.

Not all of the users are computer savvy, so in order to
avoid everyone saving their files over everyone elses, I
would need to write a macro that would save the file
automatically to a specific folder. At the same time it
would also need to generate a unique file name for each
individual user!

Does anyone know if this is possible, and can you give me
any pointers please?

I tried something like this:

Thisworkbook.SaveAs "X:\SpecialFolder\ & "ABC" & _
format(now,"yyyymmdd_hhmm") & ".xls"

but I get syntax errors or expected end of statement
errors.

Thanks in advance.

Ian.