Automatic import and export of data from OneDrive to new workbooks

MKleuver

New Member
Joined
Mar 1, 2022
Messages
1
Office Version
  1. 365
Platform
  1. Windows
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!
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
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
VBA Code:
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)
 
Upvote 0

Forum statistics

Threads
1,213,539
Messages
6,114,221
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top