Open All Files in a Folder

Back to index page
  1. After pressing the Open button in ribbon Open file dialog opens. Scroll down to All Files *.* option and select all files in a folder.

 

Form.Open_All_Files

 

 

  1. You can decide if you would like to open the files on the same or on a separate worksheet. By default the "Merge files onto a single worksheet" check-box is not selected, so each file will be opened on a separate worksheet.
  2. After pressing Open, a progress bar appears informing the user about the status of the open process.

 

Open.ProgressBar

 

  1. All the files available in the folder will be displayed on a new sheet, the sheet named after the files' names and all structures with all corresponding data will be displayed on the appropriate sheet, respectively.

 

Form.Open_Spreadheets


Back to index page