richard smith

richard smith

  • 1.4k
  • 285
  • 160.2k

Excel.Workbook.RefreshAll()

Feb 15 2013 3:58 PM
I am using this to refresh some queries in an Excel workbook, but sometimes there is an odbc error or an issue.  I know you can count for that in a try/catch block, but I do not want to do that because it will stop processing at the 1st error.  Is there a way to set the RefreshAll(); statement with parameters to ignore errors so all data is refreshed in the workbook?

Answers (7)