Unattended Import to an excel spreadsheet
 

I have data in a sequential file that I would like to import into an
excel spreadsheet by using a batch file. Is there a quick and easy way
to to an unattended import into excel?

Unattended Import to an excel spreadsheet
 

you can use a macro that uses an OnTime event

Sub RunMacroOnTime
Application.OnTime TimeValue("17:00:00"), "my_Procedure"
End Sub

You would then code my_Procedure to load your spreadsheet


--
mudraker
------------------------------------------------------------------------
mudraker's Profile: http://www.excelforum.com/member.php...fo&userid=2473
View this thread: http://www.excelforum.com/showthread...hreadid=532462

Unattended Import to an excel spreadsheet
 

Thanks for your imput. I guess I didn't really explain what I need to
do correctly. I really want to use a batch file to trigger the import
of a sequential file. Any suggestions on how to do that?