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?
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?
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
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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks