Automating the import process

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

Guest

I'd like to add a button to a form that automates the "File - Get External
Data - Import" process to import an excel file... any suggestions?

Thanks
 
Look in VBA Help for the TransferSpreadsheet method or action.
If you use VBA, you will use the method version and for a Macro, you will
use the action.
 
Well that was too easy... thanks!

Klatuu said:
Look in VBA Help for the TransferSpreadsheet method or action.
If you use VBA, you will use the method version and for a Macro, you will
use the action.
Click to expand...
 
Back
Top