How to get value within an Excel workbook in Sharpoint into Active workbook

Question

I have an excel workbook that needs to get data from an excel workbook hosted in a Sharepoint document library. Creating a list from the source file is not an option :/

I am able to open the source excel file but I don't want the user to see it opening.

In that case I'd suggest that you copy the file locally:msdn.microsoft.com/en-us/library/2s1c774y(v=vs.90).aspx and then access the file (without opening it) using ADO: stackoverflow.com/questions/39415326/… Afterwards you can delete the local copy of that file. — Ralph
The solution was surprisingly simple. Turning off screen update was enough, assumed it would not apply for newly opened workbooks. — Thor

Thor Thor · Accepted Answer · 2017-03-28T08:03:16

Surprisingly simple.

Application.ScreenUpdating = False

Was also thinking it would be a performance issue creating a whole workbook process but works without a hitch.

How to get value within an Excel workbook in Sharpoint into Active workbook

1 Answers