Automatic import and export of data from OneDrive to new workbooks

[MKleuver]

Hello everyone,

I'm currently making a workbook for my engineering team within motorsports to work in a more efficient way and make a simple report of everything that's happening.

Now I've ran into an issue:
For every event we make a new workbook for a certain driver on a certain track (selected on the first sheet).
After this is filled in, I want the data from a previous event pulled into the sheet, from a seperate workbook. Afterwards fill in more data and export it to the seperate workbook, so it's up to date for the next time again.
The data consists of a table from E5:AZ28 filled with formulas linked to other worksheets. It can be overwritten, once filled in.
All used documents are on OneDrive, so they are available to all team members.

Is such a thing possible?
My querie & ActiveX skills are close to zero unfortunately.

Thanks for your help already!

 

[BSALV]

there is, as far as I know, no difference in working between a normal directory on your harddrive and a directory of Onedrive.
Instead of looking in the path "c:\....\..." that's now "https:// .../abcde12345/" with the last bold part as variable for everybody's personal OneDrive-directory.

As you said, all those data are common for the whole team, then that bold part is common for all teammembers and all laptops.

In excel, you only have to write that parameter once as a global variable
something like this in a normal module

Global Const My_OneDrive_Path_MotorTeam = "https://d.docs.live.net/abcde12345/"     'declare it for the whole workbook-VBA

Sub test()

     Workbooks.Open Filename:=My_OneDrive_Path_MotorTeam & "Example%20age%20of%20product.xlsx"
     MsgBox "the rest of your program"

End Sub

The rest is no difference with working in a regular drive. (i think, no experience)