Automating the import process

A

AttackIP

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
 
K

Klatuu

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.
 
A

AttackIP

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...
 
Top