I am working with a file that uses an OLEDB connection and then using various CUBE formula's and functions in creating reports. And I have a script that will create the OLEDB connections. And to connect to the OLEDB you need the UserName, PW, and URL address. Currently, in testing I have those in a worksheet, and the script creating the connections using a variable to read those cells.

Now, I'm hoping to have the script read the User, Pass, and URL from a file hosted in my onedrive and limit the read access on that file to only those in my organization.

Does anyone have any sample code in reading a cell from a OneDrive File? ie, Read Cell A1 from Sheet1?

Thanks,
PT