Hello,
I have two worksheets, each with multiple tabs, and I need to combine all tabs from both worksheets into one. Unfortunately, both files are located on a SharePoint drive. I wish I had physical access instead, but this is what I'm working with. I attempted to start a blank query and entered the following in the formula bar: "Excel.Workbook(File.Contents("File Path that I cannot share"))", but that didn't work. What other ways can I go about it?
Last edited by kyber; 03-05-2024 at 12:10 PM.
best guess would be to utilize power query and go after the sharepoint folder.
<----- If you are happy with your solution please click on the "* Add Reputation" as a way to say thank you.
I tried that route you displayed in the screenshot and this is the error message I'm receiving...
Details: "The input URL is invalid. Please provide a URL to the root of a SharePoint site, or to the service document or entity of its OData feed (with no query or fragment part)."
Not sure what to do about it because I'm copying and pasting the link directly from what it's providing me with.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks