T
Tony Pearson
Guest
I have to transfer data from excell spreadsheet to a single access table. However each time I do the transfer it is from a new excell file (the format is always the same though) Currently I manually run a macro but have to write the file name each time. Is there a way I can do an automatic transfer which just asks the user which file they want to transfer from. The excell files are always in the same directory/folder.
I am very much a simpleton with VB so please keep any explanation simple!
Thanks
Tony
I am very much a simpleton with VB so please keep any explanation simple!
Thanks
Tony