You can directly copy the URL from the address bar of your browser when your that file is in open mode. The URL should be put between double quotes in Importrange formula. The second part of the formula is the range to import. The range should include the tab name. I have infinite data under column A, B, C, D, E, and F, so I put the range A:F.
For More Information Please Refer:
You May Also Like to Read: