Question: I have an Angular app that uses Firebase Authentication for logging in and then reading and writing data to a Firestore database. I want to do some e2e tests for it.

I would rather write the tests with mocked data or a local server. 

I haven't found any local way of running Firestore so far.
I saw that you can stub out methods with cy.stub, but it's unclear to me how to do that with Angular2. How do I get a hold of the object that I want to stub out methods in? In the real code they are dependency injected in the constructor

Or what is the preferred way of writing Cypress e2e test with Angular and Firebase (AngularFire2)? Any good recommendations?

Thanks

Answer: 
List all the sheet names and see if they are what you think they are. 

```
Sub SheetNames()
Columns(1).Insert
For i = 1 To Sheets.Count
    Cells(i, 1) = Sheets(i).Name
Next i
End Sub

```
Can you try this? Modify to suit your needs. Also, can you get rid of the '!' symbol, at least for testing purposes. Make it work in a simple context, and then you can work your way up to more and more complex things. Usually it's not a good idea to start with more complex things, unless you are really confident that you know what you are doing.

```
DoCmd.TransferSpreadsheet acLink, 3, _ 
 "Employees","C:\Lotus\Newemps.wk3", True, "A1:G12"

```

This is a good resource for topics pertaining to DoCmd.TransferSpreadsheet.

<http://access-excel.tips/access-vba-cocmd-transferspreadsheet/>