Hi there excel peeps, Hope you all are well.

I've got a bit of a problem, no one I know can help, and I can't find
the A team!!!!

PLEASE.

Can anyone give me the Visual Basic Code to open up a 'save as' dialog
box, with the filename as 'dd/mm/yy_sportsreturn', (dd/mm/yy being the
save date or a cell reference to a date), but give the user the ability
to save the file where they want to?

I've had a few goes, but i'm new to VBA and I can get the file to save
as a date formatted filename but I can't just get the box to open with
the correct filename, filetype(excel), and let the user put it where he
wants. It's getting a bit frustrating.

If i'm asking too much from excel/VBA can someone just give me a nudge,
i'll shut up and go do an ECDL course or something :)

Many Thanks in advance

Gaz


--
Cobbcouk
------------------------------------------------------------------------
Cobbcouk's Profile: http://www.excelforum.com/member.php...o&userid=32143
View this thread: http://www.excelforum.com/showthread...hreadid=528247