Creating a macro to import from Excel

[Guest]

I am trying to create a macro to import data from a secific spreadsheet in
excel. This macro will be run by a command button on a form to import data
from Excel. I selected the Transferspreadsheet function and filled all the
required info. It's givig me an error "Failiure Creating File". Any advice on
creating macros will be appreciated.

Thanks in Advance

 

[Ken Snell [MVP]]

Tell us the details that are in your macro.... can't help until we see what
you have designed.