directory lookup

[Guest]

how can i access a specific folder on a drive, pick an excel file, and then
move that file to a generic excel file via a menu button? the generic excel
file would be retrieved via an import query.

 

[pietlinden]

how can i access a specific folder on a drive, pick an excel file, and then
move that file to a generic excel file via a menu button? the generic excel
file would be retrieved via an import query.

Wow. High expectations.

how about using the OpenSaveFileAPI? (see http://www.mvps.org/access/api/api0001.htm)

what do you mean "move that file to a generic Excel file"? Do you
mean (a) Open the file, (b) Copy the contents of the file somewhere
(like to a new XL document)?

What do you mean by "a generic Excel file"? A new file? a template?

 

[Guest]

we send excel files to one of our subsidaries on a daily basis. that group
will select a series of files at week end to process to another system. as
part of that process, information is added to orig file.
so what i want to is have the subsidary group select whatever files they
want. the selected file would then be placed into a std name file. that std
name excel book would be recognized by a query, so that could import to an
access data base.
from there, i can do the necessary processing thru access and finally export
a file for the other system.

so, i was thinking if i had a file called 'importfile', once the excel work
book is selected from the directory, that book would go to a book called
'importfile'. from there queries will take over.