Export filename includes Date

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi,

I've had a look through these forums but I'm still not having any luck with
this. I simply want to export a query that saves it as an excel file with a
fixed text prefix and then today's date, ie ABC220605. I'd even settle for
simply 220605.xls as the filename. I've created the simple
TransferSpreadsheet Macro then I've tried to alter it in VBA. When I try to
add anything such as "\\Directory\ABC & now() & .xls
it litterally saves it as ABC & Now.xls

I've tried to use date(), even just have no text using either date or now but
it still saves it literally. What am I doing wrong?
.

Relevant Pages

  • Re: Querying for Windows directory
    ... >I know this should be easy, but how do I query for the Windows directory ... I've googled with no luck ... Prev by Date: ...
    (microsoft.public.dotnet.framework.interop)
  • Re: SPs/ADO.NET/DataSets/DataTables/DataAdapters/TableMapping
    ... you easily retrieve the table names with a simple SQL Query... ... > Good luck. ... Prev by Date: ...
    (microsoft.public.dotnet.framework.adonet)
  • Spacer Rangers 2
    ... does anyone know of any forums or sites ... dedicated to this game? ... I searched a bit without any luck. ... Prev by Date: ...
    (comp.sys.ibm.pc.games.rpg)
  • Re: AT91RM9200-EK & BasicGraphicDisplay
    ... >If you ask the question on the www.at91.com forums you might have better ... >luck since this is read by the Atmel support team. ... Prev by Date: ...
    (comp.arch.embedded)
  • Re: What Films Have I Seen Helen Hunt In?
    ... >>> My first stop with a query like that is always http://www.imdb.com ... Luck is when the paths of opportunity and preparation cross. ... Prev by Date: ...
    (uk.people.silversurfers)