+ Reply to Thread
Results 1 to 3 of 3

Unattended Import to an excel spreadsheet

  1. #1
    dataguy
    Guest

    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?


  2. #2
    Valued Forum Contributor mudraker's Avatar
    Join Date
    11-10-2003
    Location
    Melbourne, Australia
    Posts
    3,983
    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

  3. #3
    dataguy
    Guest

    Re: 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?


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1