Creating a macro to import from Excel

J

Junaid

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
 
K

Ken Snell [MVP]

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