Using Refresh All in Macro

Seth Wolf posted at 09-May-08 03:52
I'm using Refresh All in a Macro to import information from a text file into the workbook.  The problem is that when the macro runs, it brings up a window to browse for the text file.  Since the text file is always the same name and always in the same place, isn't there any way to automate the selection of the file as I don't want to have to have user involvement to select the file?  Thanks.



Click here to sign in and reply. You could earn money via our $500 contest just for being helpful.
  Using Refresh All in Macro - Seth Wolf  09-May-08 03:52 3:52:35 PM
      GetOpenFileName - sundar k  09-May-08 11:02 11:02:59 PM
          Refresh All automation - Seth Wolf  12-May-08 11:20 11:20:12 AM
View Posts