title: Reset Default Workbook Open options
body: <p>I use VBA in Excel to pull data from different sources (mostly .csv and .xls/.xlsx files) and paste them into my data tables (in the same Excel File I have a data table for each specific data source).</p>
  
  <p>Each of those files comes with different settings. I have created an specific VBA Macro for each of my data sources to process, remove and copy the relevant information of each individual file, and then I call all of the Macros from another Macro. The problem I'm having is that for one of the data sources, when using the <code>Workbooks.Open</code> method, I have had to set the parameter Format to "Nothing" (<code>Format:=5</code>). But this affects then the subsequent macros and therefore the following files are not processed correctly.</p>
  
  <p>I know I have two possibilities: Either I call this macro at the end, after I've processed all the other files or; I set the Format parameter in all of my Macros to the one specific for each of the files configuration. However there must be a way to simply reset the delimiter to the default one used in my Regional Settings. Does anyone knows a solution?</p>
  
  <p>Sorry if there's already a thread with this issue but I've tried looking for it and didn't find any.</p>
  
  <p>Thank you in advance.</p>