Want to write a Macro to Import Excel Spreadsheet

's Computer Specifications

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.

's Computer Specifications

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.

"Scott" wrote:

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Import excel spreadsheet into an excel spreadsheet	=?Utf-8?B?a2ZsZXRjaGI=?=	Microsoft Excel Worksheet Functions	2	4th Aug 2006 12:49 AM
In Excel I want to copy text from spreadsheet to spreadsheet	=?Utf-8?B?S3Jpcw==?=	Microsoft Excel Worksheet Functions	3	9th Jun 2006 07:58 PM
is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data?	Daniel	Microsoft Excel Discussion	2	23rd Jun 2005 11:40 PM
is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data?	Daniel	Microsoft Excel Worksheet Functions	1	23rd Jun 2005 11:38 PM
is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data?	Daniel	Microsoft Excel Discussion	0	23rd Jun 2005 11:28 PM