0

I have an excel spreadsheet (call it SS-A) connected to a data source which is another excel spreadsheet (call it SS-B). I also have another spreadsheet (call it SS-C) identical to SS-B. If there is an error in the connection to SS-B, I want SS-A then to connect to SS-C.

Thus I would like something like this,

If SS-B Connection Error Then
  connect to SS-C
ELSE
  connect to SS-B
End If

I am not sure how to implement something like this using Excel VBA, because the result, whether the connection is SS-B or SS-C must be placed in the same sheet in SS-A.

Jason Samuels
  • 951
  • 6
  • 22
  • 40

1 Answers1

1

@Jason I think you can use "On error statement" for your scenario.

Public sub Connection()
On Error GoTo ErrorHandler
' Insert your connection code to SS-B
Exit Sub
ErrorHandler:
' Insert connection code to SS-c
Resume Next 
End Sub

If your connection code to SS-B throws any error, it will try to connect to SS-C.

For generating code to connect to another data source, please check following link VBA Code to connect to external data source. Hope it might help you.

Thanks,
Raj

Community
  • 1
  • 1
Raj
  • 664
  • 7
  • 23