Burnt_Fingers
New Member
- Joined
- Feb 6, 2020
- Messages
- 1
- Office Version
- 365
- Platform
- Windows
Hi All,
I've been looking for quite some time to get some help about a tiny project I work on.
So the task is to connect to specified sharepoint folder that will contain unknown number of excel files. Out of each of those files I need to pull data from a fixed set of cells. I have my script up and running but im rather unsatisfied with its pace. Currently I have 15 files, im pulling data from 9 cells from each of them and it takes ~45sec to execute from double clicking the file to getting results. I'm afraid that if the fileCount will grow it will become rather unusable . It seems that it creates individual links to each cell and that is killing my performance. Is there any way to establish lasting connection to perform all the operations and close the connection afterwards instead of reconnecting to each cell individually ?
In case you ask - mapping to local drive is not an option. This script will be distributed globally to people with minimal or no proficiency with computers and OS .
I've been looking for quite some time to get some help about a tiny project I work on.
So the task is to connect to specified sharepoint folder that will contain unknown number of excel files. Out of each of those files I need to pull data from a fixed set of cells. I have my script up and running but im rather unsatisfied with its pace. Currently I have 15 files, im pulling data from 9 cells from each of them and it takes ~45sec to execute from double clicking the file to getting results. I'm afraid that if the fileCount will grow it will become rather unusable . It seems that it creates individual links to each cell and that is killing my performance. Is there any way to establish lasting connection to perform all the operations and close the connection afterwards instead of reconnecting to each cell individually ?
In case you ask - mapping to local drive is not an option. This script will be distributed globally to people with minimal or no proficiency with computers and OS .
