Macro to Import Data?

[Becca]

Is it possible to write a macros that will import data
from a spreadsheet in excel? Or link a table via a
macro? If so, can you point me in the right direction for
help with the code? TIA
Becca - NOT the Macro Queen

 

[tina]

take a look at the TransferSpreadsheet macro action.