Transfer Spreadsheet

[mcp201]

I wanted to know if the following is possible:

With the transfer spreadsheet action, I wanted to save a copy of certain
files in a directory. The problem is I dont want the file to overwrite
another file. I want it to save out in the correct year, month, and week. Is
this possible? Thanks in advance.

 

[Arvin Meyer [MVP]]

You say Action. That implies using a macro, and there isn't any way to do it
with a macro. If you use the TransferSpreadsheet Method in VBA code, you can
name the file in code before you create it.

 

[Ken Snell \(MVP\)]

Actually, this can be done in a macro. Just use an expression in the
Filename argument of the macro to build the filename:

="C:\MyFolder\MyFileName" & Format(Date(), "yyyymmdd") & ".xls"

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/

 

[mcp201]

I actually tried this and the table I wanted saved out there, didn't save
out. Am I doing this wrong?

 

[Ken Snell \(MVP\)]

Did you include the = sign in the expression? It must be there.

Otherwise, post the values/names/expressions of all the arguments that
you're using for the TransferSpreadsheet action in the macro. Let's see what
you're trying to do.

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/