Transfer Spreadsheet

  • Thread starter Thread starter mcp201
  • Start date Start date
M

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.
 
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.
 
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/
 
I actually tried this and the table I wanted saved out there, didn't save
out. Am I doing this wrong?
 
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/
 
Back
Top