Want to write a Macro to Import Excel Spreadsheet

[Scott]

I am trying to write a macro to Import an Excel Spreadsheet. The spreadsheet
will always have the same naming convention: c:\SOP\Input_File.xls and the
file will have the same layout.

Can this be done via Macro, or do I need to use VBA?

Thank you.

 

[Scott]

I am all set. Read through a couple other posts on the Transfer Datasheet
command.

Thank you all for posting Questions/Responses on this website.