Macro to open a toolbar command

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to open the "File...Get External Data...Import..." toolbar
commands with one click on a command button in a form. How do I create a
macro to do that?
Thanks,
JimAA
 
Jim
This is what you need I think. Just put it in the click event of the
button on your form
DoCmd.RunCommand acCmdImport
REgards
Stephen
 
Jim,

Use the RunCommand action in your macro, and in the Command argument
enter Import. Save this macro, and assign on the Click event of your
command button.
 
Back
Top