M
mcp201
In my macro, I am trying to archive text files which are linked into my
database by using the Transfer Spreadsheet option. I wanted to know if there
is a formula or some way in which I will be able to send these files in the
current year, month, and week's folder.
For example, I have WTD, MTD, QTD, & YTD files. I would like to copy these
files into B:\Finance\Group\2008\December\Week 1 each week instead of
manually doing it. Is this possible? Thanks in advance.
database by using the Transfer Spreadsheet option. I wanted to know if there
is a formula or some way in which I will be able to send these files in the
current year, month, and week's folder.
For example, I have WTD, MTD, QTD, & YTD files. I would like to copy these
files into B:\Finance\Group\2008\December\Week 1 each week instead of
manually doing it. Is this possible? Thanks in advance.