Transfer Spreadsheet

M

mcp201

In my macro I am trying to use the transfer spreadsheet option to archive a
file so I wouldn't have to manually copy this file into folders each week.
What would be the proper input for file name??? For example, Im trying to put
this file named WTD in B:\Finance\2008\December\Week 1 where every week its
archiving it in the correct place. Thanks in advance.
 
K

Ken Snell \(MVP\)

What is your specific issue? The filename argument for the
TransferSpreadsheet action would be this:

B:\Finance\2008\December\Week 1\WTD.xls

Be careful if B is a CD or other drive. It's not a good idea to export
directly to such media from ACCESS.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transfer Spreadsheet 1
Transfer Spreadsheet 4
Help with organising info 1
Need help gathering data from various files 1
TransferSpreadsheet acImport: can you add data UNSOLVEABLE??? 1
Intuitive Macro that changes based on cell value 13
Copy tab from one spreadsheet to multiple tabs in another spreadsheetwhile retaining the targets spr 15
MACRO Question 4

Top