Transfer Spreadsheet

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.

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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"mcp201" wrote in message
...
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.

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/


"Arvin Meyer [MVP]" wrote in message
...
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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"mcp201" wrote in message
...
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.

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


"Ken Snell (MVP)" wrote:

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/


"Arvin Meyer [MVP]" wrote in message
...
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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"mcp201" wrote in message
...
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.

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/


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


"Ken Snell (MVP)" wrote:

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/


"Arvin Meyer [MVP]" wrote in message
...
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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"mcp201" wrote in message
...
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.