Jeanette It may be better to use VBA in which you can use CopyFolder method to enable the user to browse for the filename. You can then use the filename in your TransferSpreadsheet method. If the path is always the same, then you can use Inputbox for the user to enter the filename which you can use in your TransferSpreadsheet method
HTH Liveson ----- Original Message ----- From: "Jeanette Garcia" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Monday, 27 March, 2006 21:27 Subject: [ms_access] Import Inquiry My IS dept runs a datadump for me and places on the network. The path is always the same but the file name is the date. With a changing file name, it makes the auto-import that I'd like to add into the database that accepts this information more difficult. Is there a way to add into the TransferSpreadsheet macro action to put the path but then a prompt for file name? It will always go into the same repository table within the database. Just need a way for it to know which file to import. Your help is very much appreciated! Jeanette~ ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. Yahoo! Groups Links Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
